Laravel: whereIn with variable

Question

I'm trying to collect all the records that belong to the sections that happen to them in the variable $sections. But only those from section 1 pick me up. Any suggestions?

$sections = '1,2,3';

$data = News::where('active', '1')
        ->whereIn('section_id', [$sections])
        ->get();

If I substitute $sections in the query for the values, this works, but if I use the variable $sections, It doesn't work.

Thanks.

score 7 · Accepted Answer · answered Jan 24 '18 at 11:00

7

When you use whereIn() you must pass an array and not string:

$sections = explode(',', '1,2,3');

answered Jan 24 '18 at 11:00

Alexey Mezenin

158,981
26
290
279

He'd better $sections = [1,2,3]; – Amarnasan Jan 24 '18 at 11:04
@Amarnasan it's just an example. I don't think OP hardcodes these categories, but getting these from the request as a string or something. – Alexey Mezenin Jan 24 '18 at 11:05
1

Amarnasan, I tried it in the way you indicated earlier but I only got those from the first section. The answer from Alexey works correctly – nature Jan 24 '18 at 11:08

score 0 · Answer 2 · answered Jan 24 '18 at 11:03

0

Your $sections variable is a string. And you are passing that string to the array, not each individual numbers in the string.

Ex:

$users = DB::table('users')
                ->whereIn('id', [1, 2, 3])
                ->get();

answered Jan 24 '18 at 11:03

Nimeshka Srimal

8,012
5
42
57

Laravel: whereIn with variable

2 Answers2