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 vote158 views1 answer
Laravel deploy without moving public directory
PHP Laravel
2 votes141 views2 answers
Laravel run controller from command line
PHP
-2 votes123 views1 answer
Magento 2.3 check if customer is logged in
PHP
61 votes148 views2 answers
Php get intersection of two arrays
PHP
5 votes131 views4 answers
Wordpress get plugin root directory
PHP
4 votes167 views4 answers
Multiple middleware laravel
PHP
9 votes155 views5 answers
Uuid in laravel
PHP Laravel
46 votes139 views6 answers
Clear laravel cache
PHP
0 vote149 views1 answer
Defining constant in config laravel
PHP Laravel
0 vote129 views2 answers
Php get start and end date of month and year
PHP