Using Array in '->where()' for Laravel Query Building

Question

I am trying to get all values of a column, and then use it in another query. I used lists and got the values as an array but, I couldn't find the way to check that variable (array containing each id) in other query

$subscribes = Subscribe::where('from_id', $currentUser)->lists('id')

// dd($subscribes), logs values as array.


$videos = Photo::where('id', $subscribes)->get();

This doesn't work because $subscribes is an array.

Should I use a for loop and send another query for each id? Or is there a practical way that I am missing out? What is the proper way of using it?

is it below one working?

Simhachalam Gulla
– Simhachalam Gulla

2015-12-16 12:43:58 +00:00
Commented Dec 16, 2015 at 12:43 — Simhachalam Gulla
– Simhachalam Gulla, Commented Dec 16, 2015 at 12:43

Steve · Accepted Answer · 2015-12-16 12:21:51Z

3

Use whereIn method:

$videos = Photo::whereIn('id', $subscribes)->get();

http://laravel.com/docs/5.1/queries (scroll down / search 'whereIn')

answered Dec 16, 2015 at 12:21

Steve

20.5k5 gold badges47 silver badges71 bronze badges

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

Comments

Simhachalam Gulla · Accepted Answer · 2015-12-16 12:25:04Z

1

Apply whereIn method

if(is_array($subscribes) && count($subscribes) > 0){
    $videos = Photo::whereIn('id', $subscribes)->get();
}

answered Dec 16, 2015 at 12:25

Simhachalam Gulla

9881 gold badge7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Using Array in '->where()' for Laravel Query Building

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related