/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(createClassRequest $request) { // dd($request->all()); // dd($request->subject_id); $class = new StudentClass(); $class->name = $request->name; $class->staff_id = $request->staff_id; $class->max_students = $request->max_students; $class->promotion_class_id = $request->promotion_class_id; $class->save(); for ($i = 0; $i < count($request->subject_id); $i++) { $record = \DB::table('class_subject')->where('class_id', $class->id)->where('subject_id', $request->subject_id[$i])->first(); if (is_null($record)) { \DB::table('class_subject')->insert(array('class_id' => $class->id, 'subject_id' => $request->subject_id[$i], 'staff_id' => $request->staff[$i])); } } // DB::statement(); session()->flash('flash_message', 'Class successfully created.'); session()->flash('flash_message_important', true); return redirect('settings/classes'); }