<?php
$db1 = "(DESCRIPTION =                                        
    (ADDRESS = (PROTOCOL = TCP)(HOST = Nik0)(PORT = 1521)) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )"; 
                                            
if (@$c=OCILogon("system", "admin", $db1) or die("<h1>DB is not accessible"))
{
  $s = OCIParse($c, "select * from direction");
  OCIExecute($s, OCI_DEFAULT);
  while (OCIFetch($s)) {

  echo "ID=" . ociresult($s, "ID_DIRCT") .
          ", NAME=" . ociresult($s, "NAME_DIRCT") . " <br>\n";
	$id = ociresult($s, "ID_DIRCT");
	$name = ociresult($s, "NAME_DIRCT");
	$arr[$id]=$name;

  } 
OCICommit($c);
OCILogoff($c);

} else {
  $err = OCIError();
  echo "Oracle Connect Error " . $err[text];
}
?>

<?php
$db1 = "(DESCRIPTION =                                        
    (ADDRESS = (PROTOCOL = TCP)(HOST = Nik0)(PORT = 1521)) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )"; 
                                         
if (@$c=OCILogon("system", "admin", $db1) or die("<h1>DB is not accessible"))
{
echo "fse tip top";
 } 
OCILogoff($c);
} else {
  $err = OCIError();
  echo "Oracle Connect Error " . $err[text];
}
?>

<?php

$db1 = "(DESCRIPTION =                                        
    (ADDRESS = (PROTOCOL = TCP)(HOST = Nik0)(PORT = 1521)) 
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )";                                              

if (@$c = ora_logon("Nik0@".$db1,"Nik0") or die("<H1>fatal error <br>" . ora_error())) 
	{
        $rezult_ok = "Connect to Oracle XE complite =)";
	$sql = "SELECT * FROM direction";
	$curs= ora_do($c, $sql);
	do 
		{
                $id = ora_getcolumn($curs,  0 );
		$name = ora_getcolumn($curs,  1 );
		$arr[$id]=$name;
		}	
  
	while (ora_fetch($curs));  
  	ora_logoff($c);
        } 
else 
	{
  	$rezult_er = "Oracle Connect Error " . ora_error();
	}
?>