What are some best practices for managing and deleting old entries from a database in PHP?

When managing and deleting old entries from a database in PHP, it is important to regularly review and clean up outdated data to improve performance and maintain data integrity. One approach is to schedule automated scripts to run at regular intervals to identify and delete old entries based on a specific criteria, such as a timestamp or expiration date. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Define the criteria for deleting old entries
$delete_date = date('Y-m-d', strtotime('-30 days'));

// Delete old entries from the database
$sql = "DELETE FROM table_name WHERE created_at < '$delete_date'";
if ($conn->query($sql) === TRUE) {
    echo "Old entries deleted successfully";
} else {
    echo "Error deleting old entries: " . $conn->error;
}

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

Keywords

SQL queries database maintenance data retention policies cron jobs automated cleanup operations

Related Questions