dpz90118
2019-04-17 04:47
浏览 57
已采纳

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

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');
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dtqu72830 2019-04-17 10:47
    已采纳

    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.

    打赏 评论

相关推荐 更多相似问题