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 vote218 views1 answer
Symfony 2.8 create database from entities
PHP
0 vote194 views2 answers
Web scraping
PHP
25 votes134 views13 answers
Password_hash example
PHP
0 vote231 views1 answer
Codeigniter check view file exists
PHP CodeIgniter
0 vote228 views2 answers
Mac install multiple php versions
PHP
1 vote202 views1 answer
How delete the table in laravel in the commend
PHP Laravel
0 vote198 views1 answer
Laravel collection all
PHP Laravel
12 votes170 views6 answers
Php remove new line character from string
PHP
0 vote214 views1 answer
Comment ajouter nofollow à un lien spécifique ou à tous les liens WordPress dans the_content
PHP
6 votes212 views3 answers
Laravel ecommerce
PHP Laravel