What is the correct syntax for deleting records in MySQL based on a time interval in PHP?

To delete records in MySQL based on a time interval in PHP, you can use a SQL query with the WHERE clause to specify the time range for deletion. You can use the DATE_SUB() function to subtract a specific time interval from the current date and time. This allows you to target records that fall within the desired time frame for deletion. 

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

// Define time interval for deletion (e.g. 30 days ago)
$timeInterval = date('Y-m-d H:i:s', strtotime('-30 days'));

// SQL query to delete records based on time interval
$sql = "DELETE FROM your_table_name WHERE date_column < '$timeInterval'";

if ($conn->query($sql) === TRUE) {
    echo "Records deleted successfully";
} else {
    echo "Error deleting records: " . $conn->error;
}

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

Keywords

PHP MySQL delete records time interval syntax

Related Questions