I want to update questions
table answerid
column with the comma separator, when users give the answer many times against one question.
This is answers
table bellow-
id questionid answer
1 1 ans1
2 1 ans2
3 1 ans3
And my questions
table is -
id userid questions answerid
1 100 q1 1
2 110 q2
3 1345 q3
After answering many times against one question then questions
table should be like-
id userid questions answerid
1 100 q1 1,2,3
2 110 q2
3 1345 q3
When user answering the qeustion then I am saving this into my database like bellow-
public function saveAnswer(Request $request)
{
$id = session()->get('did');
$phone = session()->get('phone');
$email = session()->get('email');
if(empty($phone) || empty($email)){
return redirect('donor-login');
}
$answer = DB::table('answers')
->insert([
'questionid' => $request->questionid,
'answer' => $request->answer,
'created_by' => $id,
'updated_by' => $id,
'created_at' => date("Y-m-d H:i:s"),
]);
if ($answer) {
DB::table('questions')
->where('id', $request->questionid)
->update([
'answerid' => ????here is my problem
]);
return back()->with('success', 'Your answer successfully saved!');
}
}