Home > PHP > Function > OCI8 > oci_fetch_all()

oci_fetch_all()

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

Syntax

int oci_fetch_all (resource $statement, array &$output, int $skip, int $maxrows, int $flags)

Arguments

  • statement - A valid OCI8 statement identifier created by oci_parse() and executed by oci_execute(), or a REF CURSORstatement identifier.
  • output - The variable to contain the returned rows. LOB columns are returned as strings, where Oracle supports conversion. See oci_fetch_array() for more information on how data and types are fetched.
  • skip - The number of initial rows to discard when fetching the result. The default value is 0, so the first row onwards is returned.
  • maxrows - The number of rows to return. The default is -1 meaning return all the rows from skip + 1 onwards.
  • flags

Description

Fetches multiple rows from a query into a two-dimensional array. By default, all rows are returned.

Version

PHP 5, PECL OCI8 >= 1.1.0

Return value

Returns the number of rows in output, which may be 0 or more, or FALSE on failure.