MySQL and Oracle functions, what is the problem with this code ?

[Mika]

Hi,

I have converted a Mysql database to Oracle9i, and it works fine. (connection works and simple sql queries from php). I think the problem is that I don't know which functions to use with oracle. The following code works with mysql, any ideas how can I get it to work with oracle?

function getlist($query)
{
settype($result,'array');
if (!strlen($query) == 0)
{
$data = mysql_query($query,$link)
or die ('Tietokantahaku epäonnistui!');
while($colum = mysql_fetch_row($data))
{
foreach($colum as $row=>$value)
{
$result[$row][] = $value;
}
}

if(!empty($result));
{
return $result;

} }

I have tried something like this,unsuccesfully:

function getlist($query)
{
array($result);
if (!strlen($query) == 0)
{

$cursor = ora_open($connection);
$data = ora_parse($cursor, $query) or die ('haku ei onnistu');

$data = ora_exec($data);

while($colum = ora_fetch_into($cursor, &$result)) {

{
foreach ($colum as $row=>$value)
{
$result [$row] [] = $value;
}
}

if(!empty($result));
{

return $result;
}

}

I left the connection parameters away from above code, because the problem is not there. I would be grateful for any help.

[Jeewizz]

What errors do you get with the code you have tried?

[Mika]

it gives: Fatal error call to undefined function getlist()

call is on my main.php:

return getlist("select * from frames");

[Mika]

previous error was from a missing }

now it gives above error; line 48 is:

foreach ($colum as $row=>$value)

[jeremuck]

it means that $colum is not an array, for some reason or another.

Before you set the value of colum, try doing
$colum = array();
then do the while thing to set the value.

otherwise, make sure ora_fetch_into is supposed to return an array.