|
|
Posted by "Kristen G. Thorson" on 10/14/42 11:19
This is really a question for an Oracle list, but I happen to know of
the following page which has been helpful to me in the past:
https://gdsg.ngdc.noaa.gov/tiki/tiki-index.php?page=SqlNotes
kgt
Shane Presley wrote:
>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
>
>
>
Navigation:
[Reply to this message]
|