How to Get Next Month Date Data in PHP MySQL?

Feb 19, 2022 . Admin

Hello Friends,

I am going to explain you example of how to get next month date data in PHP?. You will learn PHP query to get next months data. I would like PHP select date next of month. This article will give you simple example of PHP query to get next months record.

We will use get search how to select next months data from table using PHP. You can understand a concept of search how to take next month date data from the month in PHP. So, we can illustrate the getting a data next months in the PHP.

You can see both example of how do I get next months date in PHP.

Table: users


So, let's see bellow solution:

index.php
<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_php";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT 
            * 
        FROM `users` 
        WHERE DATE(expired_at) >= DATE_ADD(LAST_DAY(NOW()),INTERVAL 1 DAY)
           AND DATE(expired_at) <= DATE(LAST_DAY(NOW() + INTERVAL 1 MONTH))";

$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    echo '<pre>';
    print_r($row);
}

?>
Output:
Array
(
    [id] => 1
    [name] => nikhil thumar
    [email] => nik123@gmail.com
    [created_at] => 2021-01-08 09:28:17
    [updated_at] => 2020-02-01 09:28:17
    [expired_at] => 2022-03-17 09:28:17
)
It will help you...
#PHP