[PHP] Automated Jobs

pnh73 · 11-06-2003, 03:42 PM

Hi,

I need them to automated PHP updates of a MySQL database. Is their any way other than cron jobs I can automate PHP jobs? I would need to run it everyday.

Also I was just wondering what is the likelihood of a Hosting company giving me access to cron jobs so that i can run my own cron jobs?

TIA

david_ross · 11-06-2003, 03:50 PM

I would just use cron to schedule them.

Some hosts do give you cron access - just ask about.

markus1982 · 11-06-2003, 03:54 PM

a cron job will not necessarly be enough. it would be best if there would be a commandline version of php installed that you could make use of ... otherwise there is hopefully lynx or similar installed...

froZenX · 11-06-2003, 08:14 PM

If you can... cron the PHP file that you want to run to be run'ed everyday.

If thats possible.... lol.

pnh73 · 11-07-2003, 11:29 AM

is there any other way to do it say if my client has a windows server?

david_ross · 11-07-2003, 12:30 PM

Use scheduled tasks instead of cron.

pnh73 · 11-07-2003, 01:25 PM

ok, cool so i just run get the scheduled task or cron job to run the following command:

php cronscript.php

david_ross · 11-07-2003, 01:28 PM

If php is installed on your windows systme if the windows systme is not the webserver you could use lynx to execute it remotely.

pnh73 · 11-07-2003, 01:35 PM

It is possible that my client could be hosting on Win 2003 or Redhat (i would prefer Redhat but in the end its not my call).

I wish to email users to tell them that their subscription to our service will expire in a month, week etc etc. This means that I would have to check the MySQL DB everyday for users that could be about to have their subscription expire and then send a reminder. Is cron/windows equivalent the only way?

david_ross · 11-07-2003, 01:43 PM

Well what you want is to run a qurey at specified times and to do that you need some sort of scheduling agent like cron or scheduled tasks.

pnh73 · 11-07-2003, 03:34 PM

looks like cron it will be