前端页面:
- 导入EXCEL添加学生
- <form action="/admin/student/import" method='post' enctype="multipart/form-data">
- <input id="fileId1" type="file" accept="application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" name="file"/>
- <input type="submit" value="确认">
- </form>
后端处理
- public function import(Request $request){
- if(!$request->hasFile('file')){
- exit('上传文件为空!');
- }
- $file = $_FILES;
- $excel_file_path = $file['file']['tmp_name'];
- $res = [];
- Excel::load($excel_file_path, function($reader) use( &$res ) {
- $reader = $reader->getSheet(0);
- $res = $reader->toArray();
- });
- for($i = 1;$i<count($res);$i++){
- $check = Students::where('name',$res[$i][0])->where('title',$res[$i][4])->count();
- if($check){
- continue;
- }
- $stu = new Students;
- $stu->name = $res[$i][0];
- $stu->group = $res[$i][1];
- $stu->teacher = $res[$i][2];
- $stu->school = $res[$i][3];
- $stu->mobile = $res[$i][4];
- $stu->title = $res[$i][5];
- $stu->save();
- }
- return Redirect::to('/admin/student')->withSuccess("导入成功");
- }