Delete a db entry after a certain amount of time.

Hello,
I was wondering if you could tell me if this is possible? Can PHP delete an item that is in a db after 7 days or 168 hours?

I am going to be inserting items into a database through a form, and was wanting an item to be deleted after 168 hours. Therefore I can't go and manually adjust my time each time sometime is inserted into a database. Can you let me know where I should start?

I am off to look at google, but I wanted to start here.

Using a Cron Job, you can run a script which deletes the record.

If you're not familiar with cron, run a single query every time a page is loaded (or form submitted).


DELETE FROM table WHERE DATEDIFF(NOW(), created_date) > 7