Home/ Manual/ pgsql / functions/ pg_fetch_all_columns

pg_fetch_all_columns

PHP function Edit on GitHub ✎

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

Fetches all rows in a particular result column as an array

Description

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.

Fetch-null

Parameters

result: Result
field: Column number. Defaults to the first column if not specified.

Return Values

An array with all values in the result column.

Changelog

Version	Description

Examples

pg_fetch_all_columns() example

php

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

?>