Breaking News: Grepper is joining You.com. Read the official announcement!

php pdo bindvalue array

Tiago F2 answered on August 26, 2021 Popularity 7/10 Helpfulness 3/10

answer php pdo bindvalue array

php pdo bindvalue array

Comment

<?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();
?>

Popularity 7/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: bindvalue pdo php

Link to this answer
Share Copy Link