脚本宝典收集整理的这篇文章主要介绍了php – PDO UPDATE:语法错误或访问冲突,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
$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);
得到:
谁能告诉我我的代码有什么问题?
这是我的表结构:
$sql = "UPDATE `users` SET `uname` = :uname,`looking_for` = :looking WHERE `id` = :id";
UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET col_name1={expr1|DEFAULT} [,col_name2={expr2|DEFAULT}] ... [WHERE where_condition] [ORDER BY ...] [LIMIT row_count]
以上是脚本宝典为你收集整理的php – PDO UPDATE:语法错误或访问冲突全部内容,希望文章能够帮你解决php – PDO UPDATE:语法错误或访问冲突所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。