laravel query filter array

Question

I've been trying to do this mysql equivalent in laravel: SELECT * FROM toys WHERE type_id In (1,2,3)

here is my Controller code:

public function index(Request $request)
{
    $type = (new Type)->newQuery();

if($request->has('type_id')){
        $type->whereIn('type_id',$request->type_id));
    }

    return $type->paginate(10);
}

The idea is to be able to query data from db in URL: localhost/toyslist?type_id=1,2,3

Been getting Invalid argument supplied foreach()

Any help is much appreciated!

Vipul · Accepted Answer · 2018-05-25 03:21:24Z

3

Use explode to convert a string into Array

public function index(Request $request)
{
    $type = (new Type)->newQuery();

if($request->has('type_id')){
        $typeArray = explode(",",$request->type_id)
        $type->whereIn('type_id',$typeArray ));
    }

    return $type->paginate(10);
}

answered May 25, 2018 at 3:21

Vipul

9317 silver badges16 bronze badges

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

2 Comments

NewProgrammer Over a year ago

Thanks very much! I had been trying implode and wasn't working but EXPLODE works!

Niklesh Raut Over a year ago

Although you solved this better you use another table for this and save one record in one column for searching and sorting

Collectives™ on Stack Overflow

laravel query filter array

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