pg_fetch_all_columns

pg_fetch_all_columns

Fetches all rows in a particular result column as an array

array **pg_fetch_all_columns** PgSql\Result $result int $field

returns an array that

contains all rows (records) in a particular column of the instance. pg_fetch_all_columns``PgSql\Result

result``fieldColumn number. Defaults to the first column if not specified.

An with all values in the result column. array

Voorbeeld: 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);

?>

pg_fetch_all