How can PHP scripts efficiently query and retrieve data from a MySQL database based on date ranges, such as the last 12 months?

To efficiently query and retrieve data from a MySQL database based on date ranges, such as the last 12 months, you can utilize SQL's DATE_SUB function to calculate the date range dynamically. By using this function in your SQL query, you can retrieve data within the specified date range without having to manually calculate the start and end dates in your PHP script. 

<?php
// Establish a connection to the MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Calculate the start date for the last 12 months
$start_date = date('Y-m-d', strtotime('-12 months'));

// Construct the SQL query to retrieve data within the last 12 months
$query = "SELECT * FROM your_table WHERE date_column >= '$start_date'";

// Execute the query and fetch the results
$result = mysqli_query($connection, $query);

// Process the fetched data
while ($row = mysqli_fetch_assoc($result)) {
    // Process each row of data as needed
}

// Close the database connection
mysqli_close($connection);
?>

Keywords

PHP MySQL query date range retrieval

Related Questions