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;

Comments

There are no comments.

Comment on this Article

Your email address will never be published. Comments are usually approved within an hour or two. (to prevent spam)