gpt4 book ai didi

php - PDO => 'PDOException' 消息为 'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined'

转载 作者:太空宇宙 更新时间:2023-11-03 12:06:10 25 4
gpt4 key购买 nike

<分区>

我试图在我的 PDO 中运行一个子查询,但 PDO 没有。有什么建议么?

未捕获异常“PDOException”,消息为“SQLSTATE[HY093]:无效参数号:参数未定义”

$userId = 1;
$promotionId = 1;

$sql = "
SELECT
*,
(
SELECT
COUNT(*)
FROM
promotion_user as spu
WHERE
spu.promotion_id = p.id AND
spu.user_id = :user_id
) as num_uses
FROM
promotion as p
WHERE
p.id = :promotionId
";

//$db is the PDO connection
$getPromotions = $db->prepare($sql);
$getPromotions->bindValue(':user_id', $userId, PDO::PARAM_STR);
$getPromotions->bindValue(':promotion_id', $promotionId, PDO::PARAM_STR);
$getPromotions->execute();
$promotions = $getPromotions->fetchAll(PDO::FETCH_ASSOC);

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com