From: gravity@node10065.a2000.nl
To: Uro Gruber <uros@sir-mag.com>
Cc: pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL
Date: Sat, 6 Jan 2001 02:15:28 +0100
Message-ID: <20010106021528.C24049@node10065.a2000.nl> (raw)
In-Reply-To: <631076786.20010105231729@sir-mag.com>
References: <631076786.20010105231729@sir-mag.com>
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.
> In mysql there was no need to count rows.
there are nicer ways (look for one in the db-abstraction layer in PHP-LIB)
but this works:
> $qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username");
$number_of_rows = pg_numrows($qu);
for ($counter=0;$counter<$number_of_rows;$counter++) {
$data_array = pg_fetch_array($qu, $counter);
echo "$data_array[username]";
}
z.
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: gravity@node10065.a2000.nl, uros@sir-mag.com, pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL
In-Reply-To: <20010106021528.C24049@node10065.a2000.nl>
References: <631076786.20010105231729@sir-mag.com> <20010106021528.C24049@node10065.a2000.nl>
* 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