abosalaar Posted May 26, 2013 Share Posted May 26, 2013 How it can be configured using cpanel of the host. Thanks in advance 1 Quote Link to comment Share on other sites More sharing options...
Ice IT Support Posted May 27, 2013 Share Posted May 27, 2013 This code connects to a database and executes a command $oracledb["host"] = "MYSERVICE"; # service name in the tnsnames.ora file $oracledb["user"] = "myuser"; # username $oracledb["pass"] = "mypass"; # password $oracledb["library"] = "OCI"; $connect_id = ocilogon($oracledb["user"], $oracledb["pass"], $oracledb["host"]); $query = "SELECT * FROM table"; $statement = ociparse($connect_id, $query); ociexecute($statement); $result = array(); while(ocifetchinto($statement, $tmp, OCI_ASSOC + OCI_RETURN_NULLS + OCI_RETURN_LOBS)) { array_push($result, $tmp); } ocifreestatement($statement); var_dump($result); # result is here From http://stackoverflow.com/questions/4583962/connect-to-an-oracle-database-using-php 1 Quote Link to comment Share on other sites More sharing options...
abosalaar Posted June 1, 2013 Author Share Posted June 1, 2013 I want to connect remote oracle database from php form running on heliohost's stevie. Thanks in advance Quote Link to comment Share on other sites More sharing options...
Ice IT Support Posted June 3, 2013 Share Posted June 3, 2013 Stevie doesn't run Oracle. I highly recommend using MySQL on Stevie as an alternative. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.