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