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 vote313 views1 answer
Check mobile or email in laravel
PHP Laravel
6 votes275 views2 answers
Check nulls in php 8
PHP
0 vote288 views2 answers
Laravel insert multiple rows from form
PHP Laravel
11 votes262 views1 answer
Example wp-config.php for Debugging
PHP
1 vote265 views1 answer
Codeigniter where date interval
PHP
0 vote256 views1 answer
Cakephp 4 authentication
PHP
0 vote270 views1 answer
Generate report daily weekly monthly php mysql
PHP
0 vote306 views5 answers
Laravel 8 app with more than one database
PHP Laravel
0 vote272 views1 answer
Save custom input field value into cart item
PHP
1 vote277 views1 answer
Php connect to postgresql
PHP