public function update($QuestionID) { $question = Questions::find($QuestionID); $old_subquestions = Subquestions::where('QuestionID', '=', $QuestionID)->get()->toArray(); foreach ($old_subquestions as $value) { SubquestionsController::destroy($value['id']); } $request = Request::capture(); $data = $request->all(); $count = $data['numAnswer']; for ($i = 1; $i <= $count; $i++) { $subQ = $data['answer' . $i]; $SubQuestionID = DB::table('subquestions')->insertGetId(['QuestionID' => $QuestionID, 'Question' => $subQ, 'created_at' => new \DateTime(), 'updated_at' => new \DateTime()]); $file = $request->file('subquestion_photo_' . $i); if ($file != null) { $sq = Subquestions::orderBy('id', 'desc')->first(); $sq->Photo = 'Subquestion_' . $QuestionID . '_' . $SubQuestionID . "_-Evangels-English-www.evangelsenglish.com_" . "." . $file->getClientOriginalExtension(); $file->move(base_path() . '/public/images/imageSubquestion/', $sq->Photo); $sq->update(); } $answer = new Answers(); $answer->SubQuestionID = $SubQuestionID; $answer->Detail = $data['ta_answer' . $i]; $answer->Logical = 1; $answer->save(); if ($request->hasFile('answer_photo_' . $i) && $request->file('answer_photo_' . $i)->isValid()) { $a = Answers::orderBy('id', 'desc')->first(); $file = $request->file('answer_photo_' . $i); if ($file != null) { $a->Photo = 'Answer_SQ_' . $SubQuestionID . '_' . $a->id . "_-Evangels-English-www.evangelsenglish.com_" . "." . $file->getClientOriginalExtension(); $file->move(base_path() . '/public/images/imageAnswer/', $a->Photo); $a->update(); } } } return redirect(route('user.viewquestion', $QuestionID)); }