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 vote252 views1 answer
How to log out php
PHP
4 votes295 views6 answers
Jwt laravel
PHP
1 vote260 views1 answer
Causes of class not found in laravel
PHP
8 votes273 views4 answers
Session unset
PHP
7 votes306 views2 answers
Cannot use object of type stdclass as array
PHP
-2 votes244 views1 answer
Find largest element of an array in php
PHP
1 vote285 views3 answers
Laravel eloquent where date today
PHP
0 vote317 views1 answer
Laravel get host with http
PHP Laravel
0 vote260 views1 answer
Advanaced layout builder enfold custom post type
PHP
0 vote269 views1 answer
On keyup jquery for search php
PHP