How to work with IN instruction in PHP + PDO?

Question

I’m trying to build a dynamic SQL but I’m getting beat up for not understanding how to work with the IN statement in PDO Example:

$SQL = "select * from tabela where (campo in(:valor))";
$Query = Database::Prepare($SQL);
$Query->bindValue(":valor", "1,2");
$Query->Execute();

Field is Integer, I assumed that 1.2 would enter without problems as value, but it says that the search value is invalid, tried in several ways but without success

How to work with this instruction in PDO? As branch breaks I used the OR instruction, but let’s face it is not the best option! The Database is Postgres, but I think that’s not the case, because I could not in Mysql also

Answer 1

From what I understand your code didn’t work, correct ?

Try using a name by value:

$SQL = "SELECT * FROM tabela WHERE campo IN (:valor1, :valor2, :valor3)";
$Query = Database::Prepare($SQL);
$Query->bindValue(":valor1", "1");
$Query->bindValue(":valor2", "2");
$Query->bindValue(":valor3", "3");
$Query->Execute();

I believe the easiest and fastest way for you to make your code.

@EDIT

A solution would also be this:

<?php
$ids     = array(1, 2, 3, 7, 8, 9); //Valores de cada nome
$inQuery = implode(',', array_fill(0, count($ids), '?'));

$Query = Database::Prepare(
    'SELECT *
     FROM tabela
     WHERE campo IN (' . $inQuery . ')'
);


foreach ($ids as $k => $id)
    $Query->bindValue(($k+1), $id);

$Query->execute();
?>