PHP把表单中的数据写入到EXCEL

jingshen

if($name!=null){
try{
date_default_timezone_set('Etc/GMT-8');     //这里设置了时区
$time= date("Y-m-d H:i:s");

$fp = fopen("data.csv","a"); //打开csv文件，如果不存在则创建
$data_1 = array($name,$cartype,$buycar,$phone,$email,$time,$carnumber);
$data_1 = implode(",",$data_1); // 用 ' 分割成字符串
$data_str =$data_1."\r\n"; //加入换行符
$p=fwrite($fp,$data_str); // 写入数据
//echo $p;
if($p!=null&&$p!=""){
//echo "ok...";
}else{
echo "<script>alert('提交失败!');location.href='index.php';</script>";
}
fclose($fp); //关闭文件句柄
// echo "提交成功";
echo "<script>alert('提交成功!');location.href='done.php';</script>";
}catch(Exception $e){
echo 'Caught exception: ',  $e->getMessage(), "\n";
echo "<script>alert('提交失败!');location.href='index.php';</script>";
}

}else{
echo "<script>alert('提交失败!');location.href='index.php';</script>";
}