Importing data from CSV file into MySQL database

Posted by Syed Hyder Ali on November 8, 2009

If you are having a .CSV file format from which you want to import data into the MySQL database, you can do it in two ways:

1. If you have access to phpmyadmin panel then simply you can import the data from a CSV file into the database.

2. Other method is to generate a PHP script through which you can upload the CSV data into the database. This type of functionality usually found in Portals or database driven applications in which the users need to upload data into the database without using phpmyadmin panel.

Here is an open source PHP script which you can use it in your web applications to implement the feature of data importing from CSV files into the MySQL database.

Click here to download PHP Script for Importing data from CSV files.

If you want to get the updates from winwinmantra.com regarding the free components, click here to Subscribe.