Re: [GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-04 Thread Dan Wilson
> Jason wrote: > > > > aolserver is a web/application server. PHP is a server-side scripting > > language. Why exactly *should* it have a job scheduler? > > > > Some (such as myself) might also ask why should a web server have a job > > scheduler, but that's a thread for a different list :) > >

Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Jason
On Mon, Nov 27, 2000 at 02:56:59PM -0700, Roberto Mello wrote: > > PHP does not have a scheduling facility? AOLserver (the web/application > server that powers AOL) has had such facility (and many many others for > db-backed websites) since 1995. ns_schedule_proc. > http://www.aolserv

Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-03 Thread clayton cottingham
Roberto Mello wrote: > > Jason wrote: > > > > aolserver is a web/application server. PHP is a server-side scripting > > language. Why exactly *should* it have a job scheduler? > > > > Some (such as myself) might also ask why should a web server have a job > > scheduler, but that's a thread for

RE: [SQL] a script that queries database periodically

2000-11-30 Thread Wojciech Milek
Hi! You can compile PHP without HTTP server support then you get php exec 'shell' and: #!/usr/local/bin/php > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Bernie Huang > Sent: Monday, November 27, 2000 8:23 PM > To: PHP_DB; PHP_General; PGSQL-S

Re: [PHP] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-11-27 Thread Joe Stump
> Because PHP is supposed to solve web development problems. And this is > one of them. It's very useful. Why solve one that is already solved? PHP isn't here to reinvent the wheel - get crontab and quit crying. --Joe > > -Roberto > -- > Computer Science Uta

Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-11-27 Thread Roberto Mello
Jason wrote: > > aolserver is a web/application server. PHP is a server-side scripting > language. Why exactly *should* it have a job scheduler? > > Some (such as myself) might also ask why should a web server have a job > scheduler, but that's a thread for a different list :) Because

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Mathijs Brands
On Mon, Nov 27, 2000 at 10:44:39PM +0100, Poul L. Christiansen allegedly wrote: > I have a bash script in crontab with the following line: > "lynx -dump > http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html" > > You can also just put that line directly into crontab. > > Poul L.

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Roberto Mello
"Poul L. Christiansen" wrote: > > I was thinking of writing up a PHP script and put into crontab, which is > > somehow easier than a shell script, but PHP is an apache module, so I > > cannot execute PHP under crontab (it has to be executed in a browser > > right?). I guess a shell script is nec

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Poul L. Christiansen
I have a bash script in crontab with the following line: "lynx -dump http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html" You can also just put that line directly into crontab. Poul L. Christiansen Bernie Huang wrote: > Hello, > > My boss wants me to write a script that will

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Serge Canizares
Why not use perl with DBI? If you know php, perl is just as easy. Bernie Huang wrote: > I was thinking of writing up a PHP script and put into crontab, which is > somehow easier than a shell script, but PHP is an apache module, so I > cannot execute PHP under crontab (it has to be executed in

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Mathijs Brands
On Mon, Nov 27, 2000 at 11:22:45AM -0800, Bernie Huang allegedly wrote: > Hello, > > My boss wants me to write a script that will send a email report to him > monthly with the result of database queries. > > For example, an email would be like: > > Monthly report > +--+-+---

Re: [SQL] a script that queries database periodically

2000-11-27 Thread Brett W. McCoy
On Mon, 27 Nov 2000, Bernie Huang wrote: > I was thinking of writing up a PHP script and put into crontab, which is > somehow easier than a shell script, but PHP is an apache module, so I > cannot execute PHP under crontab (it has to be executed in a browser > right?). I guess a shell script is