PHP: pg_fetch_all_columns - Manual

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

search for in the

pg_fetch_all pg_execute

Last updated: Sat, 27 Jan 2007

view this page in

# pg_fetch_all_columns

(PHP 5 >= 5.1.0RC1)

pg_fetch_all_columns -- Fetches all rows in a particular result column as an array

## Описание

array pg_fetch_all_columns ( resource result [, int column] )

pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the result resource.

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

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

`result`

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

`column`

  Column number, zero-based, to be retrieved from the result resource. Defaults to the first column if not specified.

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

An array with all values in the result column.

`FALSE` is returned if `column` is larger than the number of columns in the result, or on any other error.

## Примеры

Пример 1. pg_fetch_all_columns() example

`<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occured.\n";
exit;
}
$result = pg_query($conn, "SELECT title, name, address FROM authors");
if (!$result) {
echo "An error occured.\n";
exit;
}
// Get an array of all author names
$arr = pg_fetch_all_columns($result, 1);
var_dump($arr);
?>`

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

pg_fetch_all()

add a note User Contributed Notes
pg_fetch_all_columns
There are no user contributed notes for this page.
pg_fetch_all pg_execute

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