In this tutorial, we will see how to get the last 15 days records in MySQL PHP. In PHP, you can use INTERVAL to get the last 15 days record from the database table. For MySQL query, we use the INTERVAL operator. It is mainly used to calculate the date and time values.
So, let's see SQL query to get last 15 days records, get 15 days data in laravel 6/7/8, how to get last 15 days data in PHP from MySQL Database.
Using SQL query to get data for the current month in MySQL.
id | order_date | amount | Orders
---+------------+--------+-------
1 | 2022-02-01 | 150 | 2
2 | 2022-02-02 | 200 | 4
3 | 2022-03-03 | 100 | 1
4 | 2022-03-04 | 300 | 5
5 | 2022-04-05 | 200 | 3
7 | 2022-04-06 | 190 | 7
In your table, the record needs to be like date and month.
select * from users
where order_date > now() - INTERVAL 15 day;
In the above query, we use the now() function to get the current date, and the INTERVAL() function to get the last 15 days records.
Using the below MySQL query you can get the new users in the last 15 days.
select * from users where created_at > now() - INTERVAL 15 day;
You might also like :
This article will show us how to validate upload file type using javascript. Using this post we can easily check the sel...
Aug-03-2020
In this article, we'll learn how to resolve the "419 page expired" error in Laravel. You might have encoun...
Jun-28-2020
Ever wondered how to access request headers in your Laravel 10 application? Join me as I guide you through a quick and s...
Dec-11-2023
In this article, we will see how to add toastr notification in laravel 10. Here, we will learn about toastr notification...
Mar-06-2023