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 vote157 views2 answers
Concat in where clause laravel query builder
PHP Laravel
1 vote209 views1 answer
Wordpress escape string
PHP Wordpress
0 vote151 views1 answer
Woocommerce remove payment method when totla is 0
PHP
0 vote153 views1 answer
How to Create a Transient PHP wordpress
PHP Wordpress
3 votes144 views2 answers
Acf options repeater
PHP
2 votes150 views2 answers
Where is php.ini file in ubuntu
PHP
1 vote244 views1 answer
Php get option value
PHP
0 vote143 views1 answer
Woocommerce disable payment method if coupon appied and total is 0
PHP
47 votes154 views6 answers
Php array lenght
PHP
0 vote176 views1 answer
Cloudinary laravel
PHP