From: | "Wojciech Milek" <wojciech(dot)milek(at)demo(dot)pl> |
---|---|
To: | "Bernie Huang" <bernie(dot)huang(at)ec(dot)gc(dot)ca>, "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: [SQL] a script that queries database periodically |
Date: | 2000-11-30 18:16:02 |
Message-ID: | NEBBJLOFMMBLBDLIIGHHKEPGCCAA.wojciech.milek@demo.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hi!
You can compile PHP without HTTP server support then you get php exec
'shell'
and:
#!/usr/local/bin/php
<?
echo "hello!";
?>
> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2000-11-30 18:31:27 | Re: Can PostGreSQL handle 100 user database? |
Previous Message | Tom Lane | 2000-11-30 18:06:10 | Re: Unanswered questions about Postgre |
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2000-11-30 18:31:27 | Re: Can PostGreSQL handle 100 user database? |
Previous Message | The Hermit Hacker | 2000-11-30 17:48:43 | Re: Can PostGreSQL handle 100 user database? |