Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-sql by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group