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

1 vote156 views1 answer
Edit data using model in laravel 8
PHP Laravel
0 vote132 views4 answers
Share var in a maser layout laravel
PHP Laravel
0 vote102 views1 answer
Laravel eloquent pass to next element
PHP
2 votes73 views1 answer
Laravel delete model with all relations
PHP
1 vote132 views1 answer
Php array merge skip diplicate
PHP
0 vote107 views2 answers
Download html content from url php
PHP
5 votes112 views3 answers
Create random username and password php
PHP
0 vote111 views1 answer
How to display the responce of curl in php
PHP
16 votes121 views2 answers
Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.3.0". You are running 7.2.34
PHP
0 vote129 views1 answer
Get base class name laravel
PHP