Laravel 8 Get Latest Record From Database

In this article, we will see laravel 8 get the latest records from the database. In PHP, you can use order by clause with descending order to get the last record from the database but in laravel, you can simply get the last record using the laravel 8 eloquent model. 

Laravel provides the latest() method to get the last record from the database. In the MySQL database get the last record using the ORDER BY clause with desc.

So, let's see how to get the last record in laravel 8 or laravel 8 to get the last record SQL query.

Get Last Record Using MySQL:

You can get the last records using the below code example.

SELECT column_name FROM table_name  
ORDER BY column_name DESC  
LIMIT 1;

Example:

select * from users ORDER BY id DESC LIMIT 1;

 

 

Get Latest Records Using Laravel:

Example 1:

$user = DB::table('users')
                ->latest()
                ->first();

Example 2 :

$user = User::orderBy('id', 'DESC')->first();

Example 3:

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

 


You might also like:

techsolutionstuff

Techsolutionstuff | The Complete Guide

I'm a software engineer and the founder of techsolutionstuff.com. Hailing from India, I craft articles, tutorials, tricks, and tips to aid developers. Explore Laravel, PHP, MySQL, jQuery, Bootstrap, Node.js, Vue.js, and AngularJS in our tech stack.

RECOMMENDED POSTS

FEATURE POSTS