PHP
downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

oci_fetch_object> <oci_fetch_array
Last updated: Fri, 04 Jul 2008

view this page in

oci_fetch_assoc

(PHP 5, PECL oci8:1.1-1.2.4)

oci_fetch_assoc — Returns the next row from the result data as an associative array

Descripción

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

Lista de parámetros

statement

A valid OCI statement identifier.

Valores retornados

Returns an associative array, or FALSE if there are no more rows in the statement .

Note: Esta funcion define campos NULL como valores PHP NULL.

Note: Oracle returns all field names in uppercase and associative indices in the result array will be uppercased too.



add a note add a note User Contributed Notes
oci_fetch_assoc
24-Jul-2006 03:52
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' }
adrian dot crossley at hesa dot ac dot uk
20-Jul-2006 12:53
For earlier PHP versions use ocifetchinto with OCI_ASSOC

oci_fetch_object> <oci_fetch_array
Last updated: Fri, 04 Jul 2008
 
 
show source | credits | sitemap | contact | advertising | mirror sites