WHERE IN子句与PDO的绑定参数

Question

我的代码：

$myArray = implode($myArray, ',');

$sth = $dbh->prepare('SELECT foo FROM bar WHERE ids IN (:ids)');

$sth->bindParam(':ids', $myArray);

$sth->execute();

$result = $sth->fetch();

echo $sth->rowCount();

总是显示1的计数，但是当我跳过参数化并仅将变量本身添加到其位置时，我得到了准确的计数。这里发生了什么？

Answer 1

我知道这个问题很老，但这对我有用：$arrayOfValues = array(1,2,3,4,5);$questionMarks = join(",", array_pad(array(), count($arrayOfValues), "?"));$stmt = $dbh->prepare("update some_table set end_date = today where value_no in ($questionMarks)");$stmt->execute($arrayOfValues);