oci_fetch_array
(PHP 5)
oci_fetch_array -- Returns the next row from the result data as an associative or numeric array, or bothDescription
array oci_fetch_array ( resource statement [, int mode] )Returns an array, which corresponds to the next result row or FALSE in case of error or there is no more rows in the result.
oci_fetch_array() returns an array with both associative and numeric indices.
Note: This function sets NULL fields to PHP NULL value.
Optional second parameter can be any combination of the following constants:
| OCI_BOTH - return an array with both associative and numeric indices (the same as OCI_ASSOC + OCI_NUM). This is the default behavior. |
| OCI_ASSOC - return an associative array (as oci_fetch_assoc() works). |
| OCI_NUM - return a numeric array, (as oci_fetch_row() works). |
| OCI_RETURN_NULLS - create empty elements for the NULL fields. |
| OCI_RETURN_LOBS - return the value of a LOB of the descriptor. |
It should be mentioned here, that oci_fetch_array() is insignificantly slower, than oci_fetch_row(), but much more handy.
Note: Don't forget, that Oracle returns all field names in uppercase and associative indices in the result array will be uppercased too.
|
Example 2. oci_fetch_array() with OCI_NUM example
|
|
Example 3. oci_fetch_array() with OCI_ASSOC example
|
|
Example 4. oci_fetch_array() with OCI_RETURN_LOBS example
|
See also oci_fetch_assoc(), oci_fetch_object(), oci_fetch_row() and oci_fetch_all().
