如何在特定时间后停用或删除数据库中的项目？ [关闭]

Question

I have a project that requires me to develop a website say like ebay or craigslist where users will be uploading ads and items for sale or maybe advertisement purposes. I want the users to have an option of duration that how long they would want their items to remain on the website. Let say the options are 7 days, 15 days and 30 days, if a user selects 15 days for his/her item to remain on the website, I want a simple and reliable solution that automatically deactivates or removes this specific item from the database after 15 days at exactly the same time of upload. (Must be accurate up to minutes and even seconds). Since I love php so much, I would also love if the answer is simply possible in php. Anyway, if there is another solution more reliable let me know it. I have been considering setting a $_SESSION[] and then destroying it after the time limit but I have this feeling that it may not be the best approach available. Whatever,,,,, Please help me out, Please explain. Thank you in advance.

Answer 1

This may help you.

DELETE FROM table WHERE delete_date >= (CURDATE() - INTERVAL 7 DAY);