PDO 错误:SQLSTATE[HY000]:一般错误:2031

问题描述

我遇到了这个烦人的错误，虽然我知道我为什么会遇到它，但我终生无法找到解决方案.

I'm getting this annoying error and although I have an idea of why I'm getting it, I can't for the life of me find a solution to it.

if ($limit) {
   $sth->bindValue(':page', $page - 1, PDO::PARAM_INT);
   $sth->bindValue(':entries_per_page', $page * $entries_per_page, PDO::PARAM_INT);
}

$sth->execute($criteria);

查询包含占位符(:placeholder).但是要添加那些 LIMIT 占位符，我需要使用手动方法 (bindValue)，否则引擎会将它们转换为字符串.

Query contains placeholders (:placeholder). But to add those LIMIT placeholders, I need to use the manual method (bindValue) because otherwise the engine will turn them into strings.

我没有收到 Invalid number of parameters 错误，因此所有占位符都已正确绑定(我假设).

I'm not getting the Invalid number of parameters error, so all placeholders have been bound correctly (I assume).

查询:

SELECT `articles`.*, `regional_municipalities`.`name` AS `regional_municipality_name`, 
       `_atc_codes`.`code` AS `atc_code`, `_atc_codes`.`name` AS `substance`
FROM `articles`
LEFT JOIN `_atc_codes`
ON (`_atc_codes`.`id` = `articles`.`atc_code`)
JOIN `regional_municipalities`
ON (`regional_municipalities`.`id` = `articles`.`regional_municipality`)
WHERE TRUE AND `articles`.`strength` = :strength
GROUP BY `articles`.`id`
ORDER BY `articles`.`id`
LIMIT :page, :entries_per_page

所有占位符值都位于 $criteria 中，除了最后两个 LIMIT，我用 bindValue() 手动绑定.

All placeholder values reside in $criteria, except for the last two LIMIT, which I manually bind with bindValue().

推荐答案

你不能使用 ->bind* and ->execute($params).使用或；如果你将参数传递给 execute()，那些会让 PDO 忘记已经通过 ->bind* 绑定的参数.

You cannot use ->bind* and ->execute($params). Use either or; if you pass parameters to execute(), those will make PDO forget the parameters already bound via ->bind*.

这篇关于PDO 错误:SQLSTATE[HY000]:一般错误:2031的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！