PHP: ora_fetch_into

Description

int ora_fetch_into ( resource cursor, array &result [, int flags] )

Fetches a row of data into an array. The flags has two flag values: if the ORA_FETCHINTO_NULLS flag is set, columns with NULL values are set in the array; and if the ORA_FETCHINTO_ASSOC flag is set, an associative array is created.

Returns the number of columns fetched.

Пример 1. ora_fetch_into()

<?php $results = array(); ora_fetch_into($cursor, $results); echo $results[0]; echo $results[1]; $results = array(); ora_fetch_into($cursor, $results, ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC); echo $results['MyColumn']; ?>

ora_fetch_into

HERVE3D
15-Feb-2006 01:57


With : ora_fetch_into($curs, &$dt, ORA_FETCHINTO_ASSOC)

If the value of a field is NULL it will contains value from the row before.



To avoid this you can use :

ora_fetch_into($curs, $dt, ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC);

And NULL fields remain empty.

kamas at telkom dot net
03-Jun-2003 01:19


becareful when fetching data with NULL value using ora_fetch_into().

table example :

field1    field2    nullable

----------------------

a    b    c

w    w    NULL

d    d    NULL

e    e    x



//php script :

$curs = ora_open($conn);

ora_parse($curs, "SELECT * FROM tableblah");

ora_exec($curs);

while(ora_fetch_into($curs, &$dt, ORA_FETCHINTO_ASSOC)) {

    echo $dt['field1'] . " - " . $dt['field2'] . " - " . $dt['nullable'] . "<br>\n";

}

ora_close($curs);



the above code will print:

a - b - c

w - w - c

d - d - c

e - e - x



if the value of the nullable field is NULL it will contains value from the 

row before. to avoid this you can use :



while(ora_fetch_into($curs, &$dt, ORA_FETCHINTO_ASSOC)) {

    ...

    $dt['nullable'] = "";

}



to set $dt['nullable'] to an empty value.

Markus dot Elfring at web dot de
30-May-2002 04:33


The function "OCIFetchInto" seems to be better for special datatypes like "CLOB" or "BLOB".