Selecting rows with id's that are found in a PHP array

Question

I am wondering how i can find all rows that have the same ID as one of the values in an array.. so lets say:

Array(1,2,5,6,99,467);

Now i want to query all rows which have an id in that array, my initial idea was to loop the array and use a SELECT on each field, but i am wondering if i can skip that process with some kind of in_array method to make a bit more efficient?

zerkms · Accepted Answer · 2012-06-21 23:58:04Z

4

SELECT * 
FROM table
WHERE id IN (' . implode(', ', $arr) . ')

PS: if the data comes from outside and can contain non-numbers - it could worth performing array_map('intval', $arr) before

answered Jun 21, 2012 at 23:58

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Sir Over a year ago

If i am using PDO for my queries, like this: $stmt->execute(array($array_data)); Will that still escape the array data for safe input ?

zerkms Over a year ago

@Dave: PDO doesn't have facilities for sanitizing the data presented as array. You need to do that yourself. PS: it doesn't accept arrays as a parameters as well

Sir Over a year ago

how would i sanitize the data inside the array before hand ?

zerkms Over a year ago

@Dave: If there are only numbers in array - then just $arr = array_map('intval', $arr);

DaveRandom Over a year ago

@zerkms I know I thought that as I wrote it - but it could potentially be useful if you have to insert multiple rows based on many arrays of a fixed length, or if you want to allow non-numeric types. It does cut out the array_map() call, but I suspect that what you gain there would be lost on the array_fill() plus the additional round trip to the DB.

|

Collectives™ on Stack Overflow

Selecting rows with id's that are found in a PHP array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related