pg_fetch_all

Function • Params changed in PHP 8.1

Fetches all rows from a result as an array.

PHP 5
PHP 7
PHP 8.0
Improved
PHP 8.1
Improved
PHP 8.2-8.3
PHP 8.4
PHP 8.5
PHP 8.6

pg_fetch_all Function synopsis

pg_fetch_all(PgSql\Result $result, int $mode = PGSQL_ASSOC): array

Parameters

$result

TypePgSql\Result

$mode

OptionalTypeintDefault valuePGSQL_ASSOC

$mode accepts one of the following constant values:

Return value

Typearray

An array with all rows in the result. Each row is an array of field values indexed by field name.

Changes to the pg_fetch_all Function

PHP 8.1

  • Parameter type added for parameter #1 ($result): PgSql\Result
- pg_fetch_all($result, int $mode = PGSQL_ASSOC): array
+ pg_fetch_all(PgSql\Result $result, int $mode = PGSQL_ASSOC): array

PHP 8.0

  • Return type added: array
  • Parameter name of parameter #2 changed: $result_type to $mode
  • Parameter type added for parameter #2 ($mode): int
  • Parameter default value added for position #2 ($mode): PGSQL_ASSOC
- pg_fetch_all($result, $result_type)
+ pg_fetch_all($result, int $mode = PGSQL_ASSOC): array

PHP 7.1

  • Optional parameter added - #2: $result_type
- pg_fetch_all($result)
+ pg_fetch_all($result, $result_type)

pg_fetch_all Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release Yes
PHP 8.5Supported (Latest) Yes
PHP 8.4Supported Yes
PHP 8.3Security-Fixes Only Yes
PHP 8.2Security-Fixes Only Yes
PHP 8.1Unsupported Yes
PHP 8.0Unsupported Yes
PHP 7.4Unsupported Yes
PHP 7.3Unsupported Yes
PHP 7.2Unsupported Yes
PHP 7.1Unsupported Yes
PHP 7.0Unsupported Yes
PHP 5.6Unsupported Yes
PHP 5.5Unsupported Yes
PHP 5.4Unsupported Yes
PHP 5.3Unsupported Yes