doudouji2016 2018-06-11 04:37
浏览 47
已采纳

如何更新字段以将值推送到laravel中的现有值

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!');
    }

}
  • 写回答

1条回答 默认 最新

  • duankaolei2921 2018-06-11 05:22
    关注

    Update the answerid with current ids and concat with ,

    DB::table('questions')->where('id', $request->questionid)->update(['answerid'=>DB::raw("CONCAT(answerid,',".$answer."')")]);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?