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 vote355 views1 answer
Laravel schedule kernel code sample
PHP
0 vote398 views2 answers
Wp create user programmatically
PHP Wordpress
0 vote293 views1 answer
Call a blade from a blade in laravel 8
PHP
0 vote382 views1 answer
Get page name wp
PHP Wordpress
0 vote306 views1 answer
Laravel secure route
PHP
0 vote330 views1 answer
Php execute command and display output
PHP
0 vote344 views1 answer
Wp query meta in array
PHP
0 vote284 views1 answer
Php str_contains
PHP
0 vote394 views1 answer
Hide plugin update notification wordpress
PHP Wordpress
0 vote354 views1 answer
Cakephp 4 authentication
PHP