How to use pdo binding "IN" array of values?

Asked Mar 31 '15 at 15:48

Active Mar 31 '15 at 15:53

Viewed 32 times

How to use pdo binding "IN" array of values ?

I don't want to implode array, Is any way to do it ?

 $conditions .= ' OR table.ID IN (' . implode(',', $ipRet) . ') ';

i want to use elegant binding something like this

$conditions .= ' OR table.ID IN :players ';
$command->bindParam(":players", $array, PDO::{array});

Please suggest,

Thanks in advance

edited Mar 31 '15 at 15:53

asked Mar 31 '15 at 15:48

TomerM

Can you post your so far tried code? – Rikesh Mar 31 '15 at 15:48
2

http://stackoverflow.com/questions/920353/can-i-bind-an-array-to-an-in-condition – TiiJ7 Mar 31 '15 at 15:52
Thanks, I saw it but I don't like it so much. PDO hasn't build in support ? – TomerM Mar 31 '15 at 15:58
@Rikesh Mysql supports WHERE id = ANY (:an_array)? – TomerM Mar 31 '15 at 16:01
you dont want to use implode because you dont like implode??? and you want to use an elegant code without knowing about elegant codes. Thats crazy funny. Its nothing worse with useing implode like @TiiJ7 said – B001ᛦ Mar 31 '15 at 16:06
The question has already been answered in PDO Wiki http://stackoverflow.com/tags/pdo/info – david strachan Mar 31 '15 at 16:16

0 Answers0