How To Get Last 7 Days Record In Laravel 8

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

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

So, let’s see get the last 7 days data in laravel 6, laravel 7 and laravel 8. how to get last 7 days record in PHP, how to get last 7 days record in MySQL.

MySQL Example :

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

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

Read More : How To Get Last Record In Laravel 8

Laravel Example :

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

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

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Websolutionstuff

Websolutionstuff

96 Followers

I am Laravel and PHP Developer. I have also Good Knowledge of JavaScript, jQuery, Bootstrap and REST API.