Connecting to Oracle

Anon

Hi,

Can some one give me instructions as how to connect to oracle databse through php?

i\'m currently running php scripts on win2k using odbc connections. it works just fine.

i need to connect to oracle directly. oracle 8i is residing on HPUX box.

I\'d appreciate if any one can help me with detailed instructions as how to go about it.

Thanks,

Anon

You're using PHP on Windows right? You'll need to install the PHP/Oracle DLL's that will give you access to the OCI functions. I don't know how to do that as I use PHP on Unix systems.

Once you have PHP running with Oracle installed its easy to connect to oracle.

Here's a sample:

if($conn = OCILogon("dbusername", "dbpasswd", "OracleSID"))
{
$sql = "SELECT * FROM mytable";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
while($result = OCIFetchInto($stmt, $results, OCI_ASSOC)
{
echo $results["MYFIELD"] . " ";
}
}
else
{
echo "Could not connect to Oracle";
}

One thing to keep in mind is that when you get a result array back from OCIFetchinto or OCIFetchStatement all your field names will be in UPPERCASE letters.

Hope this helps.

James

briand

...actually, there's a bit more groundwork to be laid before the above sample login will work.

On your Windows machine (with PHP & your web server), you'll need to install the Oracle Net8 client software. This will allow your Windows machine to see the Oracle database (typically, this client installation will also include SQL*Plus and a few other utilities [like tnsping] as well as a configuration wizard for setting up the tnsnames.ora file). Once you've run the Windows client install/configuration and your Windows machine can see the Oracle database, then the above-mentioned sample PHP script should work for you.

The Oracle 8i Client for Microsoft Windows NT/2000 disk is usually included in all of the Oracle CD packs, regardless of which architecture your Oracle is installed on.

In our setup here, we have Oracle 8i running on a Sun Sparc, and our Apache/PHP installation is on a Linux machine. I had to obtain a copy of the Oracle 8i installation for Linux in order to get the client software for Linux.

Brian