首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >PDO错误:无效的参数号:绑定变量的数目不匹配令牌的数目[已关闭]

PDO错误:无效的参数号:绑定变量的数目不匹配令牌的数目[已关闭]
EN

Stack Overflow用户
提问于 2019-05-17 07:12:15
回答 1查看 0关注 0票数 0

我是PDO新手,并创建了一个更新查询,并得到上述错误。可能是因为凌晨4点,但我看不出我错过了什么。这是查询:

代码语言:javascript
复制
$uid = $_GET['uid'];

print_r($_POST);

$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$home_address = $_POST['home_address'];
$city = $_POST['city'];
$province = $_POST['province'];
$country = $_POST['country'];
$postal_code = $_POST['postal_code'];
$phone = $_POST['phone'];
$buisness_phone = $_POST['buisness_phone'];
$buisness_email = $_POST['buisness_email'];
$employer = $_POST['employer'];
$primary_email = $_POST['primary_email'];

$query = "UPDATE primary_profile
SET fName = :first_name,
lName = :last_name,
hAddress = :home_address,
city = :city,
province = :province,
country = :country,
pCode = :postal_code,
phone = :phone,
bPhone = :buisness_phone,
bEmail = :buisness_email,
email = :primary_email,
employer = :employer
WHERE uid = :uid";


$stmt = $conn->prepare($query);
$stmt->execute(array(':first_name'=>$first_name,
':last_name'=>$last_name,
':home_address'=>$home_address,
':city'=>$city,
':province'=>$province,
':country'=>$country,
':postal_code'=>$postal_code,
':phone'=>$phone,
':buisness_phone'=>$buisness_phone,
':buisness_email'=>$buisness_email,                  ':primary_email'=>$primary_email,                           
':employer'=>$employer
));

任何帮助,将不胜感激。

EN

回答 1

Stack Overflow用户

发布于 2019-05-17 16:26:50

查询中有13个命名占位符,但只绑定了11个变量。把最后一个绑起来,它就能工作了。(UID)

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/-100006749

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档