Using PDO with IN clause - Cacher Snippet

1/31/2019 - 4:38 PM

Using PDO with IN clause

pdo_in_array.md

Rendered
Source

Using PDO with IN clause array

PDO is not good with such things. You need to create a string with question marks dynamically and insert into query.

$in  = str_repeat('?,', count($in_array) - 1) . '?';
$sql = "SELECT * FROM my_table WHERE my_value IN ($in)";
$stm = $db->prepare($sql);
$stm->execute($in_array);
$data = $stm->fetchAll();