a script that queries database periodically
a script that queries database periodically
Hello, My boss wants me to write a script that will send a email report to him monthly with the result of database queries. For example, an email would be like: Monthly report +----------+---------+---------------+ | Vehicles | Mileage | # of Signouts | +----------+---------+---------------+ | Vehicle1 | 10324 | 5 | +----------+---------+---------------+ | Vehicle2 | 19384 | 6 | +----------+---------+---------------+ ... 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? Thanks. - Bernie
RE: [SQL] a script that queries database periodically
От:
"Wojciech Milek" <wojciech.milek@demo.pl>
Дата:
Hi! You can compile PHP without HTTP server support then you get php exec 'shell' and: #!/usr/local/bin/php > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Bernie Huang > Sent: Monday, November 27, 2000 8:23 PM > To: PHP_DB; PHP_General; PGSQL-SQL; PGSQL-GENERAL > Subject: [SQL] a script that queries database periodically > > > Hello, > > My boss wants me to write a script that will send a email report to him > monthly with the result of database queries. > > For example, an email would be like: > > Monthly report > +----------+---------+---------------+ > | Vehicles | Mileage | # of Signouts | > +----------+---------+---------------+ > | Vehicle1 | 10324 | 5 | > +----------+---------+---------------+ > | Vehicle2 | 19384 | 6 | > +----------+---------+---------------+ > ... > > 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? > > Thanks. > > - Bernie >