Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to connect Wordpress with oracle? is their any plugin available?

how to connect my wordpress database with oracle?

user-image
Question added by Yaseen Ghafar , Development Director
Date Posted: 2015/08/20
Othman Agorram
by Othman Agorram , viseur , sanovia

function MyOracleConnection () { $conn = oci_connect('hr', 'tester', 'localhost/XE'); if (!$conn) { $e = oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } else { echo '<p>Congrats: Oracle meets WordPress!</p>'; } // Prepare the statement $stid = oci_parse($conn, 'SELECT * FROM departments'); if (!$stid) { $e = oci_error($conn); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } // Perform the logic of the query $r = oci_execute($stid); if (!$r) { $e = oci_error($stid); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } // Fetch the results of the query print "<table border='1'>\\n"; while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) { print "<tr>\\n"; foreach ($row as $item) { print " <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>\\n"; } print "</tr>\\n"; } print "</table>\\n"; oci_free_statement($stid); oci_close($conn); }

More Questions Like This