php - How to delete mysql row after time passes?

Question

I have no idea where to start with this one:

I have a database that stores postID and Date.

What I want to do is have my website auto delete all rows where Date is less than today. This script can't have any user input at all. No button clicks, nothing. The script must run every day at midnight.

I've been looking all over the place for something that does this and I've found absolutely nothing.

Answer 1

You can use PHP script and use cron job on your cpanel.

Example:

cronjobcommand.php

<?php 
 include 'your_db_connection';
 mysql_query("DELETE FROM your_table_name WHERE Date < NOW()");
?>

I have attached a screenshot below for your more reference.