How can PHP and MySQL be used to ensure that past dates are not continuously prompted for marking usage if a space was not utilized?

To ensure that past dates are not continuously prompted for marking usage if a space was not utilized, we can use PHP and MySQL to store the last marked date and compare it with the current date before prompting for marking usage again. 

<?php
// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Get last marked date from database
$sql = "SELECT last_marked_date FROM usage_tracking ORDER BY id DESC LIMIT 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $last_marked_date = $row["last_marked_date"];

    // Compare last marked date with current date
    $current_date = date("Y-m-d");
    if ($last_marked_date != $current_date) {
        // Prompt for marking usage
        echo "Mark usage for today.";
        
        // Update last marked date in database
        $sql = "INSERT INTO usage_tracking (last_marked_date) VALUES ('$current_date')";
        $conn->query($sql);
    } else {
        echo "Usage already marked for today.";
    }
} else {
    // Prompt for marking usage if no previous record found
    echo "Mark usage for today.";
    
    // Insert current date as last marked date in database
    $current_date = date("Y-m-d");
    $sql = "INSERT INTO usage_tracking (last_marked_date) VALUES ('$current_date')";
    $conn->query($sql);
}

$conn->close();
?>

Keywords

PHP MySQL date comparison conditional logic data validation

Related Questions