Hello Friends,

I am going to explain you example of how to get last 7 days data in PHP?. You will learn get last 7 days data PHP. I would like to how to get last 7 days data PHP query.

This article will give you simple example of how to get last 7 days record in PHP. We will use how to get last 7 days data from a table in PHP.

We will use PHP query to get 7 days data records.

So, let's see bellow solution:

<?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(created_at) >= (DATE(NOW()) - INTERVAL 7 DAY);

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

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

?>

Array
(
    [id] => 2
    [name] => Aatman Infotech
    [email] => aatmaninfotech@gmail.com
    [created_at] => 2022-02-09 13:33:52.000000
    [updated_at] => 2020-09-30 13:33:52.000000
)
Array
(
    [id] => 3
    [name] => Haresh
    [email] => savanihd2@gmail.com
    [created_at] => 2022-02-10 06:46:08.000000
    [updated_at] => 2020-09-18 12:04:09.000000
)