= 5.1.0, PHP 7, PHP 8)pg_fetch_all_columns — Fetches all rows in a particular result column as an array說明pg_fetch_all_colu">

pg_fetch_all_columns

(PHP 5 >= 5.1.0, PHP 7, PHP 8)

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

說明

pg_fetch_all_columns(PgSql\Result $result, int $field = 0): array

pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the PgSql\Result instance.

注意: 此函數將 NULL 字段設置為 PHP null 值。

參數

result

An PgSql\Result instance, returned by pg_query(), pg_query_params() or pg_execute()(among others).

field

Column number. Defaults to the first column if not specified.

返回值

An array with all values in the result column.

更新日志

版本 說明
8.1.0 現在 result 參數接受 PgSql\Result 實例，之前接受 資源(resource)。

范例

示例 #1 pg_fetch_all_columns() example

<?php 
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
  echo "An error occurred.\n";
  exit;
}

$result = pg_query($conn, "SELECT title, name, address FROM authors");
if (!$result) {
  echo "An error occurred.\n";
  exit;
}

// Get an array of all author names
$arr = pg_fetch_all_columns($result, 1);

var_dump($arr);

?>

參見