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

6 votes335 views3 answers
How to get parameter from url in laravel blade
PHP
0 vote359 views2 answers
From user id to user role wordpress
PHP
0 vote347 views1 answer
Laravel query with optional filter
PHP Laravel
1 vote350 views1 answer
Laravel $loop interation
PHP Laravel
0 vote378 views3 answers
Cake php 2.x sql dump
PHP CakePHP
75 votes364 views6 answers
Php display errors
PHP
0 vote374 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP Laravel
0 vote328 views1 answer
Laravel whereHas undefined variable
PHP
0 vote331 views1 answer
Migration status php
PHP
1 vote356 views1 answer
Laravel php artisan make:controller in subfolder
PHP