Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

RE: [PHP-DB] a more eloquent PostgreSQL/PHP version of MySQL/PHP routine From: Dave VanAuken (dave <email protected>)
Date: 12/03/00

Doug (et all),

You are correct re: the if statement. Usage of the if statement would assume
the inclusion of an error handler in the event that there was a failure to
return results.

Did not consider the syntax you submitted.. a little more compact while
remaining legible.

Thanks for the input.

Dave

-----Original Message-----
From: Doug Semig [mailto:dougslist <email protected>]
Sent: Sunday, December 03, 2000 5:27 PM
To: php-db <email protected>
Subject: Re: [PHP-DB] a more eloquent PostgreSQL/PHP version of
MySQL/PHP routine

How about something like this?

        $query = "select * from something";
        $result = pg_exec($database,$query);
        $tbNumRows=pg_numrows($result);
        for ($tbCount = 0; $tbCount < $tbNumRows; $tbCount++) {
                $row = pg_fetch_array($result,$tbCount); # or could use fetch row
                # do whatever with your row/result
        }

The only reason I can think of to nest the do/while within an if for your
MySQL solution is so you can have an else on the if to do something if no
rows were returned. (Read that sentence to your grandma and see if she
thinks your still human!)

If you don't have to do anything if no rows are returned, then this might
be more efficient (please forgive me, though, if it is wrong...I haven't
used MySQL in a long time and am only going on memory):

        $query = "select * from something";
        $result = mysql_query($query);
        while ($row = mysql_fetch_array($result)) {
                # do whatever with your row
        }

Doug

At 02:41 PM 12/3/00 -0500, Dave VanAuken wrote:
># the following has worked well with MySQL.
># assume $database contains previously designated connection.
>
> $query = "select * from something";
> $result = mysql_query($query);
> if ($row = mysql_fetch_array($result)) {
> do {
> # do whatever with your row
> } while ($row = mysql_fetch_array($result));
> }
>
>
># using the same syntax causes a number of errors with PostgreSQL.
># have had to resort to the following.
># assume $database contains previously designated connection.
>
> $query = "select * from something";
> $result = pg_exec($database,$query);
> if(pg_numrows($result)>0) {
> $tbNumRows=pg_numrows($result);
> $tbCount=0;
> while($tbCount<$tbNumRows) {
> $row = pg_fetch_array($result,$tbCount); # or could use fetch row
> # do whatever with your row/result
> $tbCount++;
> }
> }
>
>
># would appreciate any insight into streamlining the PostgreSQL code a
>little more
> 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>