How can PHP be used to compare dates stored in a MySQL database?

When comparing dates stored in a MySQL database using PHP, you can use the strtotime() function to convert the dates into Unix timestamps for easy comparison. This allows you to easily compare dates in a standardized format and make logical comparisons between them. 

// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query to retrieve dates from database
$query = "SELECT date_column FROM table";
$result = mysqli_query($connection, $query);

// Fetch and compare dates
while($row = mysqli_fetch_assoc($result)) {
    $date = strtotime($row['date_column']);
    $current_date = strtotime(date("Y-m-d"));
    
    if($date < $current_date) {
        echo "Date is in the past";
    } else {
        echo "Date is in the future";
    }
}

// Close database connection
mysqli_close($connection);

Keywords

PHP MySQL date comparison strtotime date_format

Related Questions