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 receive a request from our reader to create simple realtime chart update but without page refresh. Fortunately there are many solutions to do this, but now we will cover using a nice flash charting component called FusionCharts. FusionCharts comes with several edition, but now we will use the FusionCharts Free version. You can download it from http://www.fusioncharts.com/free/. By the time of this writing, FusionCharts Free version is 2.2. Continue reading ‘Create Realtime Chart Without Page Refresh using FusionCharts Free and Ajax (prototype.js)’ »

In previous article, Read Fingerprint Attendance Data ‘1_attlog.dat’ Using PHP and Transfer to MySQL, we already talk about importing the fingerprint time attendance data ‘1_attlog.dat’ to MySQL table for further process. Now we will try to import the data to OrangeHRM. OrangeHRM is open source Human Resources software that run using PHP + MySQL platform. OrangeHRM consists several module that can help to manage human resource operation, such as leave management, time attendance management, salary management and employee data. Continue reading ‘Import Fingerprint Data ‘1_attlog.dat’ to OrangeHRM Table ‘hs_hr_attendance’ 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’ »

We will cover about creating simple login mechanism using PHP and MySQL. Login usually used to seperate the public access page and secured page. Sample of public page is for example like public home page, public profile page, about page, contact page etc. Secured page for example like user profile settings page, user accounts page etc. The point is everything that only specific user can view is considered secured page.The page that displayed after the login screen is secured page. Continue reading ‘Creating Simple Login System in PHP’ »

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’ »

During our experiment using fingerprint device X100 we need to read the time attendance log data. The device has option to download the time attendance data to USB flash disk. Continue reading ‘Read Fingerprint Attendance Data ‘1_attlog.dat’ Using PHP and Transfer to MySQL’ »

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’ »