   #PHP Manual PostgreSQL functions pg_fetch_all pg_fetch_assoc

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                pg_fetch_array

   (PHP 3>= 3.0.1, PHP 4 )
   pg_fetch_array -- Fetch a row as an array

Description

   array pg_fetch_array ( resource result [, int row [, int
   result_type]])

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

   pg_fetch_array() is an extended version of pg_fetch_row(). In addition
   to storing the data in the numeric indices (field index) to the result
   array, it also stores the data in associative indices (field name) by
   default.

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

   result_type is an optional parameter that controls how the return
   value is initialized. result_type is a constant and can take the
   following values: PGSQL_ASSOC, PGSQL_NUM, and PGSQL_BOTH.
   pg_fetch_array() returns associative array that has field name as key
   for PGSQL_ASSOC, field index as key with PGSQL_NUM and both field
   name/index as key with PGSQL_BOTH. Default is PGSQL_BOTH.

     Note: result_type was added in PHP 4.0.

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

   Example 1. pg_fetch_array() example
   <?php
   $conn = pg_pconnect("dbname=publisher");
   if (!$conn) {
       echo "An error occured.\n";
       exit;
   }
   $result = pg_query($conn, "SELECT * FROM authors");
   if (!$result) {
       echo "An error occured.\n";
       exit;
   }
   $arr = pg_fetch_array($result, 0, PGSQL_NUM);
   echo $arr[0] . " <- array\n";
   $arr = pg_fetch_array($result, 1, PGSQL_ASSOC);
   echo $arr["author"] . " <- array\n";
   ?>

     Note: From 4.1.0, row became optional. Calling pg_fetch_array()
     will increment internal row counter by 1.

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

   Prev         Home           Next
   pg_fetch_all  Up  pg_fetch_assoc
