pg_fetch_all

Fetches all rows from a result as an array (PHP 4 >= 4.3.0)
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 751. PostgreSQL fetch all

copy to clipboard
<?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().

This HTML Help has been published using the chm2web software.