How To Import CSV File Into MySQL Using PHP

In this php post, I am discussing how to import csv file into MySQL database table using PHP.CSV stands for “Comma Separated Values” and contains all data in comma separated.

It’s a very common task for every application which has too much database and needs to import into MySql.

I am using two files one is index.php file which will contain UI part to show upload CSV file and import_csv.php file to connect MySQL and parse CSV data and store into MySQL table.

Video Tutorial

If you are more comfortable in watching a video that explains about How To Import CSV File Into MySQL Using PHP, then you should watch this video tutorial.

Normally, We need to import data into database then we used following file types.

Xml file
CSV file
Excel file

To import data through CSV file into MySQL Database table.I am doing following steps to import data from CSV file into MYSQL using PHP Script code.

You can also check other tutorial of Export/Import Data with PHP,

Steps to import CSV file into MySql database using PHP

Step 1: Create import_csv.php and put below code into this file.

<?php
if(isset($_POST["submit"]))
{
$host="localhost"; // Host name.
$db_user="root"; //mysql user
$db_password=""; //mysql pass
$db='phpDB'; // Database name.
//$conn=mysql_connect($host,$db_user,$db_password) or die (mysql_error());
//mysql_select_db($db) or die (mysql_error());
$con=mysqli_connect($host,$db_user,$db_password,$db);
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


echo $filename=$_FILES["file"]["name"];
$ext=substr($filename,strrpos($filename,"."),(strlen($filename)-strrpos($filename,".")));

//we check,file must be have csv extention
if($ext=="csv")
{
  $file = fopen($filename, "r");
         while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
         {
            $sql = "INSERT into tableName(name,email,address) values('$emapData[0]','$emapData[1]','$emapData[2]')";
            mysqli_query($con, $sql);
         }
         fclose($file);
         echo "CSV File has been successfully Imported.";
}
else {
    echo "Error: Please Upload only CSV File";
}


}
?>

<?php

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

{

$host="localhost"; // Host name.

$db_user="root"; //mysql user

$db_password=""; //mysql pass

$db='phpDB'; // Database name.

//$conn=mysql_connect($host,$db_user,$db_password) or die (mysql_error());

//mysql_select_db($db) or die (mysql_error());

$con=mysqli_connect($host,$db_user,$db_password,$db);

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

echo $filename=$_FILES["file"]["name"];

$ext=substr($filename,strrpos($filename,"."),(strlen($filename)-strrpos($filename,".")));

//we check,file must be have csv extention

if($ext=="csv")

{

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

while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)

{

$sql = "INSERT into tableName(name,email,address) values('$emapData[0]','$emapData[1]','$emapData[2]')";

mysqli_query($con, $sql);

}

fclose($file);

echo "CSV File has been successfully Imported.";

}

else {

echo "Error: Please Upload only CSV File";

}

Below code is used for creating interface to upload CSV file.
Step 2: Create a new index.php file to display csv upload form.You need to put below code into index.php file.

<form enctype="multipart/form-data" method="post" action="import_csv.php">
<table border="1">
<tr >
<td colspan="2" align="center"><strong>Import CSV file</strong></td>
</tr>
<tr>
<td align="center">CSV File:</td><td><input type="file" name="file" id="file"></td></tr>
<tr >
<td colspan="2" align="center"><input type="submit" value="submit"></td>
</tr>
</table>
</form>

<tr >

<td colspan="2" align="center"><strong>Import CSV file</strong></td>

</tr>

<tr>

<tr >

</tr>

</table>

</form>

6 thoughts on “How To Import CSV File Into MySQL Using PHP”

joe says:

December 7, 2013 at 11:51 am

Thanks for the snippet. It is very helpful. I recommend including/adding the rest of the html page so that folks can just copy, paste and use it “as-is”.

- Parvez says:
  
  October 5, 2015 at 9:30 am
  
  thanks, i separated for easy understand.
  
phpflow says:

October 26, 2017 at 4:34 pm

its working

Rich Williams says:

September 13, 2019 at 2:41 pm

Where does the csv file live , so that the code can find it in the directory when it runs the import? thx

- Parvez says:
  
  September 22, 2019 at 3:48 pm
  
  Right now user can select csv file from any folder but as per your scenario, you can store csv file into root directory of project
  
waseem says:

October 24, 2019 at 11:23 am

it is useful