How Can I Bind an Array to an IN() Clause in a PDO Query?

Can Array Values be Bound to an IN() Condition in a PDO Query?

Binding an array of values to an IN() condition using PDO is possible, but it requires manual placeholder construction. Here's how:

1. Create Placeholders: Construct a string of placeholders corresponding to the number of array elements. For example, if the array contains three values, the placeholder string would be "?,?".
2. Prepare Statement: Prepare a PDO statement using the IN() condition with the constructed placeholders.
3. Execute Statement: Execute the prepared statement and pass the array values as arguments. PDO will automatically bind and quote the values.

Here's an example:

$ids = [1, 2, 3, 7, 8, 9];
$inQuery = str_repeat('?,', count($ids) - 1) . '?'; // ?,?,?,?,?,?

$stmt = $db->prepare("SELECT * FROM table WHERE id IN($inQuery)");
$stmt->execute($ids);

In case of named placeholders:

1. Create Placeholder Sequence: Create a sequence of named placeholders corresponding to the array elements, e.g. :id0,:id1,:id2.
2. Collect Values: Collect the array values into a key-value array using the placeholder sequence as keys.
3. Prepare and Execute: Prepare the statement and execute it, merging the parameter arrays.

Here's an example:

$ids = [1, 2, 3];
$in = "";
$i = 0; // external counter
foreach ($ids as $item) {
    $key = ":id" . $i++;
    $in .= ($in ? "," : "") . $key; // :id0,:id1,:id2
    $in_params[$key] = $item; // collect values
}

$sql = "SELECT * FROM table WHERE id IN ($in)";
$stmt = $db->prepare($sql);
$stmt->execute(array_merge(["foo" => "foo", "bar" => "bar"], $in_params));

The above is the detailed content of How Can I Bind an Array to an IN() Clause in a PDO Query?. For more information, please follow other related articles on the PHP Chinese website!