How To Get Last 30 Days Record In Laravel 8

Websolutionstuff | Feb-02-2022 | Categories : Laravel PHP MySQL

in this tutorial, we see how to get last 30 days record in laravel 8. You can simply get the last 30 days record using laravel 8 eloquent model. In PHP, you can use INTERVAL to get the last 30 days record from the database. Also, we can see how to get the last 1 month's data records in laravel 6/7/8 using Carbon functions.

For MySQL query, we use the INTERVAL operator. It is mainly used to calculate the date and time values. 

So, let's see get last 30 days records in laravel 6, laravel 7 and laravel 8. how to get last 30 days record in PHP, how to get last 30 days record in MySQL.

MySQL Example :

SQL query to get records from the last 30 days in MySQL.

select * from users where created_at > now() - INTERVAL 30 day;

You can also use the current_date instead of now() function

select * from users where created_at > current_date - interval 30 day;

 

 

Laravel Example :

 In laravel, we are using the carbon subdays function to get the last 30 days records.

$date = \Carbon\Carbon::today()->subDays(30);
$users = User::where('created_at','>=',$date)->get();

 


You might also like :

Recommended Post
Featured Post
How To Create Middleware For XSS Protection In Laravel 8
How To Create Middleware For X...

In this tutorial we will see how to create middleware for xss protection in laravel 8. Cross-site scripting is...

Read More

Dec-22-2021

What Is New In Laravel 9 - Features Of Laravel 9
What Is New In Laravel 9 - Fea...

In this article, we will see what is new in laravel 9 and the features of laravel 9. Laravel 9 is recently released...

Read More

Feb-13-2022

Laravel 6/7 CRUD tutorial with example
Laravel 6/7 CRUD tutorial with...

In this example, I will show you how to make simple laravel CRUD(insert, update, delete, or list) operations with e...

Read More

May-08-2020

How To Image Upload With Preview In Angular 15
How To Image Upload With Previ...

In today's world of web development, being able to upload images with a preview feature is a common requirement for...

Read More

Jun-16-2023