I've made the connection to Oracle using the following code:
$connection = OCILogon ("$dbuser","$dbpass", "XYZ");
if ($connection == false){
echo OCIError($connection)."
";
exit;
}
I've searched high and low to find some code that will fetch rows from a table and print them. Here's what I've managed to put together, but it doesn't work:
OCIParse( $curs, "SELECT count(*) FROM table" );
OCIExecute( $curs );
OCIFetch( $curs );
$result = OCIResult($curs, 0 );
OCILogoff( $curs );
echo "RESULT :" . $result;
Can anyone point me to some better code that retrieves data from a table using Oracle 8i OCI functions?
Thanks!
dave
$connection = OCILogon ("$dbuser","$dbpass", "XYZ");
if ($connection == false){
echo OCIError($connection)."
";
exit;
}
I've searched high and low to find some code that will fetch rows from a table and print them. Here's what I've managed to put together, but it doesn't work:
OCIParse( $curs, "SELECT count(*) FROM table" );
OCIExecute( $curs );
OCIFetch( $curs );
$result = OCIResult($curs, 0 );
OCILogoff( $curs );
echo "RESULT :" . $result;
Can anyone point me to some better code that retrieves data from a table using Oracle 8i OCI functions?
Thanks!
dave