Posted by Shane Presley on 10/20/36 11:19

Hello,

I've recompiled PHP to use Oracle, and been able to run a quick test
script that looks like...

<?php
if ($c=OCILogon("user", "pw", "server")) {
echo "Successfully connected to Oracle.\n";
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
?>


So now I'm going through and converting my MySQL code to Oracle. I've
finished the connect functions, but getting hung up on how to do
queries. For example the first query wants to SHOW TABLES. Not sure
how to do this with Oracle calls?

function get_tables($link) {
$tableList = array();
$query = "SHOW TABLES";
$result = perform_query($query, $link);
while($row = fetch_array($result)) {
array_push($tableList, $row[0]);
}

return $tableList;
}


function perform_query($query, $link) {
if($link) {
$result = mysql_query($query, $link) or die('Query
failed: ' . mysql_error());
}
else {
die('No DB link');
}

return $result;
}


Thanks!
Shane

• Next in forum: Re: [PHP] How to convert documents to PDF using PHP
• Prev in forum: Re: [PHP] passing login paramters from php web application to asp web application. help.
• Thread view: Showing tables (converting from MySQL to Oracle)

[Reply to this message]