   #PHP Manual PostgreSQL functions pg_fetch_array pg_fetch_object

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                pg_fetch_assoc

   (PHP 4 >= 4.3.0)
   pg_fetch_assoc -- Fetch a row as an associative array

Description

   array pg_fetch_assoc ( resource result [, int row])

   pg_fetch_assoc() returns an associative array that corresponds to the
   fetched row (tuples/records). It returns FALSE, if there are no more
   rows.

   pg_fetch_assoc() is equivalent to calling pg_fetch_array() with
   PGSQL_ASSOC for the optional third parameter. It only returns an
   associative array. If you need the numeric indices, use
   pg_fetch_row().

   row is row (record) number to be retrieved. First row is 0.

   pg_fetch_assoc() is NOT significantly slower than using
   pg_fetch_row(), while it provides a significant ease of use.

   Example 1. pg_fetch_assoc() example
   <?php
   $conn = pg_connect("dbname=publisher");
   if (!$conn) {
       echo "An error occured.\n";
       exit;
   }
   $result = pg_query($conn, "SELECT id, author, email FROM authors");
   if (!$result) {
       echo "An error occured.\n";
       exit;
   }
   while ($row = pg_fetch_assoc($result)) {
       echo $row['id'];
       echo $row['author'];
       echo $row['email'];
   }
   ?>

   See also pg_fetch_row(), pg_fetch_array(), pg_fetch_object() and
   pg_fetch_result().
   ______________________________________________________________________

   Prev           Home            Next
   pg_fetch_array  Up  pg_fetch_object
