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

A. K. M. Tariqul Islam 发表于 Dev

AKM塔里古尔伊斯兰教

我是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]：语法错误或访问冲突：1064您的SQL语法有错误；检查与您的MariaDB服务器版本相对应的手册，以在第1行的'（uname='[email protected]'，role='2'，fname='A Full Name'，email='rahm'附近使用正确的语法

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

这是我的表结构：

卢卡斯·索兹达（Lukasz Szozda）

卸下SET零件周围的支架：

$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";

检查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]

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。