php and Oracle with Oracle on remote server

garfvader

I have a project I want to do for my work. Currently, we have a web server running UNIX with Apache and we have another server that has Oracle on it for my work's database.

The idea is that I would like to use php to write a program that will interact with this Oracle database which is on another server. Oracle is not installed on the server with Apache.

My question is, is it possible for me to connect to the server with Oracle to access the Oracle database using php so that I can have my php program interact and send queries to the database? If so, could anyone give me a quick run down on how?

Thanks!

LordShryku

Which version of Oracle? If before 8.1, use these functions. Otherwise, use these functions

Real easy to do
1) Make the connection
2) Execute the query
3) Pull back the resultset
4) Close the connection

Good luck

garfvader

Hmmm it's the Make a Connection part that's throwing me. I could just be not understanding the Oracle commands (I believe the version is 8.1) since I'm half dabbling with this stuff but it seems like it's requiring Oracle to be on the same server as the web server.

Do I need to set the $ORACLE_HOME variable to equate to the other server?

LordShryku

The version is important....find out exactly what you're using. ORACLE_HOME should have been setup during your Oracle Client install. The serve can be on the moon, pending enough CAT5, but you need to have a Client Installation on the box that will be accessing it.

garfvader

Ah ha I think that answered my question. I don't think there's an Oracle Client installed on the server with my web server. I'll have to check into that.

Thanks for all your help!