pg_fetch_all

(PHP 4 >= 4.3.0, PHP 5)

pg_fetch_all -- Fetches all rows from a result as an array

Описание

array pg_fetch_all ( resource result )

pg_fetch_all() returns an array that contains all rows (records) in the result resource.

Замечание: Эта функция устанавливает NULL-поля в значение NULL PHP.

Список параметров

result

PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

Возвращаемые значения

An array with all rows in the result. Each row is an array of field values indexed by field name.

FALSE is returned if there are no rows in the result, or on any other error.

Примеры

Пример 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);

?>

Смотрите также

pg_fetch_row()
pg_fetch_array()
pg_fetch_object()
pg_fetch_result()



pg_fetch_all
viniciusweb at gmail dot com
20-Mar-2005 06:20
This function returns NULL if the parameter is false.
frig1 at gmx dot at
03-Feb-2005 08:15
I'm using PHP 5.0.1 and pg_fetch_all and here pg_fetch_all is also not recognized as function
09-Jun-2003 05:36
Also for those who are trying to move off oracle, pg_fetch_all returns an array with rows and columns inverted in the sense of ocifetchall. You would need to transpose this result array before your code takes the first index a column name and the second index a row index.
php dot net at mechintosh dot com
16-May-2003 11:42
For versions of PHP that don't yet support the new names or newer functions I wrote a couple functions like this one

if (! function_exists("pg_fetch_all")) {
  function pg_fetch_all($res, $kind="assoc") {
   $i = 0; // this is needed for the row integer in the looped pg_fetch_array
   if ($kind == "assoc") {
     while ($row = pg_fetch_array($res, $i, PGSQL_ASSOC)) {
       $array_out[] = $row;
       $i++;
   }else{
     while ($row = pg_fetch_array($res)) {
       $array_out[] = $row;
     }
   }
   return $array_out;
  }
}
tasmanian at devil dot com
27-Mar-2003 10:42
It seems like pg_fetch_all() only works on version 4.3.x. I tried it with 4.2.2 and it does not recognize the function, so I assume it won't work on 4 => 4.2.x.
jcomeau at whatisthewww dot com
19-Feb-2003 12:02
pg_fetch_all, despite the app note, accepts only one argument, the resultset. It does exactly what is expected, returning a two-dimensional array of the resultset. I suspect the app note given was just copied from pg_fetch_array, which is what you want to use for a single row.

<pg_fetch_all_columnspg_fetch_array>
 Last updated: Tue, 15 Nov 2005