MySQL to RSS feed(XML)-Used in Google Product Search

Hello Friends !!

In my last post, I explain you how to export data from MySQL to tab formatted TXT file.

I think you all aware about Google Product Search.

In Google Product Search, which is used for search any product around the world. Currently many shopping sites stores their products in Google Product Search.

For store data in google product search, Google supports txt and xml (RSS) file.

Now I make one another script which used to export data from MySQL to RSS (XML). Actually google product also preffer RSS feed.

For this you have to create one datafeed.xml and save this file where PHP script file is stored. Here I give you code :
Click Here for more details :
Continue reading »

Take Backup of MySQL database using PHP

Hello Friends !!

Generally we take backup of our MySQL database using import/Export option in phpMyAdmin.

But Suppose, you have to take backup every day or every hour, this technique is time consuming. It takes more time.

There is one way to take backup which take less time. We can take backup using PHP code. When you run this code, This code create one backup file automatically which ia easily import in database when you want.

I write that PHP code below. Simply you have to copy this code and paste in you PHP file.
Continue reading »

MySQL table to CSV – PHP Script

Hello Friends !!

If you want to export data from MySQL table to CSV file ,then don’t worry. I will provide you one script. When you run this script, data in table are stored in CSV file.

Here i give you code of the PHP script. You have to just copy that code and paste in your PHP file and run that file.
Continue reading »

Export from CSV to MySQL table – PHP Script

Hello Friends !!

In my later post on Export data from MS EXCEL sheet to MySQL table – PHP Script , i explained how store data from MS EXCEL sheet to MySQL table.

Today I will give you PHP code for store data from CSV file to MySQL table. You have to just make one PHP file, copy code displayed below and paste in that file. After this just run that PHP script.
Continue reading »