Oracle Connection

Do you have questions regarding other database enginges (not MySQL) -- ask here!

Moderators: macek, egami, gesf

Olodu
New php-forum User
New php-forum User
Posts: 2
Joined: Sat Sep 10, 2005 7:29 pm
Location: London
Contact:

Oracle Connection

Postby Olodu » Sat Sep 10, 2005 7:48 pm

Hi Everyone,

I have a Windows 2003 Server running Oracle 9i Enterprise Edition. I have been using
the oracle database for a while. I have also recently installed MySQL 4.4, PHP 4.0 and
Apache Server 2.0 on the Server. I know Oracle 9i also has an in-built Apache Server for
its HTTP Server but I have never used it or start it. After the installation of Apache 2.0,
The Oracle Apache Server also get started each time the Apache 2.0 starts up. i.e
I have two Apache Services running at the same time. I can connect to MySQL
database using PHP on the Apache 2.0 server but I cannot connect to the
oracle database. I know I have to configure my php.ini file, but I do not know how
to go about it. Can anybody out there help?

Regards
Michael

sergeys
New php-forum User
New php-forum User
Posts: 2
Joined: Sat Jan 07, 2006 2:42 pm
Location: USA
Contact:

connect to oracle and pull the fields value

Postby sergeys » Sat Jan 07, 2006 3:09 pm

$conn = ocilogon($ouser, $opassword, $odb);


if (!$conn)
{
$e = ocierror(); // For oci_connect errors pass no handle

echo "if not connection<br>";

echo htmlentities($e['message']);
}
else

$dsql="select ........";

//echo "<br>".$dsql;

$stmt = ociparse($conn,$dsql );

ociexecute($stmt, OCI_DEFAULT);

while (OCIFetchInto ($stmt, $drow, OCI_NUM))
{
$field1=$drow[0];
$field2=$drow[1];
................
}
.......................

if($stmt)
ocifreestatement($stmt);


See also http://www.configure-all.com for apache and php configuration


Return to “Other Database Engines”

Who is online

Users browsing this forum: No registered users and 0 guests