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

8 votes222 views3 answers
Get theme path in wordpress
PHP Wordpress
50 votes184 views6 answers
Left join laravel
PHP
8 votes184 views10 answers
Pluck array in laravel
PHP
0 vote177 views1 answer
Php curl pass user:password
PHP
0 vote198 views1 answer
MySQL eqSql Connection
PHP
1 vote193 views2 answers
Laravel gmail
PHP
0 vote206 views1 answer
Function to fetch user details
PHP
0 vote183 views1 answer
Laravel phpdoc collection of model
PHP
1 vote175 views1 answer
Limiting requests to controllers in laravel
PHP
0 vote214 views1 answer
$_get and $_post in php
PHP