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
Laravel 8 cURL HTTP Request Example
Laravel 8 cURL HTTP Request Ex...

Hello Friends, Today we will see how to make cURL HTTPs request in your laravel 8 application. This tu...

Read More

Apr-28-2021

Stripe Payment Gateway Integration Example In Laravel 8
Stripe Payment Gateway Integra...

In this article, we will see a stripe payment gateway integration example in laravel 8. The stripe payment gateway...

Read More

Nov-26-2020

How To Fix MySQL Shutdown Unexpectedly In XAMPP
How To Fix MySQL Shutdown Unex...

In this article, we will see how to fix "Error: MySQL shutdown unexpectedly" in XAMPP. When I open XAMPP...

Read More

Sep-22-2022

How To Install React In Laravel 9
How To Install React In Larave...

In this article, we will see how to install React in laravel 9. We will also install react with laravel 9 and...

Read More

Aug-15-2022