Laravel 4: how to "order by" using Eloquent ORM

Question

Simple question - how do I order by 'id' descending in Laravel 4.

The relevant part of my controller looks like this:

$posts = $this->post->all()

As I understand you use this line:

->orderBy('id', 'DESC');

But how does that fit in with my above code?

Couldn't you do something like: $posts = $this->post->orderBy('id', 'DESC')->get(); — Matthew Camp, Jul 09 '13 at 16:20
Yep, sorry I was having trouble with the syntax. Thanks - If you post that as an answer I will happily selected it as the correct answer. — Josh, Jul 09 '13 at 16:23

Chris G · Accepted Answer · 2014-03-10T18:50:30.840

416

If you are using post as a model (without dependency injection), you can also do:

$posts = Post::orderBy('id', 'DESC')->get();

edited Mar 10 '14 at 18:50

answered Aug 17 '13 at 13:13

Chris G

3

This is the way to go when using version 4! – Ms01 Sep 21 '13 at 20:39
4

Still works in 5.1 – Geoherna Dec 07 '16 at 18:50
2

also working in 5.3 – Shoukat Mirza May 16 '17 at 18:19
4

Absolutely still working in 5.4 – ako Jun 11 '17 at 10:53
4

working fine in 5.5 also – Zulfiqar Tariq Sep 13 '17 at 12:36
1

works in 5.6 too – westcoast Apr 17 '18 at 21:23
25

i'll save the next guy from having to post in the future, works in 5.7 too – westcoast Apr 17 '18 at 21:24
3

valid in 2019 and in all versions. – r89human Jan 17 '19 at 23:06
1

lol @westcoast, working in 5.8. – Paul M May 08 '19 at 21:18
2

Working in 6.2 too – Private_GER Feb 24 '20 at 15:16
1

Does not work in laravel 7 – Erik Thiart Jul 13 '20 at 21:47
1

It does still work in Laravel 7 – Chris G Jul 14 '20 at 12:28
dafuq happen here – Persk Oct 25 '20 at 06:20
oh my goodness still working in laravel 8 in 2021 – yasir shah Feb 03 '21 at 08:33
1

also working in laravel 28.6 in 2036... I just arrived from future and saw this question... – Zeeshan Malik Feb 04 '21 at 15:09
Looks like it will work forever! – 0x0 Apr 19 '21 at 07:18

score 63 · Answer 2 · edited Apr 22 '15 at 07:23

63

If you are using the Eloquent ORM you should consider using scopes. This would keep your logic in the model where it belongs.

So, in the model you would have:

public function scopeIdDescending($query)
{
        return $query->orderBy('id','DESC');
}

And outside the model you would have:

$posts = Post::idDescending()->get();

edited Apr 22 '15 at 07:23

answered Dec 11 '13 at 12:45

where is the query being passed to `idDescending()` in the last line `$posts = Post::idDescending()->get();` – Alexander Solonik Feb 20 '15 at 13:59
3

Laravel parses that automatically. – Relaxing In Cyprus Feb 21 '15 at 22:18
1

I would go with this answer. Here's how I do it normally on my everyday work: Within the mode: ```public function scopeLatest($query) { return $query->orderBy('created_at')->get(); }``` And within the controller: ```return view('project.view')->with(['projects' => Project::latest()]);``` – Md Mazedul Islam Khan Feb 23 '16 at 09:59
I like this answer the best vs handling in-line, esp if you are handling multiple order conditions. Thanks! `_.orderBy(this.users, ['name', 'last_login'], ['asc', 'desc'])` – kaleazy Mar 22 '19 at 20:37

score 32 · Answer 3 · answered Jul 09 '13 at 16:24

32

This is how I would go about it.

$posts = $this->post->orderBy('id', 'DESC')->get();

answered Jul 09 '13 at 16:24

Matthew Camp

3 Answers3