pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JB <jbeebe@aimsmarketing.com>
To: PHP_DB <php-db@lists.php.net>
To: PHP_General <php-general@lists.php.net>
To: PGSQL-SQL <pgsql-sql@postgresql.org>
To: PGSQL-GENERAL <pgsql-general@postgresql.org>
Subject: Re: [PHP] RE: [SQL] a script that queries database periodically
Date: Thu, 30 Nov 2000 11:41:50 -0000
Message-ID: <00b301c05ac2$8a2f8820$47ee8acf@primenet.com> (raw)
References: <NEBBJLOFMMBLBDLIIGHHKEPGCCAA.wojciech.milek@demo.pl>

I'm sure the convience of having the reports emailed on a specific day is
what you're looking for. But why not just code your PHP to do your
mysql_query() and mail() and place it on a webserver. Obviously have a
simple hardcoded login so just not anyone can request the reports. That way
your boss can get the goods whenever, maybe he might need them mid-month or
something comes up. He'll be able to go to the URL, enter his name and pw
and hit submit and he has them.

Not like this answered your question, just a suggestion to make it easier if
a web gateway is an option.

----- Original Message -----
From: Wojciech Milek <wojciech.milek@demo.pl>
To: Bernie Huang <bernie.huang@ec.gc.ca>; PHP_DB <php-db@lists.php.net>;
PHP_General <php-general@lists.php.net>; PGSQL-SQL
<pgsql-sql@postgresql.org>; PGSQL-GENERAL <pgsql-general@postgresql.org>
Sent: Thursday, November 30, 2000 6:16 PM
Subject: [PHP] RE: [SQL] a script that queries database periodically


> 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@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
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>




view thread (18+ messages)  latest in thread

Message-ID: <00b301c05ac2$8a2f8820$47ee8acf@primenet.com>
Permalink:  ../00b301c05ac2$8a2f8820$47ee8acf@primenet.com/
Also on:    postgresql.org/message-id/00b301c05ac2$8a2f8820$47ee8acf@primenet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jbeebe@aimsmarketing.com, php-db@lists.php.net, php-general@lists.php.net, pgsql-general@postgresql.org
  Subject: Re: [PHP] RE: [SQL] a script that queries database periodically
  In-Reply-To: <00b301c05ac2$8a2f8820$47ee8acf@primenet.com>
  References: <NEBBJLOFMMBLBDLIIGHHKEPGCCAA.wojciech.milek@demo.pl> <00b301c05ac2$8a2f8820$47ee8acf@primenet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox