php – PDO UPDATE：语法错误或访问冲突

发布时间：2020-12-13 18:14:11 所属栏目：PHP教程来源：网络整理

导读：我是PDO的新手,编写更新查询： $sql = "UPDATE `users` SET(`uname` = :uname,`role` = :role,`fname` = :fname,`email` = :email,`mobile1` = :mobile1,`mobile2` = :mobile2,`education` = :education,`division` = :division,`district` = :district,`sub

我是PDO的新手,编写更新查询：

$sql = "UPDATE `users` 
           SET(`uname` = :uname,`role` = :role,`fname` = :fname,`email` = :email,`mobile1` = :mobile1,`mobile2` = :mobile2,`education` = :education,`division` = :division,`district` = :district,`sub_district` = :sub_district,`address` = :address,`looking_for` = :looking) 
         WHERE `id` = :id";

            //$sql = "UPDATE `users` SET(`uname`=?,`role`=?,`fname`=?,`email`=?,`mobile1`=?,`mobile2`=?,`education`=?,`division`=?,`district`=?,`sub_district`=?,`address`=?,`looking_for`=?) WHERE `id`=?";
            $st = $conn->prepare($sql);
            //$res['sql'] = $st->queryString;
            $params = array(
                ':uname' => $uname,':role' => $role,':fname' => $fname,':email' => $email,':mobile1' => $mobile1,':mobile2' => $mobile2,':education' => $edu,':division' => $division,':district' => $district,':sub_district' => $sub_district,':address' => $address,':looking' => $looking,':id' => $id
            );

            //$res['params'] = $params;
            $r = $st->execute($params);

得到：

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near ‘(uname =
‘rahman@abc.def’,role = ‘2’,fname = ‘A full Name’,email = ‘rahm’
at line 1

谁能告诉我我的代码有什么问题？

这是我的表结构：

删除SET部分周围的括号：

$sql  =  "UPDATE `users` 
          SET  `uname` = :uname,`looking_for` = :looking 
         WHERE `id` = :id";

检查UPDATE syntax：

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
    SET col_name1={expr1|DEFAULT} [,col_name2={expr2|DEFAULT}] ...
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!