PHP Data Bulk Import CSV file (example)

/**php Importing a CSV file to a database * * * * Simultaneous calculation of program execution time ***/ Defining the Get Time function function Getmicrotime () { List ($usec, $sec) = Explode ("", Microtime ()); return (float) $usec + (float) $sec); } $time _start = Getmicrotime (); Include ("db.inc.php");//Connect to Database $db =new testcsv; $handle = fopen ("Test.csv", "R"); $sql = "INSERT into scores (Idcard,names,num,sex,nation,score) VALUES (\ '"; while ($data = Fgetcsv ($handle, 1000, ",")) { $num = count ($data); for ($c =0; $c < $num; $c + +) { if ($c = = $num-1) {$sql = $sql. $data [$c]. " \ ') "; break;} $sql = $sql. $data [$c]. " \',\'"; } Print " "; echo $sql. " "; $db->query ($sql); echo "SQL statement executed successfully! "; $sql = "INSERT into scores (Idcard,names,num,sex,nation,score) VALUES (\ '"; } Fclose ($handle); $time _end = Getmicrotime (); $time = $time _end-$time _start; echo "Program execution Time:". $time. " Seconds "; ?> Copy Code

