Sony AK Knowledge Center

In my organization, there are so many internet domains that have to be monitored, especially on their expiration date. To make my life easy, I create little dashboard to monitor the domain expiration. It just shows simple domain list, its expiration date and how many days or months left before expiration. How to create such this simple dashboard? Just follow this article. Continue reading ‘Create Simple Dashboard for your Domain Expiration Information’ »

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

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

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