php解析csv文件并导入到数据库中

<?php

$link=mysql_connect("localhost","root","");

mysql_select_db("exltophp",$link);

$hand=fopen("exl/12.csv","r");

$arr_sql=array();

while ($data = fgetcsv ($hand, 1000, ",")) {

$sql="insert into `1`(`1`,`2`) values(";

$num = count ($data);

for ($c=0; $c < $num; $c++) {

if($c==$num-1)

{

$sql=$sql."'".$data[$c]."'".")";

break;

}

$sql=$sql."'".$data[$c]."'".",";

}

array_push($arr_sql,$sql);

}

for($i=1;$i<count($arr_sql);$i++){

mysql_query($arr_sql[$i]);

}

fclose($hand);

?>