Laravel querying array

Question

I am trying to create a eloquent query to get the user results of an array of user id's. Is there a clean way to accomplish this using elequent instead of chaining wheres like this:

$users = User::where('id', '=', '1')->orWhere('id','=','2')

My array of ids comes from an API call and can contain as many id's as the call passes.

Cheers!

jszobody · Accepted Answer · 2014-10-23 19:47:34Z

2

You want to use whereIn. This lets you pass in an array of IDs.

$userIds = [1, 2];
$users = User::whereIn('id', $userIds)->get();

answered Oct 23, 2014 at 19:47

jszobody

29k6 gold badges66 silver badges76 bronze badges

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

1 Comment

user3443430 Over a year ago

Amazing! so simple and clean.. Thank you!!

Collectives™ on Stack Overflow

Laravel querying array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related