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 vote332 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
0 vote317 views1 answer
Get php ini config from terminal
PHP
0 vote320 views3 answers
#FF0000;
PHP
3 votes291 views1 answer
Delete all rows laravel
PHP
0 vote375 views1 answer
How to install or setup sanctum for laravel api authentication
PHP
1 vote364 views2 answers
Install laravel in ubuntu 20.04
PHP Laravel
23 votes301 views6 answers
Make auth in laravel 7
PHP
0 vote311 views1 answer
This domain is not registered with Tiny Cloud. Please see the quickstart guide or create an account.
PHP
0 vote359 views2 answers
Php pasar array por post
PHP
0 vote365 views1 answer
Validate file count with validate in laravel
PHP Laravel