How to do Laravel search?

Question

Laravel

How can I search in Laravel using one form in several fields and in one field?
Now the search method looks like this:

public function search(Request $request)
{
    $result = DB::table('ads')
        ->where('city',  $request->city)
        ->orWhere('category', $request->cat)
        ->get();

    dd($result);    
}

If I'm looking for the 1st field, then everything is fine, but if I'm looking for the 2nd fields, then only the 1st is searched, and the second is ignored.

Answer 1

How to make friends in Laravel 5 where()->orWhere and whereIn()?

Answer 2

$cityId = $request->input('city_id');
$categoryId = $request->input('category_id');

$adverts = Advert::when($cityId, function ($query, $cityId) {
    $query->where('city_id', $cityId);
})
    ->when($categoryId, function ($query, $categoryId) {
        $query->where('category_id', $categoryId);
    })
    ->get();

Answer 3

Good and relevant article.

Answer 4

This is where the Builder pattern comes in. You will check if there is a request with a name, then make such and such a selection. If there is a second request, then we perform the action. Fields can be any number