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 vote173 views1 answer
Failed to open stream permission denied in php
PHP
0 vote180 views2 answers
Wordpress admin redirecting to http
PHP
0 vote226 views1 answer
Wordpress add new page programmatically
PHP Wordpress
7 votes193 views3 answers
Wordpress echo the date in post
PHP Wordpress
0 vote184 views1 answer
Phpspreadsheet middle align
PHP
1 vote166 views1 answer
Change minutes in to hours carbon
PHP
0 vote168 views3 answers
Php rsa encryption
PHP
1 vote186 views1 answer
How to catch query exception in laravel 8
PHP
3 votes190 views3 answers
Php pi() function
PHP
0 vote162 views1 answer
Wp cpt dashicon
PHP