In this tutorial, we will see how to get current month records in MySQL. For data analysis and reporting, we need more data or records. So, we will learn how to get current month data in MySQL PHP.
For getting data for the current month in MySQL we use the month() function. MySQL month() returns the month number for a given date. The return value is from 1 to 12.
So, let's see SQL query to get current month data, get current month data in laravel 6/7/8, how to get current month 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 MONTH(order_date) = MONTH(now())
and YEAR(order_date) = YEAR(now());
In the above query, we use the now() function to get the current date, and the month() function to get the current month number of date values.
Using the below MySQL query you can get the new users in the current month with date and count.
select date(created_at), count(*) from users
where MONTH(created_at) = MONTH(now())
and YEAR(created_at) = YEAR(now())
group by date(created_at);
You might also like :
In this article, we will see how to validate international phone numbers using jquery. Here, we will learn about mo...
May-12-2023
React is a really cool tool that helps programmers make awesome user interfaces using JavaScript. When it com...
Jul-26-2023
In this article, we will see the google line chart example in laravel 8. Google charts use to visualize d...
Feb-24-2021
In this article, we will see how to create a dynamic XML sitemap in laravel 9. As we know sitemap is a very im...
Jun-08-2022