Php pdo bindvalue array

<?php
$ids     = array(1, 2, 3, 7, 8, 9);
$inQuery = implode(',', array_fill(0, count($ids), '?'));

$db = new PDO(...);
$stmt = $db->prepare(
    'SELECT *
     FROM table
     WHERE id IN(' . $inQuery . ')'
);

// bindvalue is 1-indexed, so $k+1
foreach ($ids as $k => $id)
    $stmt->bindValue(($k+1), $id);

$stmt->execute();
?>

Source: stackoverflow.com

Similar codes

1 vote260 views1 answer
Laravel nigerian time zone
PHP Laravel
1 vote247 views2 answers
Laravel model is dirty
PHP Laravel
6 votes214 views3 answers
Carbon if date is today
PHP
6 votes248 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
-1 vote272 views1 answer
Laravel migration table bigint
PHP Laravel
0 vote236 views1 answer
Generate report daily weekly monthly php mysql
PHP
3 votes343 views1 answer
Php foreach reverse
PHP
0 vote217 views1 answer
Echo string in php
PHP
0 vote236 views2 answers
Prestashop show all products in category
PHP
2 votes243 views1 answer
Laravel validate integer between
PHP Laravel