duanbing8817
2014-10-29 14:58 阅读 28
已采纳

PDO +评论+? =错误!

(Side-note: Blocking ! in question titles doesn't stop smart-arses like me putting U+203C Double Exclamation Mark instead :p)

After a quick round of debugging, I found this:

$query = <<<END
    SELECT
        `column1`, `column2`,
        SOME_FUNCTION(`column3`) -- process in PHP instead?
    FROM `tablename`
    WHERE `condition` BETWEEN ? AND ?
END;
$stmt = $pdo->prepare($query);
$stmt->execute(array(1,10));

And got this:

Uncaught Exception » RuntimeException » PDOException:
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Do you see the problem?

The question mark in the comment -- process in PHP instead? is interpreted as a token to bind a parameter to! PDO then expects three parameters instead of the two that were passed.

Now, obviously the simple solution was to just rewrite the comment, but this feels like I'm avoiding what may be a bigger issue.

Is there perhaps something wrong with PDO, or is there an option I can set to have it understand MySQL comments?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dtkmejg127475 dtkmejg127475 2014-10-29 15:02

    You can have comments, but not those with ? in them or other things like :x that would be interpreted as placeholders.

    PDO does not understand SQL syntax. It's treating all that text as something that needs to be examined for placeholders. When emulating prepared statements this is what will happen.

    点赞 评论 复制链接分享

相关推荐