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

1 vote89 views1 answer
Remove add media button wordpress editor
PHP
8 votes136 views3 answers
Laravel check record exists
PHP Laravel
0 vote630 views1 answer
How to run php file in xampp
PHP
0 vote93 views1 answer
Singular from table laravel
PHP
21 votes96 views6 answers
Php sort array by value
PHP
0 vote86 views1 answer
Web servers supported by php
PHP
0 vote91 views1 answer
File viewer codeigniter
PHP
6 votes101 views4 answers
Php catch exception
PHP
5 votes110 views6 answers
Laravel 8 auth
PHP Laravel
0 vote93 views2 answers
Php function to remove underscore
PHP