How to bind an array of values ​​in an IN condition when using PDO?

Question

PHP

<?php
$ids=array(1,2,3,7,8,9);
$db = new PDO(...);
$stmt = $db->prepare(
    'SELECT *
     FROM table
     WHERE id IN(:an_array)'
);
$stmt->bindParam('an_array',$ids);
$stmt->execute();
?>

I really don't want to do implode(..., $ids) - I'll have to fiddle with quotes and all the profit from preparing the request essentially disappears :(

Answer 1

Classic solution:

<?php
$ids=array(1,2,3,7,8,9);
$in  = str_repeat('?,', count($arr) - 1) . '?';
$stmt = $db->prepare('SELECT * FROM table  WHERE id IN($in)');
$stmt->execute($ids);

Not too pretty, but safe.

Answer 2

Unfortunately, no way, you have to convert the array to a string.

Answer 3

You can use FIND_IN_SET instead of IN, but indexes won't work.