How can PHP be used to automatically delete data based on specific criteria, such as date comparisons?

To automatically delete data based on specific criteria such as date comparisons in PHP, you can use SQL queries with a WHERE clause to filter out the records that meet the criteria. You can then execute the DELETE query to remove the selected records from the database. 

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

// Define the criteria for deletion (e.g., delete records older than a specific date)
$delete_date = "2022-01-01";

// Construct and execute the SQL query to delete records based on the criteria
$sql = "DELETE FROM table_name WHERE date_column < '$delete_date'";
if ($conn->query($sql) === TRUE) {
    echo "Records deleted successfully";
} else {
    echo "Error deleting records: " . $conn->error;
}

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

Keywords

PHP automatic deletion data date comparisons criteria

Related Questions