CRON job for codeigniter

Question

I am using codeigniter. I want to know how to set up a cron job to check a table for expiring users and insert data in to another table with the list of expiring users. How to do that.

When i tried to write a script with controller and model to insert the table:

Fatal error: Class 'Controller' not found in /home/content/html/test/live/application/controllers/cron.php on line 2

Answer 1

You can find some more information on making CodeIgniter CLI-accessible here: http://phpstarter.net/2008/12/run-codeigniter-from-the-command-line-ssh/

Next step is just using crontab -e to set up the cronjob.

Answer 2

This might not be what you're looking for, but it works just fine for me:

Create your CRON job logic as a 'normal' controller function.

Then, in your standard, non-CI, PHP cronjob file just load the URL via

file_get_contents('http:example.com/cronjob/');

This will treat the URL as being hit just as by any other user and the entire CI framework will be at your disposal.