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 apd 函数 return all persistent resources as an arrayphp cubrid mysql 兼容性函数 get column information from a result and return as an objectphp cubrid 函数 get the number of rows in the result setphp 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 ibm db2 函数 returns the position of the named column in a result setphp ibm db2 函数 returns the precision of the indicated column in a result setphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp frontbase 函数 get column information from a result and return as an objectphp maxdb 函数 fetch a result row as an associative a numeric array or bothphp 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 mysql xdevapi sqlstatementresult get all rows from resultphp mysqli result fetches all result rows as an associative array a numeric array or both
关注编程学问公众号