Laravel Eloquent: Ordering results of all()

laravel laravel-4 eloquent sql-order-by
MatterGoal picture MatterGoal · Jul 2, 2013 · Viewed 212.3k times · Source

I'm stuck on a simple task. I just need to order results coming from this call 

$results = Project::all();

Where Project is a model. I've tried this

$results = Project::all()->orderBy("name");

But it didn't work. Which is the better way to obtain all data from a table and get them ordered?

Answer

Travis B picture Travis B · Jul 2, 2013

You can actually do this within the query.

$results = Project::orderBy('name')->get();

This will return all results with the proper order.

Related questions

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

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 …

Read More
Eloquent Collection: Counting and Detect Empty

This may be a trivial question but I am wondering if Laravel recommends a certain way to check whether an Eloquent collection returned from $result = Model::where(...)->get() is empty, as well as counting the number of elements. …

Read More
Laravel Eloquent groupBy() AND also return count of each group

I have a table that contains, amongst other columns, a column of browser versions. And I simply want to know from the record-set, how many of each type of browser there are. So, I need to end up with something …

Read More