Laravel orderBy on a relationship

by

It is possible to extend the relation with query functions:

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

[edit after comment]

<?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
    }
}

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 😉 )

More Related Contents:

  1. Laravel Eloquent – Attach vs Sync
  2. Laravel requires the Mcrypt PHP extension
  3. Laravel view not found exception
  4. Download files in laravel using Response::download
  5. How to create multilingual translated routes in Laravel
  6. How to use SHA1 encryption instead of BCrypt in Laravel 4?
  7. Access query string values from Laravel
  8. Laravel pagination pretty URL
  9. Laravel Mail::send() sending to multiple to or bcc addresses
  10. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  11. How do I redirect after download in Laravel?
  12. Could not open input file: artisan
  13. How Follow the Don’t Repeat Yourself Principle When Consuming My Own Laravel API?
  14. How to set a default attribute value for a Laravel / Eloquent model?
  15. laravel TokenMismatchException in ajax request
  16. Laravel Escaping All HTML in Blade Template
  17. Laravel: Validation unique on update
  18. How to create a subquery using Laravel Eloquent?
  19. Eloquent model mass update
  20. Laravel Eloquent get results grouped by days
  21. Change name of Laravel’s created_at and updated_at
  22. How to send data using redirect with Laravel
  23. Find or Create with Eloquent
  24. Unresolvable dependency resolving [Parameter #0 [ $name ]]
  25. Laravel Auth:attempt() will not persist login
  26. Can one modify the templates created by artisan migrate command?
  27. Laravel Form methods VS traditional coding
  28. How to create a database-driven multi-level navigation menu using Laravel
  29. Avoid public folder of laravel and open directly the root in web server
  30. Symfony\Component\HttpKernel\Exception\NotFoundHttpException Laravel

Leave a Comment