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.
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;
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 :
In this tutorial we will learn php array functions with example. An array is a data structure that contains a group of e...
Apr-23-2021
Hey fellow developers! Today, let's tackle the installation of the PHP SOAP extension on our Ubuntu 23.04 systems. I...
Jan-31-2024
In this example, we will learn how to run a specific seeder in laravel 8. If you want to run only one seeder in laravel...
Jan-19-2022
In this article, we will see laravel 9 refresh datatable without reloading the page. When I have a data table that...
May-01-2022