PHP も
癶玡秈


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.

猔: セㄧ计癸 PHP NULL 砞﹚ NULL 逆

把计

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



癶癬翴玡秈
pg_executepg_fetch_all