当前位置：网站首页>Laravel's own paging query

Laravel's own paging query

2022-04-23 03:03:00 【Stupid little attendant】

1. model layer , It's using paginate();

public function selectWhereJoin($table,$where,$order,$orderBy,$limit,$joinTable,$leftjoin)
{
    
     $datas = DB::table($table)
         ->leftjoin($joinTable,$leftjoin)
         ->where($where)
         ->orderBy($order,$orderBy)
         ->paginate($limit);

     return $datas;
 }

2.controller layer 

$order = 'ims_tiger_newhu_dmorder.id';
$orderBy = 'desc';
$limit = 10;
$joinTable = 'ims_tiger_newhu_member';
$leftjoin = [['ims_tiger_newhu_member.id','=','ims_tiger_newhu_dmorder.p_id']];

$model = new CooperationPlatformModel();
$datas = $model->selectJoin($this->table,$order,$orderBy,$limit,$joinTable,$leftjoin);

return view('cooperationOrder.duomaiOrderBrowser', ['datas' => $datas]);

3. Front page use , Use it directly { { $datas->links() }}
Insert picture description here

版权声明
本文为[Stupid little attendant]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220630238567.html

边栏推荐

猜你喜欢

随机推荐