具有"WHERE ... IN"的PDO；询问 [英] PDO with "WHERE... IN" queries

问题描述

我正在重新编写一些PHP代码以使用PDO进行数据库访问，但是我遇到了"WHERE ... IN"查询的问题.

I'm reworking some PHP code to use PDO for the database access, but I'm running into a problem with a "WHERE... IN" query.

我正在尝试根据检查表单上的哪些项目从数据库中删除某些内容.列表的长度和内容会有所不同，但是对于此示例，请想象是这样的:

I'm trying to delete some things from a database, based on which items on a form are checked. The length and content of the list will vary, but for this example, imagine that it's this:

$idlist = '260,201,221,216,217,169,210,212,213';

然后查询如下:

$query = "DELETE from `foo` WHERE `id` IN (:idlist)";
$st = $db->prepare($query);
$st->execute(array(':idlist' => $idlist));

执行此操作时，仅删除第一个ID. (我认为它会抛出逗号及其后的所有内容.)

When I do this, only the first ID is deleted. (I assume it throws out the comma and everything after it.)

我也尝试过将$idlist做成数组，但是它并没有删除任何东西.

I've also tried making $idlist an array, but then it doesn't delete anything.

在PDO准备好的语句中使用项目列表的正确方法是什么?

推荐答案

由于您无法将值(数字)与控制流逻辑(逗号)与准备好的语句混合使用，因此每个值需要一个占位符.

Since you can't mix Values (the Numbers) with control flow logic (the commas) with prepared statements you need one placeholder per Value.

$idlist = array('260','201','221','216','217','169','210','212','213');

$questionmarks = str_repeat("?,", count($idlist)-1) . "?";

$stmt = $dbh->prepare("DELETE FROM `foo` WHERE `id` IN ($questionmarks)");

并循环绑定参数.

这篇关于具有"WHERE ... IN"的PDO；询问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！