Sony AK Knowledge Center

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

Here is simple example about how to do a file upload using PHP. First let’s create the HTML page for upload form. Continue reading ‘How to Upload File in PHP’ »

Here is the simple example about how to update Facebook status from PHP. We use different approach, just login to Facebook mobile and change the status. It’s simple and fun. Continue reading ‘Updating Facebook Status from 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’ »

Here is the simple example of extracting a tar.gz file on linux or Unix machine. Continue reading ‘Example Command to Extract tar.gz File’ »

Sometimes we need to do a batch download, for example like download from specified URL but the files are from 1.jpg to 100.jpg. Previously we think that we should use special software to do this, but finally now we can do batch download using DownThemAll!, Continue reading ‘Doing Batch Download using DownThemAll! Add-on for Firefox’ »

Sometimes you need to do screen capture on your computer. What is great software to do that? We found small neat application for screen capture, it’s called MWSnap. You can download it from http://www.mirekw.com/winfreeware/mwsnap.html. It’s totally freeware and it can do many things on screen capture. Such as capture window or even only specific screen region triggered by special hotkey. Continue reading ‘Easy Screen Capture on Windows using MWSnap’ »

Somebody ask about how to get monitor screen resolution using PHP. No, PHP has no relation with screen at all. But you can do it using Javascript. Here is the code. Continue reading ‘How to Get Monitor Screen Resolution using Javascript’ »

Through this article we will cover simple example of doing Ajax operation using ajax() method on jQuery. jQuery is one of popular Javascript library in the world. Continue reading ‘Sample of Ajax Operation using ajax() Method on jQuery’ »