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 vote108 views1 answer
Encrypt & decrypt laravel
PHP
0 vote139 views2 answers
Curl post laravel
PHP Laravel
0 vote201 views1 answer
Ajouter du contenu personnalisé sous chaque article/publication WordPress
PHP Wordpress
21 votes125 views3 answers
Query sql in php
PHP
1 vote144 views1 answer
Get all errors view laravel
PHP
-1 vote149 views1 answer
Authenticate user with phone laravel
PHP Laravel
-1 vote114 views2 answers
Remove double space php
PHP
1 vote118 views1 answer
Why job laravel do not worl
PHP
1 vote135 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
0 vote180 views3 answers
Laravel 7 factory tinker
PHP