PHP/Oracle NOT on same server - HELP!

Slypknot

Hi folks! I could really use your help with the following:

Oracle 8 installed on NT
PHP/Apache installed on Linux.

Almost all of the documentation I have read shows php compiling with the --with-oci8=ORACLE_HOME

If Oracle is NOT installed on the same server as PHP is - I wouldn't have an ORACLE_HOME and thus this config wouldn't work.

I haven't found anything to show how to get PHP to connect to oracle UNLESS it's installed on the same server... is this a limitation with PHP or am I missing something?

Is there any assistance out there for this type of configuration?
:rolleyes:
Thanks for your help!

piersk

I use PHP on windows and the oracle server is not on my PC. I have the Oracle client installed and I just connect to it using the service name given and ive had no probs whatsoever.

Does fill in the name of your OS here have some sort of oracle client that you use to connect to? If so, it SHOULD have some sort of service naming facility which you could use to connect once you've finally got PHP up and running...

el_kab0ng

The oracle client has to be installed on the PHP machine. Not the database itself. In order for PHP to connect to a remote oracle db, it needs some sort of session ID to connect with.

Here's how I make remote connections via php to an oracle DB:

$sql = "SELECT * FROM table WHERE field = 'field";

// create connection
$connection = OCILogon("user","pass","SID")
	or die("Couldn't logon.");

// parse SQL statement
$sql_statement = OCIParse($connection,$sql)
	or die("Couldn't parse statement.");

// execute SQL query
OCIExecute($sql_statement)
or die("Couldn't execute statement.");

while (ocifetch($sql_statement)) {

ociresult($sql_statement,"field");

}

On my solaris box, oracle is installed:

/u01/app/oracle/product/8.1.6/

The tnsnames.ora file which contains all of the IP's, ports and db's is read by the SID you call and the translations are made automatically. But AFAIK, you HAVE to have at least the oracle client on the same server as PHP.