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 vote153 views1 answer
How to display limited post content in wordpress
PHP
22 votes191 views5 answers
Get logged user id laravel
PHP Laravel
0 vote157 views1 answer
Php send POST request same folder
PHP
24 votes196 views2 answers
Clear laravel cache and clear vue
PHP Laravel
32 votes195 views5 answers
How to make db seeder in laravel
PHP
1 vote176 views2 answers
Laravel return response view
PHP Laravel
6 votes209 views1 answer
Php contruct parent
PHP
0 vote209 views1 answer
Laravel orm latest()
PHP
0 vote188 views1 answer
Server error in laravel
PHP Laravel
0 vote214 views1 answer
Edit items in Laravel collection
PHP Laravel