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

2 votes117 views3 answers
Laravel 8 404 status
PHP Laravel
0 vote124 views1 answer
Php store session in cookie
PHP
0 vote103 views1 answer
How to check ia folder if no have files in php
PHP
1 vote103 views1 answer
How get the latest arraye value in laravel
PHP Laravel
1 vote97 views3 answers
Post request axios php
PHP
2 votes116 views2 answers
Laravel validate form data unique
PHP Laravel
16 votes95 views3 answers
Change existing migration laravel
PHP
0 vote94 views2 answers
Php send values in $_SESSION to other page
PHP
0 vote110 views1 answer
Access storage from the view laravel 6
PHP Laravel
8 votes134 views1 answer
Laravel return back with success
PHP Laravel