复制代码 代码如下:

<?php
$fname = $_files[\'myfile\'][\'name\'];
$do = copy($_files[\'myfile\'][\'tmp_name\'],$fname);
if ($do){
echo\"导入数据成功<br>\";
}else{
echo \"\";
}
 
error_reporting(0);// 导入csv格式的文件
$connect=mysql_connect(\"localhost\",\"root\",\"\") or die(\"could not connect to database\");
mysql_select_db(\"gklqtzcx\",$connect) or die (mysql_error());
mysql_query(\"set names \'gbk\'\");
$fname = $_files[\'myfile\'][\'name\'];
$handle=fopen(\"$fname\",\"r\");
while($data=fgetcsv($handle,10000,\",\")){
$q=\"insert into records (name,classes,a_time,college,notify,receiver,r_time,handler) values (\'$data[1]\',\'$data[2]\',\'$data[3]\',\'$data[4]\',\'$data[5]\',\'$data[6]\',\'$data[7]\',\'$data[8]\')\";
mysql_query($q) or die (mysql_error());
}
fclose($handle);
echo \"<meta http-equiv=\"refresh\" content=\"1;url=list.php\">1秒钟转入列表页,请稍等.\";
?> 
<form enctype=\"multipart/form-data\" action=\"<?php echo\"\".$_server[\"php_self\"].\"\"; ?>\" method=\"post\">
<p>导入cvs数据 <input name=\"myfile\" type=\"file\"> <input value=\"提交\" type=\"submit\">
</p>
</form>