很困惑的一个问题,csv导入
我要做csv导入,sql语句执行没问题,可就是mysql_query($sqlinsert1,$conn)没执行,也不知道错在哪里,请高手指教啊
<?php
include("conn.php");
$row = 1;
$handle = fopen($trailpass, "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
// $data=array_splice($data,0,4);
$num = count($data);
echo $num;
$time=date("Y-m-d H:i:s");
$row++;
for ($c=0; $c < $num; $c++)
{
$sqlinsert1="insert into europe_rail(category,passname,type,date,price,price_type)values ('".$data[$c]."','".$data[$c+1]."','".$data[$c+2]."','".$time."','".$data[$c+4]."','".$data[$c+5]."')";
$c=$c+5;
}
echo $sqlinsert1;
if(mysql_query($sqlinsert1,$conn))
{
echo "成功插入一条记录";
}
else
{
echo "失败一次了";
}
}
// mysql_close($conn);
fclose($handle);
//echo "<script language='javascript'>";
//echo " location=admmanager.php';";
//echo "</script>";
?>