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

6 votes159 views1 answer
How do decode base64 php
PHP
-1 vote256 views1 answer
Get specific word from string php
PHP
0 vote171 views2 answers
Laravel auth login with phone or email
PHP Laravel
-1 vote216 views1 answer
Email php using html
PHP
-1 vote90 views2 answers
What does !count mean laravel
PHP
0 vote167 views1 answer
Calculate average in eager loading laravel
PHP Laravel
5 votes130 views3 answers
Home url wordpress
PHP
2 votes140 views4 answers
Laravel where in array
PHP Laravel
0 vote158 views1 answer
How To Clear Laravel.Log In Laravel?
PHP
0 vote127 views1 answer
How to get yearly chart in laravel
PHP