php資料大量匯入csv檔案(樣本)

/**php匯入csv檔案到資料庫*** *同時計算程式執行時間 ***/ //定義擷取時間函數 function getmicrotime(){ list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); } $time_start = getmicrotime(); include("db.inc.php");//串連資料庫 $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語句執行成功！ "; $sql="insert into scores(idcard,names,num,sex,nation,score) values(\'"; } fclose ($handle); $time_end = getmicrotime(); $time = $time_end - $time_start; echo "程式執行時間：".$time."秒"; ?> 複製代碼

