Laravel5.8多条件搜索分页例子

2019-12-25 阅读：2322 类型：后端分类：Laravel 标签： Laravel

控制器：

<?php
    //控制器代码
	public function vod_search(Request $request){
        $where = [];
        if ($request->filled('name')) {
            $where[] = ['name','like','%'.$request['name'].'%'];
        }
        if ($request->filled('pid')) {
           $where[] = ['pid','=',$request['pid']];
        }
        if ($request->filled('release_time')) {
            $where[] = ['release_time','=',$request['release_time']];
        }
       $list=DB::table('art')
                    ->where($where)
                    ->OrderBy('id','desc')
                    ->paginate(15);
        return view('admin.art.art_list',['list'=>$list]);
    }

?>

视图：

Laravel5.8多条件搜索分页例子

appends(Request::all()) 记住搜索条件

<?php
//视图代码
<table class="table table-bordered">
	<thead>
	<tr>
		<th><input type="checkbox" class="i-checks" id="allChecks"  onclick="ckAll()" ></th>
		<th>编号</th>
		<th>名称</th>
		<th>添加时间</th>
		<th>最近更新</th>
		<th>操作</th>
	</tr>
	</thead>
	<tbody>
	@foreach($art_list as $item)
	<tr>
		<td>
			<input type="checkbox" class="i-checks" name="ids" value="{{$item->id}}">
		</td>
		<td width="50px">{{$item->id}}</td>
		<td>{{$item->name}}</td>
		<td>{{$item->created_at}}</td>
		<td>{{$item->updated_at}}</td>
		<td width="200px">
			<a href="{{route('admin.art.art_edit',['id'=>$item->id])}}" class="btn btn-info btn-sm"><i class="fa fa-edit"></i> 编辑</a>
			<a href="javascript:;" onclick="art_del(this,'{{$item->id}}')" class="btn btn-danger btn-sm"><i class="fa fa-trash-o"></i> 删除</a>
		</td>
	</tr>
	@endforeach
	@if($art_list->isEmpty())
		<tr><td colspan="13" style="text-align: center">Oh no! 暂无数据</td></tr>
	@endif
	</tbody>
</table>
<div class="pull-right">
	{{ $art_list->appends(Request::all())->links() }}
</div>
?>