PHP: pg_fetch_all - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

pg_fetch_array pg_fetch_all_columns

Last updated: Sat, 27 Jan 2007

view this page in

# 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()

add a note User Contributed Notes
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.`
add a note
pg_fetch_array pg_fetch_all_columns

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST