//查询10条数据
\DB::table('users')
-> where('id', '>=', $id)
-> orderBy('id','desc')
-> take(10)
-> get();
//分页和连表查询
$member=\App\MemberModel::leftjoin('ys_employee','ys_employee.user_id','=','ys_member.invite_id')
->leftjoin('ys_invite_member','ys_invite_member.user_id','=','ys_member.user_id')
->select('ys_member.*','ys_employee.agency_id')
->orderBy('ys_member.created_at','desc');
$search=[];
if ($request->start != ''){
$member->where('ys_member.created_at','>=',$request->start.' 00:00:00');
$search['start']=$request->start;
}
if ($request->end != ''){
$member->where('ys_member.created_at','<',$request->end.' 59:59:59');
$search['end']=$request->end;
}
if ($request->mobile != ""){
$member->where('ys_member.mobile','like','%'.$request->mobile.'%');
$search['mobile']=$request->mobile;
}
if ($request->name != ""){
$member->where('ys_member.name','like','%'.$request->name.'%');
$search['name']=$request->name;
}
if ($request->agency != ''){
$member->where('ys_employee.agency_id','=',$request->agency);
$search['agency']=$request->agency;
}
$data = $member ->paginate(10);
页面里面
<div class="box-footer clearfix">会员:{{$data->total()}}人<br>
{!! $data->appends($search)->render() !!}
接口数据分页 每页显示几条
$start = $request->page <= 1 ? 0 : ($request->page - 1) * 10;//分页 //获取首页 新品上线(10个最新产品即可) $new_goods = \DB::table('ys_goods as a') ->leftjoin('ys_goods_extend as b','a.id','=','b.goods_id') ->leftjoin('ys_goods_image as c','a.id','=','c.goods_id') ->select('a.id as goods_id','a.name as goods_name','b.name as spec_name', 'b.market_price','b.price','b.id as ext_id','c.image') ->where('a.state',1) //0下架1上架 ->groupBy('a.id') ->orderBy('a.id','desc') //也就是时间顺序,倒序 ->skip($start) ->take(10) ->get();