Reputation: 4967
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
Upvotes: 8
Views: 17190
Reputation: 3962
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.
Upvotes: 2
Reputation: 4967
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.
Upvotes: -2
Reputation: 91
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.
Upvotes: 4
Reputation: 382881
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.
Upvotes: 1