Received: from newsnipple.com (www.newsnipple.com [208.243.144.102]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f083Z1B55677 for ; Sun, 7 Jan 2001 22:35:01 -0500 (EST) (envelope-from adam@newsnipple.com) Received: by newsnipple.com (Postfix, from userid 1000) id A9C7E3116E; Sun, 7 Jan 2001 19:40:01 -0800 (PST) Date: Sun, 7 Jan 2001 19:40:01 -0800 From: Adam Haberlach To: GH Cc: Adam Haberlach , Uro Gruber , pgsql-general@postgresql.org Subject: Re: PHP and PostgreSQL Message-ID: <20010107194001.B16787@newsnipple.com> References: <631076786.20010105231729@sir-mag.com> <20010105220727.B4224@newsnipple.com> <20010106112207.A59573@over-yonder.net> <20010106115251.B59573@over-yonder.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010106115251.B59573@over-yonder.net>; from grasshacker@over-yonder.net on Sat, Jan 06, 2001 at 11:52:51AM -0600 X-Archive-Number: 200101/283 X-Sequence-Number: 2461 On Sat, Jan 06, 2001 at 11:52:51AM -0600, GH wrote: > On Sat, Jan 06, 2001 at 11:22:07AM -0600, some SMTP stream spewed forth: > > 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."
"; > > > > $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++) > > > (And I wasn't even drunk at type-time.) > (adds) > > This add another variable in exchange for saving an obscene amount of > > time counting rows on every iteration. > > I've always assumed that the number of rows is known by the result set so pg_numrows() is merely a (arguably) trivial lookup. Now that I've looked at the code, that assumption looks correct. The overhead seems to be one PHP function call and two C function calls. No counting, no loops, no obscenities. Unless PQntuples() is really stupid, but I'm not going to wander through another source tree tonight. -- 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.