How to use PHP with Oracle Database 11g

This source code shows you how to connect to Oracle Database 11g and execute queries using the PHP. First of all it sets the ORACLE_HOME and ORACLE_SID Environment variables using the putenv() method.

Note that to run this code, you will need PHP OCI8 extension enable in php.ini file.

//connect to server
if(!($Connection = oci_connect("user", "password")))
{
 print("Could not connect to database!\n");
 exit;
}

$Query = "SELECT * FROM emp ";

//parse query
$stid = oci_parse($Connection , $Query);

// execute query
$r = oci_execute($stid);

// Fetch each row in the array
print '------------------table-----------------';
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS+OCI_ASSOC)) {
   print '\n';
   foreach ($row as $item) {
       print ' - '.($item !== null ? htmlentities($item, ENT_QUOTES) : ' ').' ';
   }

}
print '------------------/table-----------------';

// Close the Oracle connection
oci_close($Connection);

Here are some of the common OCI8 functions which are used to perform different operations using the PHP Source Code.