What resources or documentation can be helpful for handling time-based deletion of entries in PHP?

When handling time-based deletion of entries in PHP, it is important to use a cron job or scheduled task to regularly check and delete entries based on a specific time threshold. This can help keep your database clean and optimize performance by removing outdated data. 

// Example code for time-based deletion of entries in PHP using a cron job

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

// Define the time threshold for deletion (e.g., entries older than 30 days)
$time_threshold = strtotime('-30 days');

// Query to delete entries older than the time threshold
$sql = "DELETE FROM your_table WHERE entry_date < $time_threshold";

if ($conn->query($sql) === TRUE) {
    echo "Entries older than 30 days have been deleted successfully.";
} else {
    echo "Error deleting entries: " . $conn->error;
}

$conn->close();

Keywords

PHP time-based deletion cron job MySQL documentation

Related Questions