douzhan1994 2016-11-26 10:15
浏览 407
已采纳

如何在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 2016-11-26 10:40
    关注

    You should write this. This will solve your problem

    News::orderBy('published_at','desc')->paginate(5);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果