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

如何在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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果