PHP: ora_fetch_into - Manual

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

search for in the

ora_fetch ora_exec

Last updated: Sat, 27 Jan 2007

view this page in

# ora_fetch_into

(PHP 3, PHP 4, PHP 5 <= 5.1.0RC1)

ora_fetch_into -- Fetch a row into the specified result array

## 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'];
?>`

See also ora_parse(),ora_exec(), ora_fetch(), and ora_do().

add a note User Contributed Notes
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".`
add a note
ora_fetch ora_exec

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST