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

1 vote138 views1 answer
Php counting number of chars excluding newlines
PHP
0 vote235 views2 answers
Yii2 get params from url
PHP Yii
0 vote123 views1 answer
Apache use public folder as root
PHP
11 votes143 views5 answers
Php header allow cross origin
PHP
0 vote128 views1 answer
Cara membuat looping table dengan php
PHP
16 votes147 views6 answers
Laravel validation array
PHP Laravel
0 vote121 views1 answer
Filtering Eloquent collection data with filter
PHP
0 vote116 views2 answers
Php cookie never expire
PHP
4 votes141 views4 answers
Php array to js
PHP
9 votes119 views5 answers
Laravel updateOrInsert
PHP