*Here is my Controller*
👇👇
public function storeexcel(Request $request)
{
if($request->hasFile('file')){
$path = $request->file('file')->getRealPath();
$data = Excel::load($path)->get();
if($data->count()){
foreach ($data as $key => $value) {
$insert[] = [
'name' => $value->name,
'sex' => $value->sex,
'phone' => $value->phone,
'certificate_num' => $value->certificate_num,
'year' => $value->year,
'training_centre' => $value->training_centre,
'lga' => $value->lga,
'lga_code' => $value->lga_code,
'institution' => $value->institution,
'institution_code' => $value->institution_code,
//add all columns as per your requirement
];
}
if(!empty($insert)){
DB::table('certificates')->insert($insert);
return back()->with('success','Insert Record successfully.');
}
}
}
return back()->with('error','Please Check your file, Something is wrong .');
}