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

4 votes156 views4 answers
How to add an array into an associative array in php
PHP
1 vote143 views1 answer
Check if delete query was successful laravel
PHP
0 vote171 views1 answer
Laravel checkbox checked
PHP
0 vote164 views1 answer
Laravel change string to text
PHP Laravel
0 vote146 views1 answer
How to display the site tagline in wordpress
PHP
0 vote145 views1 answer
Eliminar ultimo caracter string php
PHP
0 vote225 views3 answers
Laravel model sync
PHP Laravel
-1 vote161 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP Laravel
1 vote149 views1 answer
Wp get field taxonomy
PHP
0 vote158 views1 answer
Laravel permission create role
PHP Laravel