php Csv 匯入 Use fgetcsv()

Php Csv 匯入~ 很常用到. 很懶所以記下來吧.


<?php

//一次讓他讀一個row,用","分隔,放入$temp陣列中
//陣列中的數值是代表他在資料表中的第幾欄


mysql_connect("localhost","abc","glicd24d") or die("連線失敗請洽系統管理員");
mysql_select_db("test");
$dbname="abc.csv";
if ( !$fp = fopen($dbname,"r") ) {
echo "Cannot open $dbname\n";
exit;
}else{
// 過濾反斜線 \
$current = file_get_contents($file_path);
file_put_contents($file_path, addcslashes($current,'\\'));

$size = filesize($dbname)+1;
$row=0;
while($temp=fgetcsv($fp,$size,",")){
if ($row>0){
$sql="INSERT INTO `TEST` ( `name` , `nuo` , `serial` , `pwd` )
VALUES ('$temp[0]','$temp[1]','$temp[2]','$temp[3]')";
$result=mysql_query($sql);
echo mysql_error();
}
$row=$row+1;
}
fclose($fp);
}
?>