Re: Best WebInterface...?

On Mon, 29 Jan 2001, Alfred Perlstein wrote:

> Date: Mon, 29 Jan 2001 14:13:38 -0800
> From: Alfred Perlstein <bright@wintelcom.net>
> To: Herb Pabst <herbie@nextearth.com>
> Cc: pgsql-list <pgsql-novice@postgresql.org>
> Subject: Re: Best WebInterface...?
>
> * Herb Pabst <herbie@nextearth.com> [010129 14:00] wrote:
> > I'm think of using PHP with Postgresql. Are there
> > any limitations to PHP that will keep me from
> > using PGsql to it fullest? Any recommendations?
>
> I'm not sure if this is true, but I think php doesn't support
> cursors, so large queiries may have to be sucked into the
> webserver instead of processed one row at a time.
>
>
I have used cursors with php for over a year.  The problem is that is does
not support them natively; any code that tests the call for pg_exec may
fail since the return is undefined.  Here's how I write the code:
//Note this is off the top of my head, you code may vary :-)

$q = "begin";
$count = "select count (*) from clients where active='t'";
$qry =  "declare fred cursor for select * from clients where active='t';
$fetch = "fetch 20 from fred";
$fini = "commit";
if(! $res1 = pg_exec( $connect, $count ) ){
    return 0;
}
if ( 0 < pg_numrows( $res1 ) ){
    pg_exec( $connect, $q );       //undefined behavior
    pg_exec( $connect, $qry );     //undefined behavior
    if (! $res= pg_exec( $connect, $q ) ){
        return 0;
    }
    pg_exec($connect, $fini);       //undefined bevhavior
    if ( 0 >= pg_numrows( $res ) ){
        return 0;
    }
    do_something ( $res )
}
pg_free_result( $res );
pg_free_result( $res1);

Move forward and backward works as before the fetch.  The part that I
don't like is the inability to check whether the transaction block querys
work; I had to console myself with counting the number of results I should
get for the same query.  The bad part is that there is WAY to many queries
being executed; the good part is it save a great many lines of
quasi-convoluted logic whilst incrementing to the n or n+1 row of an
answer.  I hope this helps,
--+*==#==*+----+*==#==*+----+*==#==*+----+*==#==*+----+*==#==*+----+*==#==*+--
fprefect@dustpuppy.net                         Currently doing fieldwork as:
Elite.net Support                              Robert McGinnis
"So an object class contains the data, plus everything the class can do.
But is it a direct object, indirect object, or object of a preposition?"6/7/97