下面是一个例子。
$perPage = $request->input("per_page", 10); $page = $request->input("page", 1); $skip = $page * $perPage; if($take < 1) { $take = 1; } if($skip < 0) { $skip = 0; } $basicQuery = DB::select(DB::raw(" select a.user_id, a.user_email, a.user_account_status, a.created_at, b.s_account_limit AS account_limit, c.consumed_limit, ((b.s_account_limit*1024) - c.consumed_limit) AS remaining_limit FROM upload_limits as b, users AS a JOIN user_upload_limits as c WHERE (a.user_id=c.user_id) AND a.user_type='Simple'")); $totalCount = $basicQuery->count(); $results = $basicQuery ->take($perPage) ->skip($skip) ->get(); $paginator = new \Illuminate\Pagination\LengthAwarePaginator($results, $totalCount, $take, $page); return $paginator;
JoyK Better personal homepage reddit styleGitHub Flavored Markdown syntax Adaptive layout
下面是一个例子。