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 vote94 views2 answers
$validator = Validator::make($request->all(), [
PHP
0 vote105 views1 answer
Strtotime laravel
PHP
3 votes133 views2 answers
Cookies are blocked or not supported by your browser. You must enable cookies to use WordPress.
PHP Wordpress
9 votes118 views3 answers
Define url wordpress
PHP Wordpress
0 vote87 views1 answer
Php thread safe or non thread safe
PHP
36 votes115 views5 answers
Php refresh page
PHP
4 votes104 views2 answers
Date_default_timezone_set for india in php
PHP
7 votes161 views1 answer
Laravel db seed specific class
PHP Laravel
11 votes150 views6 answers
Laravel route
PHP Laravel
0 vote103 views1 answer
Codeigniter select where
PHP