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

5 votes118 views2 answers
Guzzle post request with data
PHP
-1 vote98 views1 answer
Pagination align right side in laravel
PHP
0 vote131 views1 answer
Not get child all data in relationship with parent laravel eloquent
PHP
0 vote149 views1 answer
Add object to http request php behamin proxy bproxy
PHP
0 vote187 views1 answer
Laravel DB facade relations
PHP
3 votes102 views1 answer
Laravel convert datetime to date
PHP
1 vote151 views1 answer
Laravel query get big table records
PHP Laravel
0 vote117 views1 answer
Vault create/enable secret engine
PHP
0 vote144 views1 answer
Yii2 GridView Filtering on Relational Column
PHP
0 vote158 views1 answer
File: C:\xampp\htdocs\marvellogistik\application\libraries\Profiler.php Line: 386 Function: sendDataInHeaders
PHP