I'm creating a CMS where I want a user to be able to define a date for a post they're making to be auto-archived (so essentially copied via PHP/SQL from one table to another... active to archive, and delete the original - or justadding an 'active' field Y/N).
My first thought was just to have a PHP script at the top of the landing page which checks all of the 'expirey dates' in the table againsts todays date and then updates them accordingly. But then that obvioulsy will only work if the user opens their CMS and hence runs the script... which isn't very good if they don't open it that often.
I then found Cron Jobs which seem the way to go. Does anyone have any experience with these, and is using a free service as opposed to writing the cron job from scratch myself necessarily a bad thing? I'd just need it to excecute my PHP once at midnight, every day.
Any advice would be much appreciated - I think I could learn how to code a Cron Job but if there free services are OK then maybe that would be best for such a simple task?