Re: a script that queries database periodically
| From: | Jason | Date: | Mon, 27 Nov 2000 19:54:38 +0000 |
| Subject: | Re: a script that queries database periodically | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-27440@lists.php.net to get a copy of this message | ||
> 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.