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 vote183 views1 answer
Function is not defined laravel
PHP
1 vote199 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
0 vote189 views1 answer
Import facade URL laravel
PHP Laravel
33 votes177 views6 answers
Php json_encode
PHP
0 vote287 views2 answers
Asset function in laravel not working
PHP Laravel
0 vote172 views1 answer
How to develop package beside laravel project
PHP
0 vote295 views2 answers
Obtener datos de usuario registrado en WordPress
PHP
13 votes188 views6 answers
Laravel count
PHP Laravel
0 vote227 views1 answer
Install sage
PHP
3 votes186 views4 answers
PHP executable not found. Install PHP 7 and add it to your PATH or set the php.executablePath setting
PHP