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 vote191 views1 answer
Blocking youtube adds in php
PHP
5 votes142 views2 answers
Db::statement in laravel
PHP
0 vote135 views1 answer
Php ussd
PHP
0 vote149 views1 answer
Symfony request type
PHP
1 vote141 views1 answer
Laravel + join 2 eloquent queries
PHP
14 votes145 views2 answers
Php 3 digit decimal
PHP
0 vote174 views4 answers
Laravel upload image
PHP Laravel
7 votes149 views4 answers
Php create Hmac sha256
PHP
0 vote151 views1 answer
Php strftime year 2 digits
PHP
0 vote193 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel