   #PHP Manual PostgreSQL functions pg_fetch_assoc pg_fetch_result

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                pg_fetch_object

   (PHP 3>= 3.0.1, PHP 4 )
   pg_fetch_object -- Fetch a row as an object

Description

   object pg_fetch_object ( resource result [, int row [, int
   result_type]])

   pg_fetch_object() returns an object with properties that correspond to
   the fetched row. It returns FALSE if there are no more rows or error.

   pg_fetch_object() is similar to pg_fetch_array(), with one difference
   - an object is returned, instead of an array. Indirectly, that means
   that you can only access the data by the field names, and not by their
   offsets (numbers are illegal property names).

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

   Speed-wise, the function is identical to pg_fetch_array(), and almost
   as quick as pg_fetch_row() (the difference is insignificant).

     Note: From 4.1.0, row is optional.

     From 4.3.0, result_type is default to PGSQL_ASSOC while older
     versions' default was PGSQL_BOTH. There is no use for numeric
     property, since numeric property name is invalid in PHP.

     result_type may be deleted in future versions.

   Example 1. pg_fetch_object() example
   <?php
   $database = "store";
   $db_conn = pg_connect("host=localhost port=5432 dbname=$database");
   if (!$db_conn) {
       echo "Failed connecting to postgres database $database\n";
       exit;
   }
   $qu = pg_query($db_conn, "SELECT * FROM books ORDER BY author");
   $row = 0; // postgres needs a row counter
   while ($data = pg_fetch_object($qu, $row)) {
       echo $data->author . " (";
       echo $data->year . "): ";
       echo $data->title . "<br />";
       $row++;
   }
   pg_free_result($qu);
   pg_close($db_conn);
   ?>

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

   See also pg_query(), pg_fetch_array(), pg_fetch_assoc(),
   pg_fetch_row() and pg_fetch_result().
   ______________________________________________________________________

   Prev           Home            Next
   pg_fetch_assoc  Up  pg_fetch_result
