laravel 带条件的分页查询

laravel 带条件的分页查询,

原文:http://blog.csdn.net/u011020900/article/details/52369094

bug:断点查询,点击分页,查询条件消失。

思路:追加(appends)查询条件

 1  $taskList = TaskList::where('assignedTo','=',$assignedTo)
 2 ->where($ary_where)->where($ary_where1)
 3 ->where($ary_where2)->orderBy('status_order','asc')
 4 ->orderBy('finishedDate','desc')->paginate(3);
 5        
 6         //分页处理
 7         $page = isset($page)?$request['page']:1;
 8         $taskList = $taskList->appends(array(
 9             'title'=>$title,
10             'project'=>$project,
11             'status'=>$status,
12             'page'=>$page
13             //add more element if you have more search terms
14         ));

view页面

<div style="margin: 0px" >{!! $taskList->links() !!}</div>

  

原文地址:https://www.cnblogs.com/wanlibingfeng/p/7697989.html