Laravel latest() and oldest() Eloquent Query Example

Laravel 6 , Laravel , Laravel 7

Nicesnippets

112104

16-01-2020


Hi Guys,

In this blog, I will show you how to get latest and oldest record into the database. The latest and oldest methods allow you to easily order results by table column.

By default, result will be ordered by the created_at column. You will pass the column name that you wish to sort by using orderBy method.

I will give you four example for latest() and oldest() method as bellow.

Users Table


Example 1 : latest() eloquent

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function getLatestRecord()

{

$latests = User::latest()->get();

dd($latests);

}

Output

array:4 [

0 => array:3 [

"name" => "keval"

"email" => "[email protected]"

"created_at" => "2019-12-26 00:00:00"

]

1 => array:3 [

"name" => "piyush"

"email" => "[email protected]"

"created_at" => "2019-12-25 00:00:00"

]

2 => array:3 [

"name" => "savan"

"email" => "[email protected]"

"created_at" => "2019-12-09 00:00:00"

]

3 => array:3 [

"name" => "mehul"

"email" => "[email protected]"

"created_at" => "2019-12-01 00:00:00"

]

]

Example 2 : OrderBy with latest eloquent

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function getLatestRecord()

{

$latests = \DB::table('users')->orderBy('created_at','desc')->get();

dd($latests);

}

Example 1 : oldest() eloquent

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function getOldestRecord()

{

$oldest = User::oldest()->get();

dd($oldest);

}

Output

array:4 [

0 => array:3 [

"name" => "mehul"

"email" => "[email protected]"

"created_at" => "2019-12-01 00:00:00"

]

1 => array:3 [

"name" => "savan"

"email" => "[email protected]"

"created_at" => "2019-12-09 00:00:00"

]

2 => array:3 [

"name" => "piyush"

"email" => "[email protected]"

"created_at" => "2019-12-25 00:00:00"

]

3 => array:3 [

"name" => "keval"

"email" => "[email protected]"

"created_at" => "2019-12-26 00:00:00"

]

]

Example 2 : OrderBy with oldest() eloquent

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function getOldestRecord()

{

$oldest = \DB::table('users')->orderBy('created_at','asc')->get();

dd($oldest);

}

It will help you...


Recommended Posts