Hello to whoever reads this, well i am having a problem in running a php script that accesses oracle database, my system configuration is as follows:-
- Windows Xp sp2
- Oracle 9i
- Apache 2
- php 5.2.11
i had to uninstall apache 1.3 that comes with the oracle 9i, because i wanted to use the newer version of apache. Now, the problem is if i run the php script below it doesn't display data on the browser, the only output that the browser displays is the 'OCI Test' which suggests that php is correctly configured with the apache. i have also uncommented the php_oci8.dll in the php.ini file
<html>
<head><title>PHP Test with Oracle</title></head>
<body>
<pre>
<?php
echo "<h1>OCI Test</h1>\n";
$conn=OCILogon("scott", "tiger", "DB10G");
$stmt = OCIParse($conn, "SELECT table_name FROM user_tables ORDER BY table_name");
OCIExecute($stmt, OCI_DEFAULT);
while (OCIFetch($stmt)) {
$table_name = OCIResult($stmt, "TABLE_NAME");
echo "$table_name<br />\n";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
</pre>
</body>
</html>
I can't seem to understand the problem.