PHP Handbuch
ZurückWeiter

pg_fetch_all_columns

(no version information, might be only in CVS)

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

Beschreibung

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.

Anmerkung: Diese Funktion setzt NULL Felder auf den PHP Wert NULL.

Parameter Liste

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.

Rückgabewerte

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.

Beispiele

Beispiel 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);

?>

Siehe auch

pg_fetch_all()

ZurückZum AnfangWeiter
pg_executeNach obenpg_fetch_all

Hosting by: Hurra Communications GmbH
Generated: 2007-01-26 17:57:07