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 vote114 views1 answer
Category title in post
PHP
27 votes115 views4 answers
How to color php text
PHP
-1 vote133 views1 answer
Stripslash
PHP
1 vote136 views1 answer
Laravel check pagination in blade
PHP Laravel
0 vote112 views1 answer
Logout php mysql
PHP
0 vote117 views1 answer
Textarea autocomplete phpmyadmin style
PHP
7 votes157 views4 answers
With message in laravel
PHP Laravel
3 votes126 views3 answers
Php best debugging functions
PHP
0 vote153 views1 answer
Newrelic apache virtual hosts
PHP
1 vote119 views1 answer
I+= in php
PHP