Searching between two numbers(prices) in Laravel

Question

I'm trying to run an eloquent query to filter results by category, then title, then price. category and title work as they should but when i added BETWEEN for searching between two prices it broke. Does anyone know how i could fix my query?

@foreach(Inventory::where('category', '=', $cat)->where('title', 'LIKE', '%'. $search_query .'%')->where('price', 'BETWEEN', $min_price, 'AND', $max_price)->get() as $search_results)

Answer 1

You're looking for whereBetween(). First, put the Eloquent query in your controller:

$inventory = Inventory::where('category', $cat)
    ->where('title', 'like', '%' . $search_query . '%')
    ->whereBetween('price', [$min_price, $max_price])
    ->get();

Then, pass the $inventory variable to your view:

return view('my.view.path', compact('inventory'));

Finally, in your view, you can loop through the results:

@foreach($inventory as $search_results)

See the Laravel Docs for more info.