PHP implements importing CSV large file data into MYSQL database_PHP tutorial

A colleague has asked me the same question more than once. Here is the simplest implementation in PHP. If you have a better way, please share it:)

The code is as follows:
[php]
$db_host="192.168.1.10";
$db_user="root";
$db_psw="11111";
$db_name="csvimport";

$conn = mysql_connect($db_host,$db_user,$db_psw) or die("Connection occur error");
mysql_select_db($db_name,$conn) or die("Connection occur error");
mysql_query("set names utf-8");


mysql_query("LOAD DATA INFILE '/root/bill20120813121249.csv' INTO TABLE `billdata` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY 'rn' IGNORE 1 LINES;") or die ( 'Error: '.mysql_error ());

?>

http://www.bkjia.com/PHPjc/478007.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478007.htmlTechArticleA colleague has asked me the same question more than once. Here is the simplest implementation of PHP. If you have a better way, please share it:) The code is as follows: [php] ?php $db_host=19...