如何使用文本框过滤数据库记录 - 单选按钮 - 使用laravel的Dropdown和Datepicker

Question

Hi guys how can i implement search functionality in my Laravel app?

How to Filter Database Records using Textbox - Radio Buttons - Dropdown and Datepicker using laravel

Answer 1

You may send your filters with ajax request (or http request, it's up to you) and at server side then you can filter your queries using when(bool $condition, callback $query). Its quite elegant way to creating filter - based queries.

$query = Product::query();

$query->when($request->category,function ($q) use ($request){
    $q->where("category",$request->category)
});

$query->when($request->has("min_price"),function ($q) use ($request){
    $q->where("price",">=",$request->min_price)
});

// and other filters...

$result = $query->get();