using php and linux for a "crontab" like

[Anon]

Hi all

Well, i am trying to find ideas and code for write a module to manage automatic scheduled task using PHP and MYSQL.

My idea is to write the code to check for the appropiate information in the database MYSQL, but HOW TO RUN IT AUTOMATICALLY?

Idea 1: Put the code in the "homepage" of the site, and risking to overload my server each time a user requests the page.

Idea2: Create a crontab job in LINUX, using shell commands to run a LYNX client (text-based-browser) to run my PHP page.

Idea3: Write a PERL program that interacts with MYSQL.. But i dont have enough experience in PERL programming...

Any more ideas?

Thanks..

[Anon]

Compile PHP as a CGI module, by simply typing ./configure and then make and make install. Then just put the following line at the top of your code (very first line)

#!/usr/local/bin/php -q

this will execute the code with the php preprocessor (the -q tells it to be quiet, don't output headers).. then just put it in the cron tab. DONE!

Hope that helps,
Chris King

[Anon]

Thanks!

Thats is really a great idea. I am going to try it.
I think all the information I need, i will find it in php documentation...

Juan Torres