pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: GH <grasshacker@over-yonder.net>
To: Adam Haberlach <adam@newsnipple.com>
Cc: Uro Gruber <uros@sir-mag.com>
Cc: pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL
Date: Sat, 6 Jan 2001 11:22:07 -0600
Message-ID: <20010106112207.A59573@over-yonder.net> (raw)
In-Reply-To: <20010105220727.B4224@newsnipple.com>
References: <631076786.20010105231729@sir-mag.com>
	<20010105220727.B4224@newsnipple.com>

On Fri, Jan 05, 2001 at 10:07:28PM -0800, some SMTP stream spewed forth: 
> On Fri, Jan 05, 2001 at 11:17:29PM +0100, Uro Gruber wrote:
> > Hi!
> > 
> > I have some questions about coding in php with postgre.
> > 
> > Here is my code
> > 
> > $qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username");
> > $row = 0; // postgres needs a row counter other dbs might not
> > while ($data = @pg_fetch_object ($qu, $row)) {
> > echo $data->username." (";
> > echo $data->password ."): ";
> > echo $data->client_id."<BR>";
> > $row++;
> > }
> > 
> > When i execute this i get 3 records (in DB is also 3 records), if i
> > delete @ before pg_fetch_object i get an error:
> > 
> > "Unable to jump to row 3 on PostgreSQL result index 4"
> > 
> > I understand what's wrong and i know why is that @.
> > 
> > What i do want to know is, if there is something wrong with this
> > function or am i doing something wrong. I don't like that kind of
> > errors. How can i stop before the end.
> 
$nr=pg_numrows($qu);
for($i=0; $i < $nr; $i++)

This add another variable in exchange for saving an obscene amount of 
time counting rows on every iteration.

The same situation occures when going through arrays, only with arrays
if an array item is removed, then the number is different and may affect
the row count and thus the loop. I doubt that such could happen with
a resultset, but it is safer and a buttload faster to pre-count the rows.

gh

>>>>> 	for($i=0; $i < pg_numrows($qu); $i++) {

> 		$data = pg_fetch_object($qu, $row);
> 		echo $data->username." (";
> 		echo $data->password ." )";
> 		echo $data->client_id."<BR>>";
> 	}
> 
> 	You can blame the PHP people for having wildly dissimilar systems
> for iterating through result sets...
> 
> > In mysql there was no need to count rows.
> 
> 	Let's not start the MySQL vs. Postgres wars again...  :)
> 
> -- 
> Adam Haberlach            |A cat spends her life conflicted between a
> adam@newsnipple.com       |deep, passionate, and profound desire for
> http://www.newsnipple.com |fish and an equally deep, passionate, and
> '88 EX500                 |profound desire to avoid getting wet.



view thread (10+ messages)  latest in thread

Message-ID: <20010106112207.A59573@over-yonder.net>
Permalink:  ../20010106112207.A59573@over-yonder.net/
Also on:    postgresql.org/message-id/20010106112207.A59573@over-yonder.net

 · 

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-php@postgresql.org
  Cc: grasshacker@over-yonder.net, adam@newsnipple.com, uros@sir-mag.com, pgsql-general@postgresql.org
  Subject: Re: PHP and PostgreSQL
  In-Reply-To: <20010106112207.A59573@over-yonder.net>
  References: <631076786.20010105231729@sir-mag.com> <20010105220727.B4224@newsnipple.com> <20010106112207.A59573@over-yonder.net>

* 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