Free Android CakePHP GMaps Articles by Bali Web Design

Sometimes we want to add a page break on specific part on the page for printing. We can do it with simple css method for adding page break on specific part that you want a page break is occur.

So when you need to add page break on specific place, you just need to add this html code :

<p style="page-break-before: always">

on part that you want a page break occur.

for example :

<p>This is page 1</p>
<p style="page-break-before: always">
<p>This is page 2</p>

If we print this html, we will have two pages printed.

Sometimes we have data in a field on our table like this “1,2,3,4,5,6,7”, and we want to search for example number 2. Beside doing searching inside php, we can do it in sql query. I found one function for retrieving position of a value inside a set : FIND_IN_SET(str,strlist).

So the query will look like this :

SELECT * FROM table_name WHERE FIND_IN_SET(2, field_name) > 2;

This query will return all recordset that have number 2 in field_name set.

Another way to searching a value inside a set, is by manipulating on how we save the set in field. So if we want to save a set of “1, 2, 3, 4, 5, 6, 7”, we will save it as “<1>,<2>,<3>,<4>,<5>,<6>,<7>” in database. And doing query using this method :

SELECT * FROM table_name WHERE field_name LIKE ‘%<2>%’;

but of course the first way is more faster. because first way we search value in array / set, but second way search value in string.

Sometimes we need to copied a small pieces of one table to another table. Usually we run SELECT FROM source table first, and then iteratively add into target table, the query is something like this

mysql_query(‘SELECT id, name, address FROM member’);

and then using php, we add all results into target table

mysql_query(‘INSERT INTO target_table(id, name,date_f) VALUES (‘. $id .’, ‘. $name .’, NOW())’);

but using this way we need at least 3 lines code and it is not efficient, there is another way to do that more efficient. Mysql has INSERT INTO SELECT FROM query command, the query will look like below

mysql_query(‘INSERT INTO target_table (id, name, date_f)
SELECT source_table.id, source_table.name, NOW()
FROM source_table;’);

if you want to overwrite old value, you can use REPLACE instead INSERT.

Sometimes we need to find current URL for processing on script. URL is construct by three component :

1. Domain name : www.domain.com
2. Script name : index.php
3. Query string : parameter on url, example component=member&task=edit

Using $_SERVER variable we can get this all information and construct it to get full URL. We need to retrieve value ‘HTTP_HOST’, ‘SCRIPT_NAME’ and ‘QUERY_STRING’ on $_SERVER array. Here is the code :

$url = “http://” . $_SERVER[‘HTTP_HOST’] . $_SERVER[‘SCRIPT_NAME’] . “?” . $_SERVER[‘QUERY_STRING’];

this script produce complete current url, if you don’t need host to be included you can just use values from $_SERVER[‘REQUEST_URI’];

As my other new website, i always create an introduction text about the site purposes beside of using this standard text after wordpress installation.

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

I would like to describe my skill background. I were graduated from Christian Duta Wacana University at Jogjakarta. I took Information technology faculty. Basically i learn about how to program and at the end of study, i learn more about Internet and Multimedia. So i start to join to internet club on my campus named UKDWNet Club and got basic experience about how to build and manage a website. I’m very excited at that time, so i am focusing on web programming.

After graduated i join to outsourcing company from Germany that handle big project for desktop application and web application. And during this time i get more experience about programming using Delphi, .NET and PHP. Now i am a senior PHP programmer in this company. I forgot to mention the company, it is named Probypro Digitals Solution. And i still join to this company until now.

Beside my full time work at Probypro, i also do some freelance project with other IT company in Bali, such as Bengkel Media Group, Barefoot, and other company that even doesn’t have named, ;)

So this site is my first publication of my skill, hope that i can help you to grow your business using IT Solution. Oh ya i would like to say great thanks to Janumedia for encouraging me to publish my skill and post some article related with software development.

In the next days i would like to post some article about programming and internet stuff. Feel free to contact me for support.

Wishes all best for you.

Mario Cahyadi
Owner of Bali Stupa