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 , Director Design and Development , Webs5 Solutions
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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.