且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Laravel orderBy 关系

更新时间:2023-12-03 23:44:58

可以通过查询函数扩展关系:

It is possible to extend the relation with query functions:

<?php
public function comments()
{
    return $this->hasMany('Comment')->orderBy('column');
}

[评论后编辑]

<?php
class User
{
    public function comments()
    {
        return $this->hasMany('Comment');
    }
}

class Controller
{
    public function index()
    {
        $column = Input::get('orderBy', 'defaultColumn');
        $comments = User::find(1)->comments()->orderBy($column)->get();

        // use $comments in the template
    }
}

默认用户模型+简单控制器示例;获取评论列表时,只需根据 Input::get() 应用 orderBy().(一定要进行一些输入检查;))

default User model + simple Controller example; when getting the list of comments, just apply the orderBy() based on Input::get(). (be sure to do some input-checking ;) )