oci_fetch_all

Function • Removed in PHP 8.4

Fetches multiple rows from a query into a two-dimensional array.

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

oci_fetch_all Function synopsis

oci_fetch_all(
    $statement,
    &$output,
    int $offset = 0,
    int $limit = -1,
    int $flags = OCI_FETCHSTATEMENT_BY_COLUMN | OCI_ASSOC
  ): int

Parameters

$statement
$output

Passed by reference

The variable to contain the returned rows.

$offset

OptionalTypeintDefault value0

The number of initial rows to discard when fetching the result. The default value is 0, so the first row onwards is returned.

$limit

OptionalTypeintDefault value-1

The number of rows to return. The default is -1 meaning return all the rows from $offset + 1 onwards.

$flags

OptionalTypeintDefault valueOCI_FETCHSTATEMENT_BY_COLUMN | OCI_ASSOC

Parameter $flags indicates the array structure and whether associative arrays should be used.

Note that the parameter $output is passed by reference, and contains additional/updated context data that may be useful.

Return value

Typeint

Returns the number of rows in $output, which may be 0 or more.

Changes to the oci_fetch_all Function

PHP 8.4

  • Function removed

PHP 8.0

  • Return type added: int
  • Parameter name of parameter #1 changed: $statement_resource to $statement
  • Parameter name of parameter #3 changed: $skip to $offset
  • Parameter type added for parameter #3 ($offset): int
  • Parameter default value added for position #3 ($offset): 0
  • Parameter name of parameter #4 changed: $maximum_rows to $limit
  • Parameter type added for parameter #4 ($limit): int
  • Parameter default value added for position #4 ($limit): -1
  • Parameter type added for parameter #5 ($flags): int
  • Parameter default value added for position #5 ($flags): OCI_FETCHSTATEMENT_BY_COLUMN | OCI_ASSOC
  oci_fetch_all(
-     $statement_resource,
+     $statement,
      &$output,
-     $skip,
+     int $offset = 0,
-     $maximum_rows,
+     int $limit = -1,
-     $flags
+     int $flags = OCI_FETCHSTATEMENT_BY_COLUMN | OCI_ASSOC
-   )
+   ): int

oci_fetch_all Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release No
PHP 8.5Supported (Latest) No
PHP 8.4Supported No
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