What are the best practices for resetting a database in PHP at regular intervals, such as every 24 hours?

To reset a database in PHP at regular intervals, such as every 24 hours, you can create a cron job that runs a PHP script to perform the database reset. Within the PHP script, you can execute SQL queries to truncate tables or delete data as needed. By scheduling this cron job to run daily, you can ensure that your database is reset at the specified interval. 

<?php
// Connect to your 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);
}

// SQL query to reset the database tables
$sql = "TRUNCATE TABLE table1;
        TRUNCATE TABLE table2;
        TRUNCATE TABLE table3;";

if ($conn->multi_query($sql) === TRUE) {
    echo "Database reset successfully";
} else {
    echo "Error resetting database: " . $conn->error;
}

$conn->close();
?>

Keywords

cron job database reset PHP script scheduled task automation

Related Questions