好了,当我在本地主机上运行时,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/

10-10 23:41
查看更多