Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] Re: [GENERAL] Re: [PHP] a script that queries database periodically From: Bob Irwin (noodles <email protected>)
Date: 12/01/00

TCL should allow you to do this too... Pretty easy to pick up too.

Dunno if it's free or what, but we use TCL for all sorts of scripts that
grab postgres results and manipulates the buggery out of them :)

Just my 2 cents.
Bob

----- Original Message -----
From: Miles Thompson <milesthompson <email protected>>
To: Jason <jason <email protected>>
Cc: Bernie Huang <bernie.huang <email protected>>; PHP_DB <php-db <email protected>>;
PHP_General <php-general <email protected>>; PGSQL-SQL
<pgsql-sql <email protected>>; PGSQL-GENERAL <pgsql-general <email protected>>
Sent: Friday, December 01, 2000 11:22 PM
Subject: [PHP-DB] Re: [GENERAL] Re: [PHP] a script that queries database
periodically

>
> Jason's definitiely on the right track.
>
> I'd add that if you don'tknow Perl, Python might be easier. Check
> http://sourceforge.net/forum/forum.php?forum_id=39069, starship.net might
also
> have a PostreSQL module.
>
> Python also has a very easy to use SMTP module for mailing of reports.
>
> There's nothing anti-Perl here, I just don't know that language and found
> Python quite natural.
>
> Miles Thompson
>
> RE
> Jason wrote:
>
> > > 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?
> >
> > if you know perl, you should check out DBI. Read all about it at
> > www.cpan.org. It's pretty similar to the php database interface.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>