How can PHP be used to set MySQL database records to 0 at midnight?

To set MySQL database records to 0 at midnight using PHP, you can create a PHP script that runs as a cron job on your server. The script should connect to the MySQL database, update the records to 0, and then close the connection. By scheduling this script to run at midnight using a cron job, you can automate the process of resetting the records daily. 

<?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);
}

// Update records to 0
$sql = "UPDATE table_name SET column_name = 0";
if ($conn->query($sql) === TRUE) {
    echo "Records updated successfully";
} else {
    echo "Error updating records: " . $conn->error;
}

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

Keywords

PHP MySQL database records set midnight

Related Questions