How to Import the contents of CSV files into MySQL Database using PHP

Step1: create a database with name test and create table user
Step2: Put a csv file (which you want to import) into your document

root.
Step3: Established database connection and first open the file in read

mode, using fgets () all data will be collected in an array and that

array will be stored in database.

Create user table:

CREATE TABLE IF NOT EXISTS `user` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, PRIMARY KEY (`ID`) )

Code For csv-import.php:

<?php   $connect = mysql_connect('hostname','username','password'); if (!$connect) { die('Could not connect to MySQL: ' . mysql_error()); }   $cid =mysql_select_db('test',$connect); // supply your database name   define('CSV_PATH','C:/xampp/htdocs/csvfile/'); // path where your CSV file is located   $csv_file = CSV_PATH . "infotuts.csv"; // Name of your CSV file $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 0; while (!feof($csvfile)) { $csv_data[] = fgets($csvfile, 1024); $csv_array = explode(",", $csv_data[$i]); $insert_csv = array(); $insert_csv['ID'] = $csv_array[0]; $insert_csv['name'] = $csv_array[1]; $insert_csv['email'] = $csv_array[2]; $query = "INSERT INTO csvdata(ID,name,email) VALUES('".$insert_csv[ID]."','".$insert_csv['name']."','".$insert_csv   ['email']."')"; $n=mysql_query($query, $connect ); $i++; } fclose($csvfile);   echo "File data successfully imported to database!!"; mysql_close($connect); ?>