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<$num;$i++){
40. array_push($arr_result,$data[$i]);
41. }

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

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