php数据批量导入csv文件(示例)

3. /**php导入csv文件到数据库***

4. *同时计算程序执行时间
5. ***/
6. //定义获取时间函数
7. function getmicrotime(){
8. list($usec, $sec) = explode(" ",microtime());
9. return ((float)$usec + (float)$sec);
10. }

11. $time_start = getmicrotime();

12. include("db.inc.php");//连接数据库
13. $db=new testcsv;

14. $handle = fopen ("test.csv","r");

15. $sql="insert into scores(idcard,names,num,sex,nation,score) values(\'";
16. while ($data = fgetcsv ($handle, 1000, ",")) {
17. $num = count ($data);
18. for ($c=0; $c if($c==$num-1){$sql=$sql.$data[$c]."\')";break;}
19. $sql=$sql.$data[$c]."\',\'";
20. }
21. print "
    ";
22. echo $sql."
    ";
23. $db->query($sql);
24. echo "SQL语句执行成功！
    ";
25. $sql="insert into scores(idcard,names,num,sex,nation,score) values(\'";
26. }
27. fclose ($handle);
28. $time_end = getmicrotime();
29. $time = $time_end - $time_start;
30. echo "程序执行时间：".$time."秒";
31. ?>

复制代码