/** * Run the database seeds. * * @return void */ public function run() { DB::table('matchmaker_player_answers')->delete(); MatchmakerPlayerAnswer::create(['player_id' => 192412, 'question_id' => 1, 'answer_id' => 1]); MatchmakerPlayerAnswer::create(['player_id' => 192412, 'question_id' => 2, 'answer_id' => 5]); MatchmakerPlayerAnswer::create(['player_id' => 192412, 'question_id' => 3, 'answer_id' => 6]); MatchmakerPlayerAnswer::create(['player_id' => 17446, 'question_id' => 1, 'answer_id' => 1]); MatchmakerPlayerAnswer::create(['player_id' => 17446, 'question_id' => 2, 'answer_id' => 4]); MatchmakerPlayerAnswer::create(['player_id' => 17446, 'question_id' => 3, 'answer_id' => 7]); MatchmakerPlayerAnswer::create(['player_id' => 14129, 'question_id' => 1, 'answer_id' => 2]); MatchmakerPlayerAnswer::create(['player_id' => 14129, 'question_id' => 2, 'answer_id' => 5]); MatchmakerPlayerAnswer::create(['player_id' => 14129, 'question_id' => 3, 'answer_id' => 7]); MatchmakerPlayerAnswer::create(['player_id' => 198178, 'question_id' => 1, 'answer_id' => 3]); MatchmakerPlayerAnswer::create(['player_id' => 198178, 'question_id' => 2, 'answer_id' => 2]); MatchmakerPlayerAnswer::create(['player_id' => 198178, 'question_id' => 3, 'answer_id' => 6]); }
/** * Store Player Answers. * * @return Response */ public function storePlayerAnswers(Request $request) { //return response()->json( // MatchmakerPlayerAnswer::create(['player_id' => 123, // 'question_id' => 1, // 'answer_id' => 1 // ])); $player_id = $request->player_id; $player_answers = $request->player_answers; $question_id = 1; foreach ($player_answers as $a) { $answer_id = $a[0]; $answer = MatchmakerPlayerAnswer::find($player_id)->where('question_id', '=', $question_id); //var_dump($answer->count()); $answer->question_id = $question_id; $answer->answer_id = $answer_id; $answer->save(); //next question $question_id += 1; } }