Linux crontab timed task invoke CI framework PHP code

Purpose: A website may need to perform several scheduled tasks, such as cleaning up the cache every hour, generating a sitemap Once a day, and backing up the database once a week ... If all is written in crontab, it may not be easy to manage and user configuration, use this class to easily add scheduled tasks, view the log of the execution Plan task, and manage the execution time of each scheduled task in the background. Installation: 1 database Add Table:

2. CREATE TABLE ' Cron_schedule ' (
4. ' schedule_id ' int (ten) unsigned not NULL auto_increment,
6. ' Job_code ' varchar (255) Not NULL default ' 0 ',
8. ' Status ' enum (' Pending ', ' running ', ' success ', ' missed ', ' error ') not NULL default ' pending ',
10. ' Messages ' text,
12. ' Created_at ' datetime not NULL default ' 0000-00-00 00:00:00 ',
14. ' Scheduled_at ' datetime not NULL default ' 0000-00-00 00:00:00 ',
16. ' Executed_at ' datetime not NULL default ' 0000-00-00 00:00:00 ',
18. ' Finished_at ' datetime not NULL default ' 0000-00-00 00:00:00 ',
20. PRIMARY KEY (' schedule_id '),
22. KEY ' Task_name ' (' Job_code '),
24. KEY ' Scheduled_at ' (' scheduled_at ', ' status ')
26. ) Engine=myisam DEFAULT Charset=utf8;

2/application/config/config.php Add:

2. /*
4. |--------------------------------------------------------------------------
6. | Cron Schedule Variables
8. |--------------------------------------------------------------------------
10. |
12. | ' Enable_cron ' = whether to turn on cron schedule
14. | ' Cron_schedule_table_name ' = table that holds cron schedule
16. | ' Cron_schedule_generate_every ' = time interval to generate cron schedule
18. | ' cron_schedule_ahead_for ' = cron Schedule each time it is produced
20. | ' Cron_schedule_lifetime ' = the expiration date of cron schedule
22. | ' Cron_history_cleanup_every ' = time interval to clear cron schedule
24. | ' Cron_history_success_lifetime ' = save time for running a successful cron schedule
26. | ' Cron_history_failure_lifetime ' = save time for cron schedule that failed to run
28. |
30. */
32. $config [' enable_cron '] = TRUE;
34. $config [' cron_schedule_table_name '] = ' cron_schedule ';
36. $config [' cron_schedule_generate_every '] = 15;
38. $config [' cron_schedule_ahead_for '] = 20;
40. $config [' cron_schedule_lifetime '] = 15;
42. $config [' cron_history_cleanup_every '] = 10;
44. $config [' cron_history_success_lifetime '] = 60;
46. $config [' cron_history_failure_lifetime '] = 600;

3/application/libraries/cron_schedule.php See annex 4 new/application/config/cron_schedules.php add Scheduled tasks to this file, such as:

2. <?php
6. $cron _schedule[' clear_log ') = Array (
8. ' Schedule ' = Array (
10. ' Config_path ' + ', '//cron expression is used to get an expression in the configuration file or database that is empty when directly specified
12. ' cron_expr ' = ' */5 * * * * '//directly specify cron expression to get an expression in the configuration file or database is empty
14. ),
16. ' Run ' = = Array (
18. ' FilePath ' = ' cron ',//directory where the file is located relative to AppPath
20. ' filename ' = ' myclass.php ',//filename
22. ' Class ' = ' MyClass ',//class name if only simple function can be empty
24. ' function ' = ' clear_log ',//functions to execute
26. ' params ' = = Array ()//parameters to be passed
28. )
30. );
34. $cron _schedule[' clear_log ') = ...
36. $cron _schedule[' create_sitemap ') = ...

5 adding the corresponding classes and functions/application/cron/myclass.php

1. <?php
3. Class MyClass
4. {
5. function Clear_log ($params = Array ())
6. {
7. Clean log
8. }
10. //.....
11. }

6 adding/application/controllers/cron.php

1. <?php
3. Class Cron extends Ci_controller
4. {
5. Public Function Index ()
6. {
7. $this->load->library (' cron_schedule ');
8. $this->cron_schedule->dispatch ();
9. }
10. }

7 Adding a system cron

1. #crontab-E
2. Add scheduled tasks as needed, such as:
3. */5 * * * * php/var/www/ci210/index.php cron Index
4. #service Cron Restart

Linux crontab timed task invoke CI framework PHP code