我是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’,
at line 1
谁能告诉我我的代码有什么问题?
这是我的表结构: