CRON job for codeigniter

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

---

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.

---

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.

---

If you are looking on how to create cron job, then have a look at this:

http://www.unixgeeks.org/security/newbie/unix/cron-1.html

But if you mean how to put expired users into another table, then you should show your table structure.

---

My hosting site is godaddy which give the option to create a cron. All we need to do is write a plainphp page to do the job, with sql connection and all stuff and just upload to the godaddy server and create the cron. Thats it. Job is easier.