PDO select from where in array()

Asked May 13 '14 at 15:23

Active May 13 '14 at 15:23

Viewed 50 times

I am listing data from database using "where in" statement, and I don't have problem when my array is short, but I am not able to run this request with long array.

This is my code:

$dbc= new PDO(...);
$numbers="1,2,3,4,5,6,7,8";
$run=$dbc->prepare("SELECT * FROM users WHERE id IN ($numbers)");
$run=execute();

How can I run this code when my numbers is like:

$numbers="1,2,3,4,5,6,7,...3997,3998,3999,4000";

asked May 13 '14 at 15:23

mandza

What error do you get? – hanleyhansen May 13 '14 at 15:26
I don't get any error just my data is not displayed – mandza May 13 '14 at 15:26
`$number` isn't an array. – Albzi May 13 '14 at 15:27
See also [binding an array to an `IN` condition in PDO](http://stackoverflow.com/questions/920353/can-i-bind-an-array-to-an-in-condition) – tadman May 13 '14 at 15:27
@BeatAlex I know that $numbers is not an array but it work for a short list of numbers why it doesn't work for a long one? that is my question. – mandza May 13 '14 at 15:31
Wait, I didn't read this question properly at all. – Albzi May 13 '14 at 15:35
why do you want such a big list? – Your Common Sense May 13 '14 at 15:35
Why are you now asking him questions are closing it as a duplicate? Bit late isn't it? @YourCommonSense – Albzi May 13 '14 at 15:36
Could this just be simply a time out of the server loading loads of results? – Albzi May 13 '14 at 15:36
@BeatAlex it could be server overloading but when I run mysql request for every ID separately it work fine but page is loading for about 40-45 sec. – mandza May 13 '14 at 15:48
@YourCommonSense it is bit complicate :) The list is not long all the time but sometimes I need to list at most 4000 users with their id name surname and cell phone. – mandza May 13 '14 at 15:51
did you try "PDO query fails but I can't see any errors. How to get an error message from PDO?" answer from the linked post? – Your Common Sense May 13 '14 at 16:09
@YourCommonSense I had solved problem with $in = str_repeat('?,', count($numbers) - 1) . '?'; but i still don't know why my code was not working. what is causing a problem Ç) – mandza May 13 '14 at 16:35
there is a dedicated answer on this very problem - How to know what error it was? – Your Common Sense May 13 '14 at 16:36

PDO select from where in array()

0 Answers0