How to process the search form?

Question

Laravel

Good day. It is necessary to process the search form and issue values ​​depending on the form parameters.
There is this form:

<form name="searchForm" id="searchForm" action="{{ route('search') }}" method="post">

                {{ csrf_field() }}

                <div class="form-group">
                    <input type="text" name="searchString" id="searchString" class="form-control" placeholder="Поиск..." autofocus>
                </div>

                <div class="form-group">
                    <label for="sex">Пол:</label>

                    <input type="checkbox" name="man" value="male" checked> Муж
                    <input type="checkbox" name="woman" value="female" checked> Жен
                </div>

                <div class="form-group">
                    <label for="age">Возраст:</label>
                    <input type="text" id="ageFrom" name="ageFrom" placeholder="С">
                    <input type="text" id="ageTo" name="ageTo" placeholder="По">
                </div>

                <div class="form-group">
                    <input type="submit" name="submitBtn" id="submitBtn" value="Поиск" class="btn btn-default">
                </div>
            </form>

and the method that handles it:

public function search(Request $request)
    {

//        dd($request->man);

        $users = User::where(function ($query) use ($request) {
            $query->where('first_name', 'like', '%'.$request->searchString.'%')->
                    orWhere('last_name', 'like', '%'.$request->searchString.'%')->
                    orWhere('middle_name', 'like', '%'.$request->searchString.'%')->get();
        })->where(function ($query) use ($request) {
            if ($request->man && $request->woman) {
                $query->where('sex', 'male')->where('sex', 'female');
            } elseif ($request->man && !$request->woman) {
                $query->where('sex', 'man');
            } elseif (!$request->man && $request->woman) {
                $query->where('sex', 'female');
            } else {
                $query->where('sex', null);
            }
        })->where(function ($query) use ($request) {

        })->paginate(2);

        return view('user.index')->withUsers($users);
    }

How do I build a query builder query to make it work?

Answer 1

First, replace this

if ($request->man && $request->woman) {
    $query->where('sex', 'male')->where('sex', 'female');
} elseif ($request->man && !$request->woman) {
    $query->where('sex', 'man');
} elseif (!$request->man && $request->woman) {
    $query->where('sex', 'female');
} else {
    $query->where('sex', null);
}

On this

if ($request->man) {
    $query->where('sex', 'man');
} 
if ($request->woman) {
    $query->where('sex', 'female');
}

And change the checkbox to the radio

Answer 2

You yourself have complicated everything, you just need to wherepass an array, checkboxes and that's it. For example:

$users = DB::table('users')->where([
// То есть сюда массив с тем, что там у вас в форме на выбирали при поиске и все.
    ['sex', 'man'],
    ['sex', 'female'],
])->get();

Here is an example for one field of an array of values, in the above for many fields. You need this example
then:

$users = DB::table('users')
// ['man', 'female'] Это массив с реквеста, тут может быть и null и man и сразу все вместе... и что вам нужно
                    ->whereIn('sex', ['man', 'female'])
                    ->get();