Laravel - Builder object returned instead of Collection

Question

I have written a query to filter my products. This is my code:

    $products = \DB::table('products')->select('*');
    foreach ($request->all() as $cat => $subCat) {
        if($subCat != '*') {
            $products->where('id', $subCat);
        }
    }
    $products->get();

However, the query returns a Builder object and I can't figure out why.

What is exactly wrong?

Thanks.

What you get in $request->all() ? .Also share complete code how you return value ? — Niklesh Raut
– Niklesh Raut, Commented Nov 23, 2017 at 16:57

Niklesh Raut · Accepted Answer · 2017-11-23 17:00:05Z

1

I doubt you haven't assign value into variable, try this

$products = $products->get();

answered Nov 23, 2017 at 17:00

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Laravel - Builder object returned instead of Collection

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