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