excel 导入, 上传文件必须为csv格式的文件,然后读取上传的文件,转换数组,存数据库就好了
下面最后的 $updata 就是最后处理好的数组,然后存数据库。
//车辆excel导入
public function files_car(){
if($_FILES['file']['error'] == 0){
$type = trim($_FILES['file']['type']);
if($type != 'application/vnd.ms-excel'){
echo "";die;
}
if($_FILES['file']['size'] <= 5000000){
$name = $_FILES['file']['name'];
$name_arr = explode('.', $name);
$new_name = time().uniqid().'.'.$name_arr[count($name_arr)-1];
$path = 'upload/excel/'.date('Y',time()).date('m',time()).date('d',time());
$new_path = $path.'/'.$new_name;
if(!is_dir($path)){
mkdir($path,0777,true);
}
if(move_uploaded_file($_FILES['file']['tmp_name'],$new_path)){
ob_end_clean();
$temp=file($new_path);
$data = eval('return '.iconv('gbk','utf-8',var_export($temp,true)).';');
for($i=0;$i
if($i == 0){
$keyarr = explode(',',$data[0]);
foreach($keyarr as $v){
if($v == '车主姓名'){
$v = 'username';
}elseif($v == '车牌号'){
$v = 'car_number';
}elseif($v == '续保时间'){
$v = 'car_baotime';
}elseif($v == '到期提醒'){
$v = 'car_remind';
}elseif($v == '续保费用'){
$v = 'money';
}else{
$v = 'content';
}
$keydata[] = $v;
}
$keydata[] = 'add_time';
}
if($i > 0){
$daan = explode(',', $data[$i]);
for($j=0;$j
if($keydata[$j] == 'car_remind'){
$daan[$j] = strtotime($daan[$j]);
}
if($keydata[$j] == 'add_time'){
$daan[$j] = time();
}
$uparr[$keydata[$j]] = $daan[$j];
}
if($uparr['username'] != ''){
$updata[] = $uparr;
}
}
}
foreach($updata as $v){
if($v['username'] != ''){
$add = db('car')->insert($v);
}
}
if($add){
echo 1;die;
}
}else{
echo "";die;
}
}else{
echo "";die;
}
}
}