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 vote198 views1 answer
How to mantain text in form after error php
PHP
7 votes200 views2 answers
Modal show not close jquery
PHP
0 vote209 views1 answer
How to develop package beside laravel project
PHP Laravel
12 votes193 views6 answers
Laravel validation
PHP Laravel
0 vote193 views3 answers
Lookup token information in vault
PHP
1 vote201 views1 answer
Laravel create on model
PHP Laravel
0 vote188 views1 answer
Count remaining days php
PHP
4 votes213 views3 answers
Laravel view routes
PHP
1 vote213 views2 answers
How add field to table by another migration in laravel
PHP Laravel
1 vote174 views2 answers
$validator = Validator::make($request->all(), [
PHP