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 vote222 views1 answer
Laravel eloquent save method return value
PHP
6 votes259 views3 answers
Laravel ide-helper
PHP
1 vote251 views1 answer
Php explode trim
PHP
1 vote229 views2 answers
Wordpress get option value
PHP
1 vote230 views1 answer
Magento debug white page
PHP
9 votes242 views3 answers
Object values to array php
PHP
8 votes226 views1 answer
Laravel sotrage linkl
PHP
11 votes252 views6 answers
Redirect route with parameters laravel
PHP Laravel
0 vote228 views1 answer
How get query logs in laravel
PHP
0 vote237 views2 answers
Foreach loop in php stack overflow
PHP