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 vote188 views2 answers
Php multi elseif statement ternary
PHP
-4 votes187 views1 answer
Alert laravel 7
PHP
0 vote187 views1 answer
Set php path in ubuntu
PHP
0 vote243 views1 answer
Php split large text on line breaks into array
PHP
0 vote212 views1 answer
How to add script in WordPress admin page
PHP Wordpress
0 vote226 views1 answer
Laravel catch TokenMismatchException
PHP Laravel
21 votes192 views2 answers
Run a php site
PHP
0 vote197 views2 answers
Laravel display category post by slug
PHP
0 vote202 views4 answers
Install latest php on feren os
PHP
0 vote276 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel