Re: Re: [GENERAL] Re: [PHP] a script that queries database periodically

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@sprint.ca> To: Jason <jason@jnj.org> Cc: 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: 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@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >