How to use ThinkPHP, uploadify, upload, PHPExcel to import data without refreshing

一个新手
Release: 2023-03-15 22:22:02
Original
1334 people have browsed it

Front-end HTML+JQuery Note Jquery requires version 1.x, version 2.x cannot be used

1.Introduce necessary files and upload input


  
Copy after login


Copy after login

2.uploadify usage operation


Copy after login

3. ThinkPHP controller upload operation: Note that the Upload.class.php space needs to be introduced


function upload(){ $config = array( 'maxSize' => 3145728, 'rootPath' => './Uploads/', 'savePath' => '', 'saveName' => array('uniqid',''), 'exts' => array('xls'), 'autoSub' => true, 'subName' => array('date','Ymd'), ); $upload = new Upload($config); // 上传文件 $info = $upload->upload(); if(!$info) {// 上传错误提示错误信息 $this->error($upload->getError()); }else{// 上传成功 获取上传文件信息 $file = $info['Filedata']['savepath'].$info['Filedata']['savename']; } //p($info); $data = array( 'file'=>'./Uploads/'.$file, ); echo json_encode($data); }
Copy after login

4. Import data into mysql


//导入数据处理 function daoruHandle(){ $file = I('file'); $excelData = excel_to_mysql($file); foreach($excelData['data'] as $row){ $data = array( 'xuehao'=>$row['xuehao'], 'xingming'=>$row['xingming'], 'xingbie'=>($row['xingbie']=='男')?1:0, 'mima'=>md5($row['mima']), ); M('student')->add($data); } echo 1; }
Copy after login

5.PHPExcel reads Excel file and returns data function


function excel_to_mysql($file){ //导入PHPExcel第三方类库 //vendor('PHPExcel.PHPExcel'); import('Classes.PHPExcel',COMMON_PATH,'.php'); //实例化PHPExcel类,用于接收Excel文件 $PHPExcel = new PHPExcel(); //读取Excel文件类实例化 $PHPReader = new PHPExcel_reader_Excel5(); //检测Excel版本是否可读 if(!$PHPReader->canRead($file)){ $PHPReader = new PHPExcel_Reader_Excel2007(); if(!$PHPReader->canRead($file)) return array('error'=>1);//未知版本的Excel } //读取Excel文件 $PHPExcel = $PHPReader->load($file); //获得Excel中表的数量 $sheetCount = $PHPExcel->getSheetCount(); //获得第一张工作表 $sheet=$PHPExcel->getSheet(0); //获得表中最大数据列名 $column = $sheet->getHighestColumn(); //获得表中最大数据行名 $row = $sheet->getHighestRow(); //循环获得表中数据 for($i=1;$i<=$row;$i++){ $data[] = array( //通过工作表对象的getCell方法获得单元格 getValue方法获得该单元格数值 'xuehao'=>$sheet->getCell('A'.$i)->getValue(), 'xingming'=>$sheet->getCell('B'.$i)->getValue(), 'xingbie'=>$sheet->getCell('C'.$i)->getValue(), 'mima'=>$sheet->getCell('D'.$i)->getValue(), ); } //释放工作表对象 unset($sheet); //释放读取Excel文件对象 unset($PHPReader); //释放Excel文件对象 unset($PHPExcel); //返回数据 return array('error'=>0,'data'=>$data); }
Copy after login

The above is the detailed content of How to use ThinkPHP, uploadify, upload, PHPExcel to import data without refreshing. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!