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 vote267 views2 answers
How to check user already exists in php
PHP
3 votes259 views3 answers
Php randon integer 4 digit
PHP
5 votes257 views2 answers
Route() and with() in laravel
PHP
0 vote312 views1 answer
Country code validation in laravel
PHP Laravel
0 vote266 views1 answer
Php check if folder empty
PHP
15 votes262 views3 answers
Laravel timezone
PHP
1 vote262 views2 answers
Laravel init
PHP Laravel
1 vote268 views1 answer
Laravel clone row
PHP
11 votes260 views5 answers
Laravel model transaction
PHP
2 votes271 views3 answers
Call stored procedure in laravel
PHP