Remove deleted rows from MySQLi database after 3 days using PHP
January 24, 2024
$query = "
DELETE FROM items
WHERE date_created_ts < ( CURDATE() - INTERVAL 3 DAY )
AND deleted = 'y'
";
$stmt = $mysqli -> prepare($query);
$stmt -> execute();
$affected_rows = $stmt -> affected_rows;
echo 'Deleted Rows: ' . $affected_rows;