oci_fetch_array

Returns the next row from a query as an associative or numeric array.

oci_fetch_array Function synopsis

oci_fetch_array($statement, int $mode = OCI_BOTH | OCI_RETURN_NULLS): array|false

Parameters

$statement

Can also be a statement identifier returned by oci_get_implicit_resultset.

$mode

OptionalTypeintDefault valueOCI_BOTH | OCI_RETURN_NULLS

An optional second parameter can be any combination of the following constants:

Return value

Typearray|false

Returns an array with associative and/or numeric indices. If there are no more rows in the $statement then false is returned.

By default, `LOB` columns are returned as LOB descriptors.

DATE columns are returned as strings formatted to the current date format. The default format can be changed with Oracle environment variables such as NLS_LANG or by a previously executed ALTER SESSION SET NLS_DATE_FORMAT command.

Oracle's default, non-case sensitive column names will have uppercase associative indices in the result array. Case-sensitive column names will have array indices using the exact column case. Use var_dump on the result array to verify the appropriate case to use for each query.

The table name is not included in the array index. If your query contains two different columns with the same name, use OCI_NUM or add a column alias to the query to ensure name uniqueness, see example #7. Otherwise only one column will be returned via PHP.