PDO/MySQLi and array in query?

Question

PHP

good time of day). There is such an array in the $jsondecoded variable:

array (size=3)
  0 => string 'B' (length=1)
  1 => string 'C' (length=1)
  2 => string 'D' (length=1)

How can you write such SQL in PDO or MySQLi?:

SELECT * FROM news WHERE id = /* значения $jsondecoded... eg. (B || C || D) */

PS There is also json: ["B","C","D"]
PPS The size of array and json can change up or down, depending on what the user chooses (that is, it can be ["B"] and [" B","C","D","S"])

Answer 1

$ids = array('B','C','D'); // ваш  $jsondecoded массив
$marks = implode(',', array_fill(0, count($ids), '?'));
$stmt = $pdo->prepare("SELECT * FROM news WHERE id IN ($marks)");
foreach ($ids as $k => $id) {
    $stmt->bindValue(($k+1), $id);
}
$stmt->execute();

Answer 2

• PDO - phpfaq.ru/pdo#in
• Mysqli is half a screen of text, so it's really sad without a wrapper.

But with a wrapper - just the bottom of the line

$data = $db->getAll("SELECT * FROM news WHERE id IN (?a)", $json);