Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are The PHP Codes For making and Connecting Oracle Database with one table contain the following ?

ID , Country , city , name , mobile , phone , address

user-image
Question added by Deleted user
Date Posted: 2014/04/05
Muktar SayedSaleh
by Muktar SayedSaleh , Software Engineering Manager , AIRASIA

try OCI library.

islam khalil
by islam khalil , Technical Manager , iCloudit

Use : oci_connect

oci_connect ( string $username , string $password [, string $connection_string [, string $character_set [, int $session_mode ]]] )

 

 

Haithm Abdulrahman Garallah
by Haithm Abdulrahman Garallah , Head Of Development Dapt. , Sahafah Yemen Agency - sahafahyemen.net

<?php// Connects to the XE service (i.e. database) on the "localhost" machine$conn oci_connect('hr''welcome''localhost/XE');if (!$conn) {    $e oci_error();    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);}$stid oci_parse($conn'SELECT * FROM employees');oci_execute($stid);echo "<table border='1'>\\n";while ($row oci_fetch_array($stidOCI_ASSOC+OCI_RETURN_NULLS)) {    echo "<tr>\\n";    foreach ($row as $item) {        echo "    <td>" . ($item !== null htmlentities($itemENT_QUOTES) : "&nbsp;") . "</td>\\n";    }    echo "</tr>\\n";}echo "</table>\\n";?>

Noor Khan
by Noor Khan , Technical Team Leader , Insightz360

$conn = oci_connect('hr', 'welcome', 'localhost/XE');

 

if (!$conn)

{

   $e = oci_error();

   trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);

}

 

Source: http://www.php.net/manual/en/function.oci-connect.php

More Questions Like This

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