Passing Array using GET with PHP/jQuery

Question

Hello,

I'm currently using $.getJSON to pass an array of ids. It basically constructs a URL like this:

 http://domain.com/json.php?id=1&id=2&id=4

My question is: How can I take these ids that are passed (1,2,4) and place them in my where clause?

Something like:

$id = $_GET['id'];

 $sql = SELECT * FROM table WHERE usrID IN ($id);

Thanks very much!

Answer 1

Just join/implode them into a single string seperated by commas.

$sql = 'SELECT * FROM table WHERE usrID IN (' . join(',', $id) . ');';

You'll also want to make sure you're sanitizing the input.