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 a query as an associative array
Description
array oci_fetch_assoc
( resource $statement
)
Returns an associative array containing the next result-set row of a query. Each array entry corresponds to a column of the row. This function is typically called in a loop until it returns FALSE, indicating no more rows exist.
Calling oci_fetch_assoc() is identical to calling oci_fetch_array() with OCI_ASSOC + OCI_RETURN_NULLS.
Parameters
- statement
-
A valid OCI8 statement identifier created by oci_parse() and executed by oci_execute(), or a REF CURSOR statement identifier.
Return Values
Returns an associative array. If there are no more rows in the statement then FALSE is returned.
Notes
Note: See oci_fetch_array() for examples of fetching rows.
See Also
- oci_fetch() - Fetches the next row from a query into internal buffers
- oci_fetch_all() - Fetches all rows of result data into an array
- oci_fetch_array() - Returns the next row from a query as an associative or numeric array
- oci_fetch_object() - Returns the next row from a query as an object
- oci_fetch_row() - Returns the next row from a query as a numeric array
add a note
User Contributed Notesoci_fetch_assoc
24-Jul-2006 03:52
adrian dot crossley at hesa dot ac dot uk
20-Jul-2006 12:53
20-Jul-2006 12:53
For earlier PHP versions use ocifetchinto with OCI_ASSOC