pg_fetch_array

Function • Params changed in PHP 8.1

Fetch a row 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_array Function synopsis

pg_fetch_array(
    PgSql\Result $result,
    ?int $row = null,
    int $mode = PGSQL_BOTH
  ): array|false

Parameters

$result

TypePgSql\Result

$row

OptionalType?intDefault valuenull

Row number in result to fetch. Rows are numbered from 0 upwards. If omitted or null, the next row is fetched.

$mode

OptionalTypeintDefault valuePGSQL_BOTH

$mode accepts one of the following constant values:

Return value

Typearray|false

An array indexed numerically (beginning with 0) or associatively (indexed by field name), or both. Each value in the array is represented as a string. Database NULL values are returned as null.

false is returned if $row exceeds the number of rows in the set, there are no more rows, or on any other error. Fetching from the result of a query other than SELECT will also return false.

Changes to the pg_fetch_array Function

PHP 8.1

  • Parameter type added for parameter #1 ($result): PgSql\Result
  pg_fetch_array(
-     $result,
+     PgSql\Result $result,
      ?int $row = null,
      int $mode = PGSQL_BOTH
    ): array|false

PHP 8.0

  • Return type added: array|false
  • Parameter type added for parameter #2 ($row): ?int
  • Parameter default value added for position #2 ($row): null
  • Parameter name of parameter #3 changed: $result_type to $mode
  • Parameter type added for parameter #3 ($mode): int
  • Parameter default value added for position #3 ($mode): PGSQL_BOTH
  pg_fetch_array(
      $result,
-     $row,
+     ?int $row = null,
-     $result_type
+     int $mode = PGSQL_BOTH
-   )
+   ): array|false

pg_fetch_array 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