passing a php array into an sql query [duplicate]

Question

This question already has an answer here:

I'm trying to make sql query for rows matching values in a php array.

Essentially I have an array like

$userIDs[0] = 23456;
$userIDs[1] = 42901;
$userIDs[2] = 82731;
$userIDs[3] = 23921;

And want to perform a single SQL query to get rows matching this array

SELECT * FROM users WHERE userID IN $userIDs

Is there an easy way to do this? Or do I have to manually construct the query string?

ain · Accepted Answer · 2011-09-04 09:09:03Z

up vote 11 down vote accepted

Use implode function ie

$QueryStr = "SELECT * FROM users WHERE userID IN (".implode(',', $userIDs).")";

answered Sep 4 '11 at 9:09

ain

16.9k23056

add a comment |

marked as duplicate by Levi Morrison, PeeHaa php Aug 28 '14 at 16:43