using ORACLE8i Functions in PHP

Anon

hello,

I am in the process of developing a web application where the user will be able to query data from an Oracle database.

Previously I had this application written in PHP to query data from a MySQL database, but I've decided to move onto bigger and better things ... like Oracle.

So, all I am trying to do for starters is select ALL rows from a column.

Here is what I got so far ...

<?php

$connection = OCILogon("blah","blah","blah") or die ("getdata.php could not connect to localhost.\n");

$sql_statement = "SELECT SOME_ROW FROM SOME_TABLE";

$sql_statement_parse = OCIParse($connection, $sql_statement) or die ("Couldn't parse statement.\n");

OCIExecute($sql_statement_parse) or die ("Couldn't execute statement.\n");

OCIFetch($sql_statement);

$id = OCIResult($sql_statement, 1);

I want to display the selected ALL rows from the selected column on the browser, but all I'm getting is an ERROR MESSAGE ...

***Warning: Supplied argument is not a valid OCI8-Statement resource

Could someone please tell me what I'm doing wrong ? PLEASE ...

THANKS !

LEO

thomasa

an example:

/*########################

Database Login

########################*/
$db ="hostname of the database. should be the same as in tnsnames";
//########################
$conn = ocinlogon("blah","pass",$db);

$sql = "SELECT * from emp";
{ $stmt = ociparse($conn,$sql);
ociexecute($stmt,OCI_DEFAULT);
while (ocifetch($stmt)) {
echo ociresult($stmt,"TABLE_NAME");
}
}

i hope it will help you...

Anon

ok, i tried what you told me but it didn't work ...

but, this is what i figured out and it works ...

<?php

$connection = OCILogon("blah","blah","blah") or die ("getdata.php could not connect to localhost.\n");

$sql_statement = OCIParse($connection, "SELECT SOME_ROW FROM SOME_TABLE") or die ("Couldn't parse statement.\n");

OCIDefineByName ($sql_statement, "SOME_ROW", $SOME_ROW);

OCIExecute($sql_statement) or die ("Couldn't execute statement.\n");

echo "<TABLE BORDER=1>";

echo "<TR><TH>SOME ROW</TH></TR>";

while (OCIFetch($sql_statement)) {
echo "<TR>";
echo "<TD>$id</TD>";
}

First of all I wasn't using my parsed statement in the OCIFetch function.

I got rid of the OCIResult function and defined my parsed statement with the OCIDefineByName function.

Then while(OCIFetch) ...
I echo the $SOME_ROW variable.

Also, note that you have to define your parsed statement before executing it and I put the variable in a HTML table to make it look neater.

This works like magic .. i love it !!

Thomas, thanks for your help