Reputation: 12674
I have an existing system to submit articles using PHP into a MySQL database. I would like to implement some sort of queue, so I was wondering if I could allow the submitter to select a date/time and then the Insert would perform at that time. Is this possible?
Upvotes: 1
Views: 1296
Reputation: 23186
A better way to accomplish this is not to time the insert, but to time the publishing of the article. Instead of inserting at a specified time:
Upvotes: 5
Reputation: 7155
You can setup a MySQL Event or, probably better solution, setup a cron job, if you're on Linux.
Alternatevely, you could try with phpJobScheduler.
Upvotes: 3
Reputation: 2710
You can create additional table in DB ex: article_to_publish with publish_date column and then run some publish action by cron.
If you need more fun you can look at http://celeryproject.org/
Upvotes: 1