PHP and oracle

[bangk]

I have an Apache Web server with php
running. What I want to do is able to access
an oracle database which is on a different server (i.e different ip address from the webserver) . How do I do that?

Thanks

[Anon]

1) Read the OCI8 section (and optionally the Ora section) of the PHP Manual.
2) Verify you have the desired PHP Oracle extension(s). I recommend using the OCI8 (php_oci8.dll) functions instead of using Ora (php_oracle.dll) functions.
3) Install the Oracle client libraries (available on the Oracle CDs). Your Oracle DBA can help you configure the Net8/SQLNet tnsnames.ora.
4) Use an Oracle tool like SQLPlus to verify that the Oracle client has been installed and configured properly.
5) Uncomment Oracle appropriate extention(s) in your PHP.INI.
6) Do a phpinfo() to verify the extensions are being loaded.
7) Code to your heart's content.

-- Michael
Darkstreak Consulting
www.darkstreak.com

[bangk]

Do u know where I could obtain
the client/client libraries (dont have oracle CD) for linux.

[Anon]

You can buy software licenses (and order CDs) from Oracle's website (http://www.oracle.com/). Trial versions can be downloaded from the Oracle Technology Network website (http://otn.oracle.com/).

-- Michael
Darkstreak Consulting
www.darkstreak.com