How to work with the IN statement in PHP + PDO? [duplicate]

Question

How to work with the IN statement in PHP + PDO? [duplicate]

Navigation

#1 by (3 votes)

3

I'm trying to build a dynamic SQL but I'm getting caught by not understanding how to work with the IN statement in the PDO Example:

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

How to work with this statement in PDO? As a branch break I used the OR statement, but let's face it, it's not the best option! The Database is Postgres, but I think it is not the case, because I could not in MySQL either

php sql pdo

asked by anonymous 18.08.2017 / 22:20

1 answer

Is it correct to use PHP code in the view layer along with HTML? Primefaces DataTable Lazy - Table does not display records

score 3 · Answer 1

I understand that your code did not work, right?

Try to use one name per 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 do your code.

@EDIT

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