php数据批量导入csv文件(示例)
时间：2021-07-01 10:21:17
帮助过：50人阅读
/**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."秒";
- ?>
|
