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

30 votes197 views4 answers
Date diff php
PHP
0 vote261 views3 answers
Writing into the database with one click laravel
PHP Laravel
0 vote231 views1 answer
Include Custom Post Types Categories to the main query
PHP
0 vote172 views1 answer
Uncaught Error: Class 'Illuminate\Foundation\Application' in laravel bootstrap
PHP
0 vote175 views2 answers
Php multi elseif statement ternary
PHP
7 votes630 views3 answers
Laravel active menu item
PHP Laravel
0 vote182 views1 answer
Foreign key cosntraint laravel
PHP
1 vote187 views1 answer
Select selected fields in laravel join
PHP
0 vote184 views1 answer
PHP Fatal error: Uncaught Error: Class 'IntlDateFormatter' not found in /var/www/html/magento/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121
PHP
0 vote213 views1 answer
Laravel nginx
PHP Laravel