-
-
/**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 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."秒";
- ?>
-
复制代码
|
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
作者最新文章
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31