Skip site navigation (1) Skip section navigation (2)

Re: [PHP] a script that queries database periodically

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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
>
>


In response to

pgsql-sql by date

Next:From: Brett W. McCoyDate: 2000-11-27 19:44:25
Subject: Re: [SQL] a script that queries database periodically
Previous:From: Mathijs BrandsDate: 2000-11-27 19:34:13
Subject: Re: removing a DB??

pgsql-general by date

Next:From: Brett W. McCoyDate: 2000-11-27 19:44:25
Subject: Re: [SQL] a script that queries database periodically
Previous:From: Bernie HuangDate: 2000-11-27 19:22:45
Subject: a script that queries database periodically

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group