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 vote303 views1 answer
Pdo example
PHP
1 vote352 views4 answers
Create json laravel
PHP
2 votes395 views1 answer
How to use php to set title
PHP
3 votes312 views1 answer
How to call php in html
PHP
0 vote315 views2 answers
Php mysql text mark question
PHP
1 vote397 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote346 views1 answer
Prestashop 1.7 get current language id
PHP
1 vote387 views3 answers
Laravel required if
PHP
12 votes348 views2 answers
Php loop x times
PHP
18 votes404 views6 answers
Laravel carbon create date from string
PHP Laravel