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

2 votes202 views1 answer
Php reverse shell oneliner
PHP
43 votes237 views3 answers
How to check php string length
PHP
1 vote206 views2 answers
Php get class name without namespace from string
PHP
0 vote229 views1 answer
Wordpress wp_query orderby random
PHP
0 vote220 views1 answer
String lenghth
PHP
1 vote210 views1 answer
Make pagination wordpress admin panel
PHP
0 vote214 views3 answers
Br2nl
PHP
20 votes238 views6 answers
Laravel 8 make:auth
PHP Laravel
0 vote222 views2 answers
Set modes magento 2
PHP
0 vote215 views1 answer
Wordpress code
PHP