php - token 声明时 PDO 中的参数无效

Question

我有正确执行的查询:

$query = $handler->prepare("SELECT * FROM pm WHERE ((user1 = $userid AND user1read = 'no') OR (user2 = $userid AND user2read = 'no') AND id2 = '1')");
$query->execute();

当我尝试声明标记时，它抛出一个 Invalid parameter number' fatal error 。这是引发错误的代码:

$query = $handler->prepare("SELECT * FROM pm WHERE ((user1 = :userid AND user1read = 'no') OR (user2 = :userid AND user2read = 'no') AND id2 = '1')");
$query->execute(array(
'userid' => $userid
));

我正在尝试从 sql 迁移到 PDO。这里是否有一些我遗漏的 sql 残余？

Answer 1

您不能在准备好的语句中两次使用同名的命名参数标记

来源:http://php.net/manual/de/pdo.prepare.php

尝试:

$query = $handler->prepare("SELECT * FROM pm WHERE ((user1 = :userid AND user1read = 'no')     OR (user2 = :userid2 AND user2read = 'no') AND id2 = '1')");
$query->execute(array(
  'userid' => $userid,
  'userid2' => $userid
));