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 vote300 views1 answer
How to show login user name in php
PHP
0 vote332 views2 answers
How do i use php read excel file
PHP
0 vote354 views2 answers
Laravel display category post by slug
PHP Laravel
0 vote327 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel
0 vote479 views1 answer
Symfony request post
PHP Symfony
2 votes374 views2 answers
Disable Bitnami Banner Wordpress
PHP
0 vote298 views1 answer
Php html select option array
PHP
0 vote300 views1 answer
Create orphan token in vault
PHP
8 votes337 views6 answers
Laravel eloquent with
PHP Laravel
0 vote311 views3 answers
Old codestar checkbox field
PHP