Passing Array using GET with PHP/jQuery

Question

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!

Community · Accepted Answer · 2023-11-17 20:38:18Z

2

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.

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Sep 13, 2009 at 0:04

Jeremy Logan

47.6k39 gold badges125 silver badges145 bronze badges

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

2 Comments

KiNgMaR Over a year ago

Can't emphasize the "make sure you're sanitizing the input" part enough.

karim79 Over a year ago

Voted up. Just to add join will also work just fine for arrays of zero or one elements; i.e. the resulting string from joining an array with just one element will not get a ',' appended to it (so it's still okay in your IN(..). An array with zero elements will return the empty string, you might want to test for that before constructing your query.

Collectives™ on Stack Overflow

Passing Array using GET with PHP/jQuery

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related