Laravel更新查询错误,使用带有逗号分隔值的查询构建器
当我更新具有逗号分隔值的4列而没有引用的引号时,我会在Laravel控制器中遇到以下错误,这些列来自请求
Request payload:
column1 : one,two,three
column2 : six,seven
column3 : eight,nine
代码
<?PHP
function run(Request $request){
$column1 = $request->get('column1');
$column2 = $request->get('column2');
$column3 = $request->get('column3');
$save = DB::table('tableone')->where('primaryclm', '1')
->update(['column1' => $column1,'column2' => $column2,'column3' => $column3]);
}
?>
错误:
sql error(sql:update
tableone
setcolumn1
=一个,两个,三个 ,column2
=四,五,六 ,列3
=七,八 其中primaryclm
= 1)
友好地解决此问题。
I am getting the below error in the laravel controller when I update 4 columns with comma-separated values without quotes which are coming from the request
Request payload:
column1 : one,two,three
column2 : six,seven
column3 : eight,nine
Code
<?PHP
function run(Request $request){
$column1 = $request->get('column1');
$column2 = $request->get('column2');
$column3 = $request->get('column3');
$save = DB::table('tableone')->where('primaryclm', '1')
->update(['column1' => $column1,'column2' => $column2,'column3' => $column3]);
}
?>
Error:
SQL error (SQL: update
tableone
setcolumn1
= one,two,three
,column2
= four,five,six
,column3
= seven,eight
whereprimaryclm
= 1)
Kindly help with this issue.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论