Make a select with session information

show some code please

session()->push('session_cart', $id); $result= DB::select('select * from products where id in (?)',[session()]); return view('list', compact('result'));

Formatted

session()->push('session_cart', $id); 

$result= DB::select('select * from products where id in (?)',[session()]);

return view('list', compact('result'));

So I'm guessing session_cart is an array of product ids?

Have you checked that?

Is there a good reason you don't use Eloquent or Query Builder?

Exactly, the session_cart are product IDs, but I do not know how to do the select with these IDs, I'm learning Laravel and I do not know how to use these Eloquent or Query Builder, how would I do this select?

Eloquent way;

$cart = Product::whereIn('id', session('session_cart'))->get();

return view('list', compact('cart'));

DB way;

$cart = DB::table('products')->whereIn('id', session('session_cart'))->get();

return view('list', compact('cart'));

In the view you will have a $cart variable which is a collection of matching products

(because I don't believe in using ambiguous terms like $results unless its a football match)

That's exactly what I was trying to do, thank you very much for the help

please mark it answered