Sony AK Knowledge Center

Now we will cover about how to create simple data paging using PHP and MySQL. Sometimes you have to display large set of data on the web page. Using data paging, you can display your data page-by-page and you can define how many data should be displayed on each page. Let’s start our mission. Continue reading ‘Create Simple Data Paging using PHP and MySQL’ »

We will talk about how to do backup and restore on MySQL database using mysqldump utility. Sometimes you need to copy or backup your MySQL database from one machine to another. Fortunately you can do backup easily on MySQL using mysqldump utility.

Let’s assume you have database called ‘your_database_1′ on machine A and you want to backup and restore it on machine B. We will dump your database using mysqldump. Dumping here means extract your database into lines of SQL statement including all structures and data. Continue reading ‘Backup and Restore MySQL Database using mysqldump’ »

Somebody asking about how to create table structure to store multilevel category data. Here is the scenario. For example you will create an online article system and each article will have specified category. So how about the table structure to handle this? Continue reading ‘Create Table Structure for Storing Multi Level Category Data’ »

Here is the way to set table column width using CSS. Continue reading ‘How to Set Table Column Width using CSS’ »