douzhan1994
douzhan1994
2016-11-26 10:15

如何在Laravel中实现分页以及排序结果

已采纳

I'm pretty new to Laravel, and still exploring it's features and possibilities, and I've came across a strange issue that I don't quite understand.

First of all, I'm using Laravel 5.0 and I'm trying to make pagination of results that came from model alongside with sorting them.

Here is the code that works, but without sorting:

News::paginate(5);

And here is what I need, but doesn't work:

News::paginate(5)->orderByDesc('published_at');

I've tried doing it like so:

News::all()->sortByDesc('published_at')->paginate(5);

But then, when I call render() method inside view it throws error. I would like to use model's approach since it's handy and few more things depend on it, and not query builder method. Also, would like, if possible to avoid manual or any kind of custom pagination. Thanks

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • douwei7976 douwei7976 5年前

    You should write this. This will solve your problem

    News::orderBy('published_at','desc')->paginate(5);
    
    点赞 评论 复制链接分享

相关推荐