这篇文章主要介绍了关于如何利用PHP导入Excel数据到数据库，有着一定的参考价值，现在分享给大家，有需要的朋友可以参考一下
/** * 导入excel * @throws \PHPExcel_Exception * @throws \PHPExcel_Reader_Exception */ public function impExcel($filename,$data){ if (!empty($_FILES)) { $config = array( 'exts'=>array('xlsx','xls'), 'rootPath'=>"./", 'savePath'=> "Public/Uploads/$filename/", 'subName' <strong style="color:transparent">9来源gaodai#ma#com搞@代~码$网</strong>搞gaodaima代码 => array('date','Ymd'), ); $upload = new \Think\Upload($config); if (!$info=$upload->upload()) { $this->error($upload->getError()); } vendor("PHPExcel.PHPExcel"); $file_name = $info['excel']['savepath'].$info['excel']['savename']; //$objReader = \PHPExcel_IOFactory::createReader('Excel5'); $Excel_name = getcwd() . '/' .$file_name; //$aaa = is_readable($Excel_name); // $objPHPExcel = $objReader->load($Excel_name,$encode='utf-8'); $extension = strtolower( pathinfo($Excel_name, PATHINFO_EXTENSION) ); if ($extension =='xlsx') { $objReader = new \PHPExcel_Reader_Excel2007(); $objPHPExcel = $objReader ->load($Excel_name); } else if ($extension =='xls') { $objReader = new \PHPExcel_Reader_Excel5(); $objPHPExcel = $objReader ->load($Excel_name); } else if ($extension=='csv') { $PHPReader = new \PHPExcel_Reader_CSV(); //默认输入字符集 $PHPReader->setInputEncoding('GBK'); //默认的分隔符 $PHPReader->setDelimiter(','); //载入文件 $objPHPExcel = $PHPReader->load($Excel_name); } $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); // 取得总行数 $highestColumn = $sheet->getHighestColumn(); // 取得总列数 for($i=2;$i<=$highestRow;$i++) { $data['name'] = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue(); $data['tel'] = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue(); $data['zjh'] = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue(); $data['sheng'] = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue(); $data['shi'] = $objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue(); $data['address']= $objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue(); $data['money']= $objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue(); $data['hk_time']= $objPHPExcel->getActiveSheet()->getCell("H".$i)->getValue(); $data['nanyi']= $objPHPExcel->getActiveSheet()->getCell("I".$i)->getValue(); $data['uid'] = $_SESSION['user']['id']; $data['time'] = date("Y-m-d H:i:s"); M('release')->add($data); } $this->success('导入成功！');exit(); }else { $this->error("请选择上传的文件"); } }
调用：
if(IS_POST) { $data['reason'] = I("post.reason","","trim"); $data['type'] = I("post.type","","trim"); // $data['qixian'] = I("post.qixian","","trim"); // $data['comm'] = I("post.comm","","trim"); if(!empty($_FILES)){ $this->impExcel('batch_release',$data); } }
以上就是本文的全部内容，希望对大家的学习有所帮助，更多相关内容请随时关注我们网站！
相关推荐：
利用PHPEXCEL 导出数据和图片的代码
以上就是如何利用PHP导入Excel数据到数据库的详细内容，更多请关注搞代码gaodaima其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：如何利用PHP导入Excel数据到数据库
转载请注明原文链接：如何利用PHP导入Excel数据到数据库
