pg_fetch_all_columns

(PHP 5 >= 5.1.0, PHP 7)

pg_fetch_all_columnsFetches all rows in a particular result column as an array

说明

pg_fetch_all_columns ( resource $result [, int $column = 0 ] ) : array

pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the result resource.

Note: 此函数将 NULL 字段设置为 PHP 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.

范例

Example #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($result1);

var_dump($arr);

?>

参见

相关文章
php ibm db2 函数 returns an array indexed by column position representing a row in a result setphp ibm db2 函数 returns an array indexed by column name representing a row in a result setphp ibm db2 函数 returns an array indexed by both column name and position representing a row in a result setphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp ingres 函数 fetch a row of result into an arrayphp ldap 函数 get all binary values from a result entryphp maxdb 函数 returns an array of resources representing the fields in a result setphp msql 函数 get number of rows in resultphp mssql 函数 fetch a result row as an associative array a numeric array or bothphp mssql 函数 returns an associative array of the current row in the resultphp oci8 函数 fetches the next row into result bufferphp postgresql 函数 fetches all rows in a particular result column as an arrayphp sqlite 函数 fetches a column from the current row of a result setphp sqlite 函数 fetches the current row from a result set as an arrayphp sqlite 函数 fetches all rows from a result set as an array of arraysphp sqlite 函数 fetches the next row from a result set as an arrayphp sqlite 函数 return an array of column types from a particular tablephp sqlite 函数 fetches the first column of a result set as a stringphp sqlsrv 函数 retrieves the number of rows in a result setphp mysqli result fetches all result rows as an associative array a numeric array or both
关注编程学问公众号