How To Get Last Record In Laravel 8

Websolutionstuff | Jan-26-2022 | Categories : Laravel PHP MySQL

In this example, we will see how to get the last record in laravel 8. You can simply get the last record using laravel 8 eloquent model. In PHP, you can use order by clause with descending order to get the last record from the database table.

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

So, let's see laravel 8 get last record, how to get latest record in laravel, how to get last record in mysql, get last updated record in laravel 8.

MySQL Syntax : 

You can see the MySQL syntax like below. 

SELECT column_name FROM table_name  
ORDER BY column_name DESC  
LIMIT 1;

Example :

select *from users ORDER BY id DESC LIMIT 1;

 

 

Laravel Syntax :

Example 1:

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

Example 2 :

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

 


You might also like :

Recommended Post
Featured Post
How To Hide Toolbar In Summernote Editor
How To Hide Toolbar In Summern...

In this small tutorial i will show you How To Hide Toolbar In Summernote Editor, many times customer's have req...

Read More

Sep-02-2020

How To Integrate Razorpay Payment Gateway In Laravel 9
How To Integrate Razorpay Paym...

In this article, we see how to integrate razorpay payment gateway in laravel 9. As you all know if you are developi...

Read More

Apr-11-2022

Pagination Example In Laravel
Pagination Example In Laravel

In this article, we will see a pagination example in laravel, as we all know pagination is a very common feature in all...

Read More

Sep-24-2020

Laravel 9 Datatables Filter with Dropdown
Laravel 9 Datatables Filter wi...

In this article, we will see laravel 9 datatables filter with dropdown. Here we will add datatables...

Read More

Mar-12-2022