   #PHP Manual PostgreSQL functions pg_escape_string pg_fetch_array

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                 pg_fetch_all

   (PHP 4 >= 4.3.0)
   pg_fetch_all -- Fetches all rows from a result as an array

Description

   array pg_fetch_all ( resource result)

   pg_fetch_all() returns an array that contains all rows
   (tuples/records) in result resource. It returns FALSE, if there are no
   rows.

   Example 1. PostgreSQL fetch all
   <?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_all($result);
   var_dump($arr);
   ?>

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

   Prev             Home           Next
   pg_escape_string  Up  pg_fetch_array
