| <?php
/*****************************************
Author: Chong Xing/arcow****************
njj@nuc.edu.cn*******************
PHP import CSV file to database **********
Simultaneous calculation of program execution time ***********
www.111cn.net***********
****************************************/
Define Get Time function
function Getmicrotime () {
List ($usec, $sec) = Explode ("", Microtime ());
Return ((float) $usec + (float) $sec);
}
?> <?php
$time _start = Getmicrotime ();
Include ("db.inc.php");//Connect database
$db =new testcsv;
?>
<?php
$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 "<br>"; The
Echo $sql. <br> ";
$db->query ($sql);
Echo SQL statement executed successfully! <br> ";
$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 ";
? |
