Geek asks and answers

PHP program and mySQL Task Scheduler and database theory?

I need to develop a website that runs tasks at a specific time (every 15 minutes). I will use cron to launch a webpage.

What is the best way to store job information? Some jobs will be daily, others every 8 hours, etc. To complicate the situation, I also need to consider the difference in time zones. This should not be too complicated, since PHP has many time zone functions, but how to integrate it into the programming of the next task to run?

Another question: how will the user enter information to run tasks? One option, similar to http://www.webcron.org , should ask the user to choose how often tasks should be performed, but how can I store this information in a database?

Any help would be greatly appreciated!

+3
source share
2 answers

I would use the crontab syntax, save it to the database, and run a separate crontab, causing the script to execute every minute.

There are GPL classes that already do this for you, for example: http://www.phpclasses.org/package/4140-PHP-Database-driven-PHP-job-scheduler-like-cron.html

0
source

MySQL, , , .

0

More articles:


All Articles