php导入csv到mysql数据库

复制代码

2，执行页面insertdb.php

3. session_start();

4. header("Content-type:text/html;charset:utf-8");

5. //全局变量

6. $file=$_FILES['filename'];
7. $max_size="2000000"; //最大文件限制（单位：byte）
8. $fname=$file['name'];
9. $ftype=strtolower(substr(strrchr($fname,'.'),1));
10. //文件格式
11. $uploadfile=$file['tmp_name'];
12. if($_SERVER['REQUEST_METHOD']=='POST'){
13. if(is_uploaded_file($uploadfile)){
14. if($file['size']>$max_size){
15. echo "Import file is too large";
16. exit;
17. }
18. if($ftype!='csv'){
19. echo "Import file type is error";
20. exit;
21. }
22. }else{
23. echo "The file is not empty!";
24. exit;
25. }
26. }

27. require("./conn.php"); //连接mysql数据库

28. $row=0;
29. $filename=$file['tmp_name'];
30. $handle=fopen($filename,'r');
31. while(!feof($handle) && $data=fgetcsv($handle,1000,',')){
32. $arr_result=array();
33. if($row==0){
34. $row++;
35. continue;
36. }
37. if($row>0 && !empty($data)){
38. $num=count($data);
39. for($i=0;$i array_push($arr_result,$data[$i]);
40. }

41. $name = iconv('gb2312','utf-8',$arr_result[1]);

42. $sex = iconv('gb2312','utf-8',$arr_result[2]);
43. $sql="insert into student(typeId,name,sex,age) value($arr_result[0],'$name','$sex',$arr_result[3])";
44. //echo $sql;
45. mysql_query("set names utf8");
46. $result=mysql_query($sql);
47. if($result){
48. echo "插入成功！！！";
49. }else{
50. echo "插入失败！！！";
51. }
52. }
53. $row++;
54. }
55. fclose($handle);
56. ?>

复制代码