Re: [PHP] a script that queries database periodically

From: Jason <jason(at)jnj(dot)org>
To: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
Cc: PHP_DB <php-db(at)lists(dot)php(dot)net>, PHP_General <php-general(at)lists(dot)php(dot)net>, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>, PGSQL-GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: [PHP] a script that queries database periodically
Date: 2000-11-27 19:54:38
Message-ID: 20001127135438.B27680@jnj.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

> 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?

if you know perl, you should check out DBI. Read all about it at
www.cpan.org. It's pretty similar to the php database interface.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Burne 2000-11-27 20:20:49 Access Permissions/Security
Previous Message Mathijs Brands 2000-11-27 19:44:44 Re: [SQL] a script that queries database periodically

Browse pgsql-sql by date

  From Date Subject
Next Message Nelio Alves Pereira Filho 2000-11-27 20:01:16 Help with Procedures in pgsql
Previous Message Mathijs Brands 2000-11-27 19:44:44 Re: [SQL] a script that queries database periodically