How can a PHP script be modified to ensure that a new row is inserted into the counter table each day and individual daily accesses are counted?

To ensure that a new row is inserted into the counter table each day and individual daily accesses are counted, you can modify the PHP script to check if a row for the current date already exists in the table. If it does not exist, insert a new row with a count of 1. If it does exist, update the count by incrementing it by 1. 

// Connect to the 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 the current date
$current_date = date("Y-m-d");

// Check if a row for the current date exists
$result = $conn->query("SELECT * FROM counter WHERE date = '$current_date'");
if ($result->num_rows > 0) {
    // Update the count by incrementing it by 1
    $conn->query("UPDATE counter SET count = count + 1 WHERE date = '$current_date'");
} else {
    // Insert a new row with a count of 1
    $conn->query("INSERT INTO counter (date, count) VALUES ('$current_date', 1)");
}

// Close the connection
$conn->close();

Keywords

PHP script new row counter table daily accesses insertion

Related Questions