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
Laravel 8 Eloquent orWhereHas Condition
Laravel 8 Eloquent orWhereHas...

In this example we will see laravel 8 eloquent orWhereHas() condition. In previous example we will learn about ...

Read More

Oct-15-2021

Node.js Express CRUD Example with MySQL
Node.js Express CRUD Example w...

Hello Guys, In this tutorial we will see how to perform Node js Express CRUD example with mysql. Node js Express ...

Read More

Aug-02-2021

Laravel 9 Autocomplete Search from Database
Laravel 9 Autocomplete Search...

In this article, we will see laravel 9 autocomplete search from the database. Using ajax autocomplete textbox in la...

Read More

Mar-14-2022

How To Setup And Configuration Angular 15
How To Setup And Configuration...

Setting up and configuring Angular 15, the latest version of the popular JavaScript framework, is a crucial step in star...

Read More

Jun-07-2023