PHP import csv to MySQL database

Copy Code 2, Execution page insertdb.php Session_Start (); Header ("Content-type:text/html;charset:utf-8"); Global variables $file =$_files[' filename '; $max _size= "2000000"; Maximum file limit (in bytes) $fname = $file [' name ']; $ftype =strtolower (substr (STRRCHR ($fname, '. '), 1)); File format $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"); Connect to MySQL Database $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 "INSERT success!!! "; }else{ echo "Insert failed!!! "; } } $row + +; } Fclose ($handle); ?> Copy Code

