laravel paginate分页使用orderBy排序无效解决办法

最新推荐文章于 2024-07-20 20:07:20 发布

_________MAN

最新推荐文章于 2024-07-20 20:07:20 发布

阅读量5.2k

点赞数

分类专栏： PHP

PHP 专栏收录该内容

19 篇文章 1 订阅

订阅专栏


use Illuminate\Pagination\Paginator;
use Illuminate\Pagination\LengthAwarePaginator;
//......

$perPage = 15;
$currentPage = $request->input('page', 1);
$offset = ($currentPage - 1) * $perPage;
$total = Member::where('status','A')->count();
$result = Member::where('status','A')->orderBy('code','desc')->offset($offset)->limit($perPage)->get();
$members = new LengthAwarePaginator($result,$total,$perPage,$currentPage,[
'path' => Paginator::resolveCurrentPath(),
'pageName' => 'page']);

转载至https://github.com/jenssegers/laravel-mongodb/issues/858