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

0 vote166 views1 answer
Override CouponPost.php
PHP
1 vote192 views1 answer
Wordpress is_archive
PHP Wordpress
1 vote181 views1 answer
Cakephp 4 change layout view in a method
PHP
0 vote172 views1 answer
How to extract code from controller to helpers or other method in laravel
PHP
1 vote214 views2 answers
Re migrate laravel
PHP Laravel
0 vote184 views1 answer
Optimize clear laravel not working
PHP Laravel
1 vote170 views1 answer
Php begin tag
PHP
0 vote185 views1 answer
How do I display logged-in username IF logged-in? site:wordpress.stackexchange.com
PHP
3 votes162 views2 answers
Custom 404 page in laravel
PHP
20 votes209 views3 answers
Make specific migration laravel
PHP Laravel