How to use PHP & Upload and Convert/Import CSV To MySQL

Author: admin | Posted: 23-03-2010 | Category: PHP & CSV

How to use PHP & Upload and Convert/Import CSV To MySQL Learn / tutorial php programming how to using PHP Upload and Convert/Import CSV To MySQL

ShotDev Focus:
- PHP Upload and Convert/Import CSV To MySQL.

Example

php_csv_mysql_upload1.php


<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form action="php_csv_mysql_upload2.php" method="post" enctype="multipart/form-data" name="form1">
<input name="fileCSV" type="file" id="fileCSV">
<input name="btnSubmit" type="submit" id="btnSubmit" value="Submit">
</form>
</body>
</html>

php_csv_mysql_upload2.php


<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<?
copy($_FILES["fileCSV"]["tmp_name"],"shotdev/".$_FILES["fileCSV"]["name"]); // Copy/Upload CSV

$objConnect = mysql_connect("localhost","root","root") or die(mysql_error()); // Conect to MySQL
$objDB = mysql_select_db("mydatabase");

$objCSV = fopen("shotdev/".$_FILES["fileCSV"]["name"], "r");
while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
$strSQL = "INSERT INTO customer ";
$strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) ";
$strSQL .="VALUES ";
$strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."' ";
$strSQL .=",'".$objArr[3]."','".$objArr[4]."','".$objArr[5]."') ";
$objQuery = mysql_query($strSQL);
}
fclose($objCSV);

echo "Import completed.";
?>
</body>
</html>

Create a php file and save to path root-path/myphp/

Run
http://localhost/myphp/php_csv_mysql_upload1.php

Screenshot