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 a Livewire Image Upload in Laravel 10?
How to Create a Livewire Image...

Livewire has revolutionized the way developers build interactive web applications with its real-time capabilities. And w...

Read More

Aug-02-2023

Change Text Color Based On Background Color Using Javascript
Change Text Color Based On Bac...

In this article, we will see a change text color based on background color using javascript. Sometimes we have requ...

Read More

Dec-25-2020

Carbon Add Hours To Date In Laravel 9
Carbon Add Hours To Date In La...

In this article, we will see carbon add hours to date in laravel 9. Carbon provides addHour and addHours() function...

Read More

Nov-22-2022

How To Use OpenAI In Laravel 8/9
How To Use OpenAI In Laravel 8...

In this article, we will explore the integration of OpenAI into Laravel versions 8, 9, and 10. Our focus will be on unde...

Read More

Feb-06-2023