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

3 votes213 views3 answers
Php check if a url exists
PHP
0 vote205 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP
0 vote243 views1 answer
Laravel Password & Password_Confirmation Validation
PHP Laravel
0 vote210 views3 answers
The `php` command cannot be found. Please verify that PHP is installed, or set the `php.executables` setting.
PHP
0 vote219 views1 answer
Php regex file extension
PHP
0 vote214 views1 answer
Escape class wordpress
PHP Wordpress
0 vote209 views2 answers
Php artisan app:name in laravel 6
PHP
2 votes206 views2 answers
Hide wp admin bar for subscribers
PHP
11 votes211 views4 answers
Append file in php
PHP
2 votes199 views5 answers
Laravel db drop table
PHP