如何在laravel中使用搜索功能？

Question

I have write code of search bar in laravel, I am doing pagination manually, but my search function is not working,

here is my code of view file

<form action="{{url('search-department')}}" method="GET" role="search">
    <div class="form-group">
        <input type="text" class="form-control" name="q" placeholder="Search Department">
    </div>
</form>

My Controller File Is

//Code For Insert record in collection
public function storeDepartment(Request $request)
{
    $department = new Department();
    $department->createdBy = $request->get('createdBy');
    $department->nameOfDepartment = $request->get('nameOfDepartment');
    $department->save();

    return redirect('list-department')->with('Success', 'Department Added Successfully!');
}

//Code For Seach
public function search(Request $request)
{
    $q = Input::get('q');

    if ($q != '') {
        $listOfDepartment = Department::where('nameOfDepartment', 'like', '%' . $q . '%')
            ->orwhere('createdBy', 'like', '%' . $q . '%')
            ->paginate(2);

        if (count($listOfDepartment) > 0) {
            return view('pages.department')->withData($listOfDepartment);
        }
        // return view('pages.department')->withMessage("No Data Found");
    }
}

and route is

Route::get('search-department', 'DepartmentController@search');

Answer 1

I think You should try this code.

In view

<form role="search" method="GET">
    <div class="form-group">
        <input type="hidden" name="_token" value="{{csrf_token()}}">
        <input type="text" class="form-control" name="q" placeholder="Search Department">
    </div>
</form>

And in Controller

public function search(Request $request)
{
    $listOfDepartment = Department::select('*');

    if(isset($request->q) && !empty($request->q))
    {
        $q = $request->q;
        $listOfDepartment = $listOfDepartment->where('nameOfDepartment', 'like', '%' . $q . '%');
        $listOfDepartment = $listOfDepartment->orWhere('createdBy', 'like', '%' . $q . '%');
    }

    $listOfDepartment = $listOfDepartment->->paginate(2);

    if (count($listOfDepartment) > 0) {
        return view('pages.department')->withData($listOfDepartment);
    }
    // return view('pages.department')->withMessage("No Data Found");
}

Hope This will help you.