<?php

session_start();

$db = mysql_connect("localhost", "username", "password") or die("Could not connect.");

if(!$db) 

	die("no db");

if(!mysql_select_db("database_name",$db))

 	die("No database selected.");

?>

include "connect.php";

if(isset($_POST['submit']))

   {

     $filename=$_POST['filename'];

     $handle = fopen("$filename", "r");

     while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)

     {

    

       $import="INSERT into info(name,address,food) values('$data[0]','$data[1]','$data[2]')";

       mysql_query($import) or die(mysql_error());

     }

     fclose($handle);

     print "Import done";

 

   }

   else

   {

 

      print "<form action='import.php' method='post'>";

      print "Type file name to import:<br>";

      print "<input type='text' name='filename' size='20'><br>";

      print "<input type='submit' name='submit' value='submit'></form>";

   }

$import="INSERT into info(name,address,food) values('$data[0]','$data[1]','$data[2]')";

$import="INSERT into info(name,address,food) values('$data[2]','$data[1]','$data[0]')";

  This tutorial will show you how to import csv data into MYSQL with a simple PHP script.

Many times you have to write a script because the import function in phpMyAdmin will not import

the way you want.



First you will need a connection into the MYSQL database in connect.php:



Code:








This is a basic database connector, insert your username, password, and dataname where mentioned.



Now we need to do a few steps to import:

1. Open the CSV file to import

2. Read the data line by line

3. Store each line of data into a coma-delimited array

4. Insert individual pieces of the array into the desired SQL fields



So here's the code in the import.php file to do that:



Code:


include "connect.php";

if(isset($_POST['submit']))

   {

     $filename=$_POST['filename'];

     $handle = fopen("$filename", "r");

     while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)

     {

    

       $import="INSERT into info(name,address,food) values('$data[0]','$data[1]','$data[2]')";

       mysql_query($import) or die(mysql_error());

     }

     fclose($handle);

     print "Import done";

 

   }

   else

   {

 

      print "";

      print "Type file name to import:";

      print "";

      print "";

   }





So if it does not detect a submit button, it simply prints out an form asking you to type in the uploaded CSV file to import. For this particular example to work, the .CSV file needs to be in the same directory as import.php and needs to have read permissions on. If your .CSV file is called file.csv, then type file.csv in the text box.



After you push submit it create a variable $handle that contains the actual .CSV file. fopen simply opens the file you specified for reading. The while loop says that as long as there are more lines, read the file line by line, store each line into an array called $data. Note the parameters in this example specify that each row of data is at most 1000 characters long and is coma delimited by field. If your data rows are more than 1000 characters long or are not delimited by coma, you can simple change those two fields.



For this example I'm using a MYSQL table called info with the fields name,address, and food.



Now the data in each row is stored lik this: The data before the first coma is stored in $data[0], the data between the first and second coma is stored in $data[1], the data between the second and third coma is stored in $data[2] and so on. 



Now the actual SQL insertion:



Code:


$import="INSERT into info(name,address,food) values('$data[0]','$data[1]','$data[2]')";





This inserts the data stored in $data[0] into name, $data[1] into address, and $data[2] into food. Note that elements of the array do not have to be inserted in order. If food was the first element in the array and name was the third, the insertion would look like this instead:



Code:


$import="INSERT into info(name,address,food) values('$data[2]','$data[1]','$data[0]')";





Thats it for .CSV imports into MYSQL via PHP. You can extrapolate this for however many fields of data and MYSQL table fields you need.