run an hourly php script

[scialom]

Hi,

I have a php script that I need it to run every hour. How can I do it?

Assaf

[Tracer]

on a *nix system you could schedule a cron job....

I have never tried on a windows system but if you create a .bat file and setup the task scheduler to run the .bat file when you want I don't see why it wouldn't work.

[scialom]

I try it - but I cant run a php page.

Assaf

[Tracer]

well not in a browser.... what exactly are you trying to do?

You should be able to drop to a dos promp and execut a php script .....

php -options myfile.php

[scialom]

Hi,

I have a script that check the status of rows in the db and if it is 0 it generates e-mail and update the status to 1.

Assaf

[dinger]

Under windows just use the task scheduler exactly as you would a cron job under *NIX...

I dont see any reason why it wouldnt work.

Chris

[scialom]

The only problem is that I try to do it under linux

[dubhain]

You'll have to edit your crontab file. Check out these man pages to see what you are about to do and then follow the instructions.
man crontab
man 5 crontab

type 'crontab -e' in your terminal
this will open your crontab file in vi
add the following line
1 /file/to/run

[Sxooter]

OK, if you're root on a redhat box, you can just create a script and drop it into /etc/cron.hourly. They run in alphabetical order, by the way, so if you want it to run last just make it zzz_myscript and first, just make it aaa_myscript.

Now, you should have a program called wget installed, use it and you can even save the output. It's great for this kind of thing. the other option is to install the cgi-bin version of PHP and then copy the script from the web server to the /etc/cron.daily directory, and make the first like look like:

#!/usr/local/bin/php -q # or wherever your php bin is
<?php...