Extremely Urgent: Problem with PHP and Oracle
| From: | Charles Morris | Date: | Thu, 10 Jun 2004 01:55:49 +0000 |
| Subject: | Extremely Urgent: Problem with PHP and Oracle | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34691@lists.php.net to get a copy of this message | ||
Hello all, I have recently been working with OCI and when I use OCILogon
[wethere with example scripts or my own code] I get a "PAge cannot be
displayed" (like DNS error) when I naviagte to the page. When I comment
out the OCILogon part it works great exept for the oracle part. I am able
to accesss the database from Perl, the built in SQL*PLUS and other
languages.- The only problem is this. I have to have this working by
friday morning and I cannot risk not mailing this alias; so please any
help is greatly appreciated!!
Here are my code snippets:
dbconnection.php
<?php
class OracleConnection
{
var $CONN = "";
var $IPADD = "*.*.*.*";
var $USER = "****";
var $PASS = "********";
var $SID = "****";
function fatal_error($text)
{
$maillink = '<a href="mailto:cmorris@cs.odu.edu">network
administrator</a>';
echo "<b>Fatal Error. </b><br>";
echo "[$text] ( 0 : 0 ) <br>";
echo $_SERVER['HTTP_USER_AGENT'];
echo "<br>";
echo "ORACLE_SID: ".getenv("ORACLE_SID")."<BR>ORACLE_HOME:
".getenv("ORACLE_HOME"."<BR>";
$error = OCIError();
if ($error["offset"])
{
$sqltext = substr ($error["sqltext"], 0, $error["offset"]) .
'*' . substr ($err ($error["sqltext"], $error["offset"]);
}
else
{$sqltext = "No OCI error.";}
echo $sqltext;
echo "<BR>Contact the $maillink with this message.\n";
exit;
function init()
{
putenv("ORACLE_SID=PROJ");
putenv("ORACLE_HOME=/home/oracle9");
$ipadd = $this->IPADD;
$user = $this->USER;
$pass = $this->PASS;
// $dbase = $this->DBASE;
// $dbase = $DBAC_BEGIN . $DBAC_PROTO . $DBAC_HOST . $DBAC_PORT . "))" . $DBAC_COTD .
")";
$dbase = "(DESCRIPTION=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 128.*.*.*)(PORT =
1521)))(CONNECT_DATA=(SID=PROJ)))";
// use for PHP 5.0 and greater
// $conn = oci_connect($user, $pass, $dbase) || $this->fatal_error("Connection could not
be established with server [$ipadd]");
// use for PHP 4.91 and lower
$conn = ociplogon($user, $pass, $dbase) || $this->fatal_error("Connection could not be
established with server [$ipadd]");
$this->CONN = $conn || $this->fatal_error("Connection could not be stabalized, unable
to continue.");
return true;
}
//end class: 'OracleConnection'
}
--eof--
Also, could someone please send me a working example of using variables
appended to text with "array()"? I am a long time experienced perl
programmer and I have tried using the . operatore a + but no luck.
Thanks everyone!!!
Please excuse types, typing on a 14.4 connection.
-------------------------------------------------------------------------------
Charles Morris
cmorris@cs.odu.edu
CS Systems Group Old Dominion University
http://www.cs.odu.edu/~cmorris
http://www.cs.odu.edu/cspage/systemstaff.html
------------------------------------------------------------------------------
They that give up essential liberty to obtain
a little temporary safety deserve neither
liberty nor safety. -- Benjamin Franklin, 1759
The only secure computer is one that's unplugged, locked in a
safe, and buried 20 feet under the ground in a secret location...
and i'm not even too sure about that one"--Dennis Huges, FBI.