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

43 votes292 views2 answers
Get array length using php
PHP
1 vote325 views1 answer
XMLHttpRequest post not working
PHP
0 vote280 views1 answer
Create from format php
PHP
0 vote318 views2 answers
Smtp server xampp
PHP
0 vote335 views1 answer
Slow laravel testing
PHP Laravel
18 votes350 views1 answer
Laravel migation error
PHP Laravel
0 vote282 views1 answer
Laravel-5-on-shared-hosting-wrong-public-path
PHP
9 votes303 views3 answers
Array to string separated by comma php
PHP
0 vote316 views1 answer
Total days between two dates carbon
PHP
3 votes304 views2 answers
Acf options repeater
PHP