Sony AK Knowledge Center

One of very common feature on a community or social network website is ‘forget password’ feature. What the hell is that? Well, it’s seems this feature is not important, but actually it will be useful if the member of the site was forgot their password. How to create a simple but quite good ‘forget password’ feature? As usual, we will need a scenario to reproduce our problem. But before we talk about the scenario, we will cover about our ‘forget password’ mechanism first. Continue reading ‘Create a Simple ‘Forget Password’ Feature using PHP’ »

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 sample of using CASE statement on MySQL. Suppose you have table on MySQL like this. Continue reading ‘Using CASE Statement on MySQL’ »