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 vote93 views1 answer
Laravel collection last
PHP
4 votes110 views2 answers
Validate year laravel
PHP
0 vote127 views1 answer
Laravel env asset_url
PHP Laravel
0 vote95 views1 answer
Laravel eloquent order by alphabetical order
PHP
0 vote124 views1 answer
How to pass token with post request laravel
PHP Laravel
10 votes95 views3 answers
Php random array name
PHP
0 vote106 views1 answer
New DateInterval 1 hour
PHP
0 vote117 views1 answer
Trying to get property 'id' of non object in laravel api
PHP Laravel
1 vote97 views1 answer
Php echo alot of html
PHP
0 vote111 views1 answer
Wordpress custom loop latest first
PHP Wordpress