Re: a script that queries database periodically

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема Re: a script that queries database periodically
Дата
Msg-id 3A22D8AB.47A873F2@cc.usu.edu
обсуждение исходный текст
Ответ на a script that queries database periodically  (Bernie Huang <bernie.huang@ec.gc.ca>)
Ответы Re: [PHP-DB] Re: a script that queries database periodically  (Jason <jason@jnj.org>)
Список pgsql-sql
"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 necessary.  So, is it possible to
> > call 'psql' and returning its query result and I can use sendmail to
> > email the result? Any other idea?

    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.aolserver.com

    -Roberto
--
Computer Science            Utah State University
Space Dynamics Laboratory        Web Developer
USU Free Software & GNU/Linux Club     http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Poul L. Christiansen"
Дата:
Сообщение: Re: a script that queries database periodically
Следующее
От: Mathijs Brands
Дата:
Сообщение: Re: a script that queries database periodically