oci_fetch_array
keys for oci_fetch_assoc($rsc) is case-sensitive.
Especially, if the query has an alias name, the alias name is automatically put to capital.
For example, query:
select id, sum(fee) fee
from acct
group by id
will have keys of { 'ID', 'FEE' }
oci_fetch_assoc
(PHP 5, PECL oci8 >= 1.1.0)
oci_fetch_assoc — Returns the next row from the result data as an associative array
Description
array oci_fetch_assoc
( resource $statement
)
Returns the next row from the result data as an associative array.
Calling oci_fetch_assoc() is identical to calling oci_fetch_array() with OCI_ASSOC.
A subsequent call to oci_fetch_assoc() will return the next row or FALSE if there are no more rows.
For details on the data type mapping performed by the oci8 driver, see the datatypes supported by the driver
Parameters
- statement
-
A valid OCI statement identifier.
Return Values
Returns an associative array, or FALSE if there are no more rows in the statement .
Note: This function sets NULL fields to the PHP NULL value.
Note: Oracle returns all field names in uppercase and associative indices in the result array will be uppercased too.
See Also
- oci_fetch_array() - Returns the next row from the result data as an associative or numeric array, or both
- oci_fetch_object() - Returns the next row from the result data as an object
- oci_fetch_row() - Returns the next row from the result data as a numeric array
- oci_fetch_all() - Fetches all rows of result data into an array
add a note
User Contributed Notesoci_fetch_assoc
24-Jul-2006 01:52
adrian dot crossley at hesa dot ac dot uk
20-Jul-2006 10:53
20-Jul-2006 10:53
For earlier PHP versions use ocifetchinto with OCI_ASSOC