好了,当我在本地主机上运行时,PDO代码可以正常工作,但是当我
在我的主机上运行不起作用,并给我一个错误,这是
Connection.php第651行中的QueryException:
SQLSTATE [HY000]:一般错误:2053(SQL:UPDATE角色SET member_id = 76446,member_role = 5613 WHERE member_id = 76446)
该代码是
if (!empty($member->id)) {
$new_id = $member->id;
$new_p = $member->p_id;
$sql = "UPDATE roles SET member_id=$new_id,member_role=$new_p WHERE member_id=$new_id";
$member = DB::select($sql);
Session::flash('sm', 'Thank you! You have edited the Profile successfully!');
}
感谢您的帮助!
最佳答案
Laravel内置于query builder
因此您的代码应类似于-
if (!empty($member->id)) {
$new_id = $member->id;
$new_p = $member->p_id;
DB::table('roles')->where('member_id', $new_id)->update(['member_role' => $new_p]);
Session::flash('sm', 'Thank you! You have edited the Profile successfully!');
}
我删除了
member_id=$new_id
,因为您已经在where
子句中检查了此部分关于php - Laravel-PDO-更新,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/34774056/