记录一下遇到的坑 我花了2个小时在引入文件上,tp5.1已经废弃了import函数和vendor函数,这里我们用require或者include都可以.
贴代码:
前端:
<!DOCTYPE html>
<html>
<head>
<title>PHPexcel</title>
</head>
<body>
<form action="{:url('/upload')}" enctype="multipart/form-data" method="post" >
上传文件:<input type="file" name="excel">
<input type="submit" value="提交文件">
</form>
<script src="http://libs.baidu.com/jquery/2.1.4/jquery.min.js"></script>
</body>
</html>
表设计:
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
控制器:
public function upload()
{
// 引入核心文件
require'../extend/PHPExcel/PHPExcel.php';
header("content-type:text/html;charset=utf-8");
//上传excel文件
$file = request()->file('excel');
$files = $_FILES['excel'];
//将文件保存到public/uploads目录下面
$info = $file->validate(['size'=>1048576,'ext'=>'xls,xlsx'])->move( './uploads');
if($info){
//获取上传到后台的文件名
$fileName = $info->getSaveName();
//获取文件路径
$filePath = Env::get('root_path').'public'.DIRECTORY_SEPARATOR.'uploads'.DIRECTORY_SEPARATOR.$fileName;
//获取文件后缀
$suffix = $info->getExtension();
//判断哪种类型
if($suffix=="xlsx"){
$reader = \PHPExcel_IOFactory::createReader('Excel2007');
}else{
$reader = \PHPExcel_IOFactory::createReader('Excel5');
}
}else{
$this->error('文件过大或格式不正确导致上传失败-_-!');
}
$objContent = $reader -> load($files['tmp_name']);
$sheetContent = $objContent -> getSheet(0) -> toArray();
unset($sheetContent[0]);
foreach ($sheetContent as $k => $v){
$arr['id'] = $v[0];
$arr['title'] = $v[1];
$res[] = $arr;
}
$res = Db::name('test') -> insertAll($res);
if($res){
echo "成功";
}else{
echo "失败";
}
}