-
-
/**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."秒";
- ?>
-
|
