21,886
社区成员
发帖
与我相关
我的任务
分享
c3RhZmZfaWQsc3RhZmZfbmFtZSxicmFuY2gsYmFzaWNfd2FnZSxwb3N0X3dhZ2VzLG9sZF9hZ2VfaW5zdXJhbmNlLG1lZGljYWxfaW5zdXJhbmNlLHVuZW1wbG95bWVudF9pbnN1cmFuY2Usd2FnZSxyZWFsX3dhZ2VzLHBlcm1pc3Npb25zX2lkDQpBQkMwMDEs0KHN9Sy/qreiLDI1MDAsMTAwLDIwLDMwLDQwLDMwMDAsMzIwMCwwDQpBQkMwMDIs0KHA7iy/qreiLDI1MDAsMTAwLDIwLDMwLDQwLDMwMDAsMzIwMCwwDQpBQkMwMDMs0KHV1Cy/qreiLDI1MDAsMTAwLDIwLDMwLDQwLDMwMDAsMzIwMCwwDQpBQkMwMDQs0KG2qyy/qreiLDI1MDAsMTAwLDIwLDMwLDQwLDMwMDAsMzIwMCwwDQpBQkMwMDUs0KGxtCy/qreiLDI1MDAsMTAwLDIwLDMwLDQwLDMwMDAsMzIwMCwwDQo=
$fname = $_FILES['MyFile']['tmp_name'];//获取上传的CSV文件
$handle=fopen("$fname","r");//打开文件
//判断导入文件类型是否为csv
//如果为csv继续执行
if($_FILES['MyFile']['type'] !='application/vnd.ms-excel')
{
if($_FILES['MyFile']['type'] != 'text/comma-separated-values')
{
echo "<script>alert('您上传的文件类型不符,请重新上传');window.location='subHotel_import.php';</script>";exit();
}
}
$num = 1;
$total_num = 100;//设置每次添加的数据条数
//删除表中原有数据
$db->query("delete from hotel_activities_2");
//打开导入的csv
//循环添加到表中
while(!feof($handle))
{
$content = fgets($handle);
$data = preg_split("/,/",$content);
if($data[0] =='')
{
continue;
}
$subHotel_id = preg_replace('/[^0-9]/','',$data[0]);
$subHotel_type= (int)preg_replace('/[^0-9]/','',$data[4]);
if($num == $total_num )
{
$num=1;
$values .= " ($subHotel_id,'".$data[1]."','".$data[2]."','".$data[3]."',$subHotel_type),";
$values = rtrim($values,',');
$sql ="insert into hotel_activities_2 (hotel_id,start_date,end_date,content,s_type) values " .$values;
$aaa = $db->query($sql);
$values ='';
}
else
{
$values .= " ($subHotel_id,'".$data[1]."','".$data[2]."','".$data[3]."',$subHotel_type),";
$num++;
}
}
if(mysql_error!==1){
$values = rtrim($values,',');
$sql ="insert into hotel_activities_2 (hotel_id,start_date,end_date,content,s_type) values " .$values;
$db->query($sql);
echo "<script>alert('导入成功!!!');window.location='subHotel_query_file.php';</script>";
}else
{
echo "<script>alert('导入失败!!!');window.location='subHotel_import.php';</script>";
}
fclose($handle);