Laravel Model Eager loading and ordering

Question

I'm new to Laravel and thought it be cool to purchase the Codehappy ebook by Dayle Rees.

I just finished the blog tutorial and thought a bit on how he retrieved the posts from the Post model. Coming from a .net (ASP.NET MVC) background I think it will be important to order the posts while eager loading the author.

He eager loads the model like this.

$posts = Post::with('author')->get();

My question is where can you use the "order_by" clause? the order_by itself works when I use:

$posts = Post::order_by('id', 'desc')->get();

Regards RaVen

Laravel on Stackexchange area51.stackexchange.com/proposals/46607/… — Brian Dillingham
– Brian Dillingham, Commented Apr 8, 2013 at 21:53

RaVen · Accepted Answer · 2012-06-13 12:35:58Z

8

I manage to solve it by:

$posts = Post::with('author')->order_by('id', 'desc')->get();

answered Jun 13, 2012 at 12:35

RaVen

7732 gold badges9 silver badges21 bronze badges

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

2 Comments

Joel Larson Over a year ago

Indeed this is the correct answer. Eloquent extends the Fluent query builder so it inherits functions like where() and order_by(). Eloquent introduces the "eager loading" feature, but is required to be the first part of the method chaining (ie the static method called first)

Brian Dillingham Over a year ago

Laravel on Stackexchange area51.stackexchange.com/proposals/46607/…

Collectives™ on Stack Overflow

Laravel Model Eager loading and ordering

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related