我有个例子,很好用,你自己改改就可以导了~~
<?phpfunction getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}$time_start = getmicrotime();include ("connectdb.php");
function insert_data ($id,$summary,$description,$additional_information,$category) {
$my_query1 = "insert into mantis_bug_text_table (id,description,additional_information)
values ('$id','$description','$additional_information')";
$first = mysql_query($my_query1); $my_query2 = "insert into mantis_bug_table (id,project_id,summary,bug_text_id) values ('$id','$category','$summary','$id')";
$second = mysql_query($my_query2);
return;
}$fp = fopen("test.csv","r");while($data = fgetcsv($fp,'1000',',')){ insert_data ($data[0],$data[1],$data[2],$data[3],$data[4]);
echo "<font color = #FF0000 size = 20>数据导入成功!</font><br><br>";
}
fclose ($fp);$time_end = getmicrotime();$time = $time_end - $time_start;echo "程序执行时间:".$time."秒";
?>
<?phpfunction getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}$time_start = getmicrotime();include ("connectdb.php");
function insert_data ($id,$summary,$description,$additional_information,$category) {
$my_query1 = "insert into mantis_bug_text_table (id,description,additional_information)
values ('$id','$description','$additional_information')";
$first = mysql_query($my_query1); $my_query2 = "insert into mantis_bug_table (id,project_id,summary,bug_text_id) values ('$id','$category','$summary','$id')";
$second = mysql_query($my_query2);
return;
}$fp = fopen("test.csv","r");while($data = fgetcsv($fp,'1000',',')){ insert_data ($data[0],$data[1],$data[2],$data[3],$data[4]);
echo "<font color = #FF0000 size = 20>数据导入成功!</font><br><br>";
}
fclose ($fp);$time_end = getmicrotime();$time = $time_end - $time_start;echo "程序执行时间:".$time."秒";
?>
list($usec, $sec) = explode( " ",microtime());
return ((float)$usec + (float)$sec);
}$time_start = getmicrotime();include ( "connectdb.php ");
function insert_data ($id,$summary,$description,$additional_information,$category) {
$my_query1 = "insert into mantis_bug_text_table (id,description,additional_information)
values ( '$id ', '$description ', '$additional_information ') ";
$first = mysql_query($my_query1); $my_query2 = "insert into mantis_bug_table (id,project_id,summary,bug_text_id) values ( '$id ', '$category ', '$summary ', '$id ') ";
$second = mysql_query($my_query2);
return;
}$fp = fopen( "test.csv ", "r ");while($data = fgetcsv($fp, '1000 ', ', ')){ insert_data ($data[0],$data[1],$data[2],$data[3],$data[4]);
echo " <font color = #FF0000 size = 20> 数据导入成功! </font> <br> <br> ";
}
fclose ($fp);$time_end = getmicrotime();$time = $time_end - $time_start;echo "程序执行时间: ".$time. "秒 ";
?>