Skip site navigation (1) Skip section navigation (2)

Re: using pg_fieldisnull

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: Christopher Smith <csmith(at)gio(dot)com(dot)au>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: using pg_fieldisnull
Date: 2000-07-13 09:44:58
Message-ID: 396D8F9A.415CED92@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-novice
Christopher Smith wrote:
> 
> Hi all,
> 
> Just wondering if anyone can give me some examples on how to use pg_fieldisnull.
> This is the reason why.. Currently I have this loop set up to get all data from
> a database (I'm just doing a simple one at the moment until I can teach myself
> some more :)..). I figure there's a lot better way to do this using
> pg_fieldisnull or some other means.

I haven't neede to use pg_fieldisnull at all myself, but here's how I
would code the loop you use...

$numrows = pg_numrows($result);
if ( $numrows > 0 ) echo "<table border=1>
<tr><th>ID</th><th>First Name</th><th>Surname</th></tr>\n";

for ( $row=0; $row < $numrows; $row++ ) {
  $person = pg_Fetch_Object( $result, $row );
  echo
"<tr><td>$person->id</td><td>$person->firstname</td><td>$person->surname</td></tr>\n";
}
if ( $numrows > 0 ) echo "</table>\n";


> 
> $numrows = pg_numrows($result);
> $row=0;
> printf ("<table border=1>\n");
> printf ("<tr><td>ID</td><td>First Name</td><td>Surname</td></tr>\n");
> do
> {
>   $myrow = pg_fetch_row ($result,$row);
>   printf ("<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[0], $myrow[1],
> $myrow[2]);
>   $row++;
> }
> while ($row < $numrows);
> 
> it doesn't nescessarily have to put it into a table, so formatting it isn't a
> problem.  Any suggestions? I know there's a better way to do this, but I can't
> think of it :(
> I'm using pgsql6.5.3 and php4.

As I said, I'm not sure why you need to know if one of the fields is
null, but I have found the above style of PHP coding much more
re-readable in general.  Especially the use of field names rather than
arrays for the returned record.

Cheers,
					Andrew.
-- 
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

In response to

pgsql-novice by date

Next:From: Jacques WilliamsDate: 2000-07-13 12:37:31
Subject: Re: pgsql setup
Previous:From: Christopher SmithDate: 2000-07-12 23:27:53
Subject: using pg_fieldisnull

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group