public function scheduleQuiz() { $user_id = Auth::user()->id; $quiz = Input::get('quiz'); $class = Input::get('class'); $start_time = Input::get('start_time'); $end_time = Input::get('end_time'); $start_timestamp_array = $this->timestampToArray($start_time); extract($start_timestamp_array); $datetime_from = Carbon::create($year, $month, $day, $hour, $minute, $second)->toDateTimeString(); $end_timestamp_array = $this->timestampToArray($end_time); extract($end_timestamp_array); $datetime_to = Carbon::create($year, $month, $day, $hour, $minute, $second)->toDateTimeString(); $quiz_id = DB::table('quiz')->where('title', '=', $quiz)->pluck('id'); $class_id = DB::table('classes')->where('name', '=', $class)->pluck('id'); $quiz_code = str_random(10); $quiz_schedule = new QuizSchedule(); $quiz_schedule->user_id = $user_id; $quiz_schedule->quiz_id = $quiz_id; $quiz_schedule->class_id = $class_id; $quiz_schedule->quiz_code = $quiz_code; $quiz_schedule->datetime_from = $datetime_from; $quiz_schedule->datetime_to = $datetime_to; $quiz_schedule->save(); return Redirect::back()->with('message', array('type' => 'success', 'text' => 'Quiz Scheduled!')); }