Laravel query is not working with multiple IDs

Question

I am trying to fetch multiple rows of selected IDs from db. Here is my controller code

$products = new product;
$products = $products->select('products.*', 'categories.category_name')->join('categories', 'products.product_category', '=', 'categories.id');
$products = $products->whereIn('products.id', [$request->list]); //$request->list is post value (12,13)
$products = $products->get();

Here $request->list is post value which contains 12,13. Mentioned code works fine if I manually type IDs like this.

$products = $products->whereIn('products.id', [12,13]);

But if I try to call same with variable or directly with request post then it is returning only one result.

$products = $products->whereIn('products.id', [$request->list]); 
//OR
$id = $request->list;
$products = $products->whereIn('products.id', $id);

Why it is giving only one result when I use variable, any idea?

Yasin Patel · Accepted Answer · 2021-07-20 08:15:42Z

1

$request->list contains comma separated values, so convert it to an array. Change it as below:

$products = $products->whereIn('products.id', explode(',',$request->list));

Here is a full query:

$products = product::select('products.*', 'categories.category_name')
->join('categories', 'products.product_category', '=', 'categories.id')
->whereIn('products.id',explode(',',$request->list))
->get();

edited Jul 20, 2021 at 8:15

answered Jul 20, 2021 at 8:03

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Laravel query is not working with multiple IDs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related