News for hackers. Stuff that matters.
Re:Up to 12M websites may have been compromised via Drupal v... by SapphireSun on Saturday November 01, 2014 @04:29PM (#8544493)
Just use a placeholder like (??) and flatten everything out. Translate (??) and array(1,2,3) into (?,?,?) with 1, 2, 3 as the binds.
Re:Up to 12M websites may have been compromised via Drupal v... by mappu on Sunday November 02, 2014 @12:56AM (#8545670)
Then what do you do if the passed tuple has zero length?

Dynamically rewriting the SQL isn't going to be tractable in all cases - doing `IN (NULL)` might be a valid value - and throwing an exception is poor form for an actually valid case.

Re:Up to 12M websites may have been compromised via Drupal v... by SapphireSun on Wednesday November 05, 2014 @12:45AM (#8560661)
Check for bad inputs? I'm not saying this is a cure all, but it's a lot better than not being able to use arrays at all.
Re:Up to 12M websites may have been compromised via Drupal v... by jiggy2011 on Saturday November 01, 2014 @04:49PM (#8544569)
I don't think PDO supports this AFAIK.
Re:Up to 12M websites may have been compromised via Drupal v... by SapphireSun on Wednesday November 05, 2014 @12:42AM (#8560656)
I had to implement it manually, but it works. FWIW, I'm using a custom wrapper around MySQLi though.