PHP data batch import csv file (example)

/**PHP imports csv files into the database ***
* and calculates the program execution time at the same time
***/
//Define 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 the 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";
?>