How to retrieve rows --PHP with Oracle

haans

Hi,

My objective is rather simple to retrieve say 4 columns from tableA in Oracle.
ie.
select col1,col2,col3,col4 from TableA
order by col1;

What can I do that in php tag calling Oracle?

I already have my OCI8 and oracle extension enabled.

I am able to connect to oracle using ocilogon.

But I dunno how to retrieve the data and return the results displayed to the browser.

Thank you.

bastien

http://www.php.net/manual/en/function.ora-do.php

haans

Originally posted by bastien
http://www.php.net/manual/en/function.ora-do.php

Yes OCI.logon. Could you just excuse me a moment, I am neither a PHP programmer or ordinary one. I am really a novice here. Perhaps I should pick up a book. Any good book to recommend for PHP with Oracle?

All I need is just a few lines of scripts / template showing me how to use OCILogon,...

I just dunno how to call the function.

Sorry, mean time I will search around for more information.

haans

Hi I managed to find the following code written by someone else (can't remember how I obtained) and able to work with Oracle.

Just wonder how come it always display "Resource id #3..." Anyway of getting rid of it.

Thanks.

<?php
print "<HTML><PRE>";
$db = "bmcs";
$c1 = ocilogon("scott","scott1i",$db);
// $c2 = ocilogon("scott","scott1i",$db);

function create_table($conn)
{ $stmt = ociparse($conn,"create table scott.hallo (test varchar2(64))");
ociexecute($stmt);
echo $conn." created table\n\n";
}

create_table($c1);