php匯入csv到mysql資料庫

複製代碼 2，執行頁面insertdb.php session_start(); header("Content-type:text/html;charset:utf-8"); //全域變數 $file=$_FILES['filename']; $max_size="2000000"; //最大檔案限制（單位：byte） $fname=$file['name']; $ftype=strtolower(substr(strrchr($fname,'.'),1)); //檔案格式 $uploadfile=$file['tmp_name']; if($_SERVER['REQUEST_METHOD']=='POST'){ if(is_uploaded_file($uploadfile)){ if($file['size']>$max_size){ echo "Import file is too large"; exit; } if($ftype!='csv'){ echo "Import file type is error"; exit; } }else{ echo "The file is not empty!"; exit; } } require("./conn.php"); //串連mysql資料庫 $row=0; $filename=$file['tmp_name']; $handle=fopen($filename,'r'); while(!feof($handle) && $data=fgetcsv($handle,1000,',')){ $arr_result=array(); if($row==0){ $row++; continue; } if($row>0 && !empty($data)){ $num=count($data); for($i=0;$i<$num;$i++){ array_push($arr_result,$data[$i]); } $name = iconv('gb2312','utf-8',$arr_result[1]); $sex = iconv('gb2312','utf-8',$arr_result[2]); $sql="insert into student(typeId,name,sex,age) value($arr_result[0],'$name','$sex',$arr_result[3])"; //echo $sql; mysql_query("set names utf8"); $result=mysql_query($sql); if($result){ echo "插入成功！！！"; }else{ echo "插入失敗！！！"; } } $row++; } fclose($handle); ?> 複製代碼

