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 vote328 views1 answer
->store() laravel change name
PHP Laravel
0 vote380 views1 answer
How to get all post fields in wordpress
PHP Wordpress
0 vote343 views1 answer
Laravel collection except
PHP Laravel
0 vote286 views1 answer
Phpmyadmin get actual ip
PHP
0 vote284 views1 answer
Localhost/series/my database/demo.php
PHP
2 votes298 views2 answers
Wp is user admin
PHP
7 votes304 views1 answer
Php get version
PHP
-2 votes321 views1 answer
Laravel if else condition in query
PHP
0 vote379 views2 answers
Load session in codeigniter
PHP CodeIgniter
10 votes365 views6 answers
Php redirect to another page
PHP