From: | Folke Ashberg <folke(at)fanstage(dot)de> |
---|---|
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:38:40 |
Message-ID: | Pine.LNX.4.30.0011272035540.15225-100000@aldi.fanstage.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hi!
I think you have installed GET , so use in your cronab
GET http://localhost/report_for_my_boss/create.php |mail -s "Hello Boss"
boss(at)chief(dot)net
if you miss get try it with lynx:
lynx -source -dump http://localhost/.. |mail ....
regards
Folke
--
Folke Ashberg
Stage Internet Services GmbH
Technical Development
folke(at)fanstage(dot)de
folke(at)fanstage(dot)de | Tel: +49 89 454591-77 | Fax: +49 89 454591-71
Kreillerstr. 21 | 81673 Munich | Germany | www.fanstage.de
On Mon, 27 Nov 2000, Bernie Huang wrote:
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2000-11-27 19:44:25 | Re: [SQL] a script that queries database periodically |
Previous Message | Bernie Huang | 2000-11-27 19:22:45 | a script that queries database periodically |
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2000-11-27 19:44:25 | Re: [SQL] a script that queries database periodically |
Previous Message | Mathijs Brands | 2000-11-27 19:34:13 | Re: removing a DB?? |