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 vote265 views1 answer
Can't see php7 in my mac
PHP
47 votes289 views6 answers
Php array lenght
PHP
0 vote306 views1 answer
Orwherebetween laravel
PHP
1 vote316 views1 answer
[Doctrine\DBAL\DBALException]Unknown database type enum requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it.
PHP
1 vote288 views1 answer
Get key of array element php
PHP
1 vote321 views4 answers
Laravel assign active based on route name
PHP Laravel
0 vote276 views1 answer
Index:of curiosa 2019 mp4
PHP
7 votes285 views4 answers
Php sort by associative array value
PHP
5 votes287 views2 answers
Gallery advanced custom fields
PHP
34 votes296 views2 answers
Add a new column to existing table in a migration
PHP