How to sort Laravel Eloquent ORM objects?

Question

For example, we have a model flight having 3 fields:

created_at: the time when the flight created
name: the name of the flight
score: the score of the flight

So I write that:

$flights = App\Flight::orderBy('created_at');

I get some $flight objects ordered by create_time. So I will change the name of flight by create_time to first_flight, second_flight and so on...

But I want to display $flights sorted by score. So I have to sort $flights by score, but I have no idea how to achieve that.

So my question is, how to sort Eloquent ORM objects by a field(in my example, it's score)?

@theomessin Then I will have $flights1 = App\Flight::orderBy('created_at');, $flights2 = App\Flight::orderBy('score');. I just want to have one $flights and sort in place... — Sayalic
– Sayalic, Commented Sep 9, 2016 at 4:11

Alexey Mezenin · Accepted Answer · 2016-09-09 04:15:54Z

2

Just get a collection:

$flights = App\Flight::all();

And then sort it with sortBy() or sortByDesc() without hitting DB:

$filghts->sortBy('created_at');
....
$filghts->sortBy('score');

answered Sep 9, 2016 at 4:15

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hamelraj · Accepted Answer · 2016-09-09 04:18:42Z

0

If you want order by multiple column in same time use this

App\Flight::orderBy('created_at', 'DESC')
    ->orderBy('score', 'ASC')
    ->get();

answered Sep 9, 2016 at 4:18

Hamelraj

4,8464 gold badges21 silver badges42 bronze badges

Collectives™ on Stack Overflow

How to sort Laravel Eloquent ORM objects?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related