Search by Queries/Bugs/Errors

OrderBy on Eloquent relationships method in Laravel

You can directly call the orderBy() method on eloquent relationships to get the data from related tables in specific order.

Answers 1

Use orderBy method with ASC on eloquent relationship in Laravel to display content in alphabetical ascending order (From A to Z)
```
//Define relationship method in user model - app\Models\User.php
public function postsByTitle(){
    return $this->hasMany('App\Models\Post')->orderBy('title', 'ASC');
}
```
0
Calling the relationship method
```
$data = App\Models\User::find(1)->postsByTitle()->get();
```
Additional Note

You can display data using foreach loop.
```
foreach($data as $val){
    echo $val->title. "<br/>";
}
```
You can specify orderBy() directly on your Eloquent relationships. It will return the data in a specific order while calling the relationship method using with() in Laravel. In our case, we get the data in alphabetical ascending order (From A to Z).

Back to code snippet queries related laravel

Log in to add code snippet

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress

Random Code Snippet Queries: Laravel

Hello, world! This is a toast message.