Oracle-PHP
| From: | Vandana | Date: | Thu, 21 Jun 2001 20:49:08 +0000 |
| Subject: | Oracle-PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9707@lists.php.net to get a copy of this message | ||
I've just installed php4.0.4 , apache-1.3.14 and oracle8.1.6
on my RedHat 7.0 machine.I am trying to write a php script to connect
to my oracle database.But I am facing problems.When I used the oci8
functions as follows:
<?php
putenv("ORACLE_SID=sid");
putenv("ORACLE_HOME=/ora1/app/oracle/product/8.1.6");
line 11 if($conn=OCILogon("scott","tiger"))
{
echo("Successful:Connected\n");
}
else {
echo("Connection failed\n");
}
?>
the error message was:
Warning:OCISessionBegin: ORA-01034: ORACLE not available in
/www/servers/index.php on line 11
Connection failed
-------------------------------------
And when I wrote the script with ordinary oracle function,
replacing the OCILogon with a call to Ora_Logon, the error was as
following:
Fatal error: Maximum execution time of 30 seconds exceeded in
/www/servers/index.php on line 11
-------------------------------------------
Could somebody please help me with this problem? And
also, is there any good tutorial for PHP/Oracle ?