Follow Us: Facebook Instagram
Download Source Code My YouTube Channel

How to get last / latest record of database in Laravel?

By Ved Prakash N | Apr 26, 2023 | Laravel
Share :

https://www.fundaofwebit.com/post/how-to-get-latest-record-by-id-in-laravel

How to get last record of database table in Laravel?


Hi guys, 

In this post, we will be learning about how to get the LAST or LATEST record from database in laravel.

So, there are many ways to get the Latest / LAST record in Laravel 10 / 9 / 8.

We are normally used latest() eloquent function to getting latest data with created_at default column. but if you need with another column like published_at or something else.

So guys, lets start to get last record in laravel.


Method 1: Using latest() belong to created_at field:

$product = Product::latest()->first();

Lets use the latest() function but with the custom optional database column name as follows:

$product = Product::latest('published_at')->first();


Method 2: Using orderBy() belong to id field:

$product = Product::orderBy('id', 'DESC')->first();


Method 3: using get() with latest(). It will get the last record

$product = Product::get()->latest();


Method 4: using get() with last(). It will get the last record

$product = Product::get()->last();


I hope, It will help you.

https://www.fundaofwebit.com/post/how-to-get-latest-record-by-id-in-laravel

Share this blog on social platforms

Latest Posts

> Laravel 11 Multi authentication using guard Tutorial | Admin & user auth system in laravel
> Laravel 11 CRUD Operation Example Tutorial
> How to install and setup spatie roles and permission in Laravel 11
> Laravel Policy using Spatie Roles & Permission Tutorial step by step
> Laravel 10 Authorization Policy Tutorial step by step | All about Laravel Policy
> Multi Guard Authentication with Breeze in Laravel 10
> Laravel 10 Spatie User Roles and Permissions Tutorial
> How to make pagination in Laravel 10
> How to Export data to Excel file with different format/extension in Laravel 10
> How to Import Excel file data into database in Laravel 10
> Laravel 10 Multiple Image Upload with Example
> OCR Integration in Laravel using LaraOCR Package with Tesseract
> Laravel 10 CRUD with File / Image Upload Tutorial with Example
> Laravel 10 - API Authentication using Laravel Sanctum
> Different Ways to store data in laravel 10
> Laravel Form Validation Tutorial with example | All about Validation in Laravel 10

Funda of Web IT

2018 - 2023 © Funda of Web IT. All rights reserved.

Funda Codester | About Us | Posts | Download Project Source Code

Stay Connected