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 vote329 views1 answer
Where condition in array in codeigniter
PHP CodeIgniter
0 vote285 views1 answer
Check which device is used to open webpage php
PHP
2 votes306 views2 answers
Php sigmoid function
PHP
17 votes390 views5 answers
Wordpress debug mode
PHP Wordpress
7 votes286 views1 answer
Eloquent run seeder
PHP
0 vote273 views1 answer
Laravel delete file after download
PHP
1 vote263 views1 answer
Print url in view yii2
PHP
2 votes271 views1 answer
Laradock ext-ldap
PHP
12 votes298 views3 answers
Uninstall php ubuntu 18.04
PHP
3 votes263 views2 answers
Lumen file upload
PHP