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

1 vote169 views1 answer
Php debug telegram bot
PHP
13 votes179 views6 answers
Laravel api routes
PHP Laravel
2 votes189 views2 answers
Laravel 8 websockets
PHP
8 votes210 views1 answer
Laravel command to create symlink storage
PHP Laravel
0 vote176 views1 answer
No match for argument: phpmyadmin yum
PHP
2 votes175 views1 answer
Laravel clear everything
PHP Laravel
0 vote148 views2 answers
File_get_contents('php //input')
PHP
1 vote159 views1 answer
Php turney if
PHP
3 votes260 views1 answer
Start server symfony command
PHP
-75 votes173 views10 answers
Code
PHP