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 vote202 views1 answer
Php artisan route:list for specific name
PHP
0 vote148 views1 answer
Do php
PHP
53 votes165 views6 answers
Date to string php
PHP
0 vote163 views1 answer
Laravel auth without vue or bootstrap
PHP
-1 vote158 views4 answers
Include blade file in laravel
PHP
0 vote156 views1 answer
With() multiple relationship
PHP
2 votes199 views1 answer
Wordpress theme development boilerplate
PHP Wordpress
18 votes143 views4 answers
List all files in directory php
PHP
7 votes153 views1 answer
Php autoload sem composer
PHP
8 votes178 views4 answers
Php yesterday
PHP