equiv to mysql_fetch_array

[Anon]

Lately I have been tasked with interfacing with an Oracle database after spending the last 2 years using mysql... In any event, I'm looking for a similar functionality between the two when fetching an array...

As per mysql, when I want to push all the results within arrays for later use, I'd normally do this:

$row = mysql_fetch_array($sql_result);
$option1 = $row["option1"];
$option2 = $row["option2"];
$option3 = $row["option3"];
$option4 = $row["option4"];
$option5 = $row["option5"];

What would be the same using the oracle functions?

[mwilson]

Perhaps looking in the PHP manual pages at the Oracle functions might shed some light on the subject?

http://www.php.net/manual/en/ref.oracle.php

Matt

[Anon]

Already been there...done that.... not sure on the actual useage compared to what I'm used to...

I'm assuming it begins with either:

ora_fetch_into

or

Ora_Fetch

but like I said, using them is another issue altogether... I'd like to see some real examples...

[[deleted]]

I take it you did not read any of the examples and annotations?

The man page for ora_fetch_into clearly says:

<?php
array($results);
ora_fetch_into($cursor, &$results);
echo $results[0];
echo $results[1];
?>

that's 99.9% of what you are looking for.

Type it into a script and see what it does.

[Anon]

Warning: Supplied resource is not a valid Oracle-Cursor resource in.....

I hate Oracle.... seriously..

[[deleted]]

Read the man pages one by one, don't just dive in trying to make snippets work.

use google, find a tutorial.. do some more research.

PS Don't hate Oracle, hate MySQL. at least that makes sense... 🙂

[Anon]

hehehe... with a fresh perspective and the help of some core examples, I was able to determine (and make work) the following...

where one would normally do this in mysql:

$row = mysql_fetch_array($sql_result);
$option1 = $row["option1"];
$option2 = $row["option2"];
$option3 = $row["option3"];
$option4 = $row["option4"];

I now do this with Oracle:

OCIFetchInto($sql_statement, $row, OCI_ASSOC + OCI_RETURN_NULLS);
$option1 = $row["OPTION1"];
$option2 = $row["OPTION2"];
$option3 = $row["OPTION3"];
$option4 = $row["OPTION4"];
$option5 = $row["OPTION5"];

Hopefully this will help some poor soul looking for the same answers I was...

Key points here... you MUST use capital letters to define your column. (Hence OPTION1... etc)

[[deleted]]

"you MUST use capital letters"

ok, maybe a small reason to hate Oracle :-)