In this article, we will see laravel 8 get the last 7 days records. In PHP, you can use INTERVAL to get the last 7 days record from the database. In laravel, you can get the last 7 days record using the eloquent model. Also, we can see how to get last week's records in laravel 6/7/8 using Carbon functions.

For MySQL queries, we are using INTERVAL operators. It is mainly used to calculate the date and time values. In laravel, we will use the carbon subdays() function to get the last 7 days records.

So, let's see how to get the last 7 days record in laravel 8 or get the last 7 days record in MySQL query.

In this example, we will see an SQL query to get records from the last 7 days in MySQL.

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

 

 

In laravel, we will use the carbon subdays() function to get the last 7 days records.

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

 

---

You might also like:

• Read Also: Laravel 8 Inner Join Query Example
• Read Also: Laravel 8 Multiple Database Connections
• Read Also: Laravel orderBy, groupBy and limit Example
• Read Also: Laravel 8 Many To Many Polymorphic Relationship