<HTML><HEAD>
<TITLE>Test de connexion PHP - Oracle</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</HEAD><BODY>
<CENTER><H1>Test de connexion PHP - Oracle</H1></CENTER>
<PRE>
<?php
define("ADDR", "//serveur.domaine.com/SID");
define("USER", "scott");
define("PASS", "tigger");
define("BASE", "SID");
$nls=getenv("NLS_LANG");
$tns=getenv("TNS_ADMIN");
echo "NLS_LANG=$nls\n";
if (empty($tns))
echo "\nVariable TNS_ADMIN non configuré\n";
else if (!is_file($tns."/tnsnames.ora"))
echo "\nFichier $tns/tnsnames.ora absent\n";
else {
echo "\nNormal Connect ($tns/tnsnames.ora):\n";
$conn = oci_connect(USER, PASS, BASE);
if ($conn ) {
echo "oci_connect Ok\n";
echo "Server Version: " . oci_server_version($conn) . "\n";
oci_close($conn);
}
else echo " oci_connect ERREUR\n";
}
echo "\nEasy Connect:\n";
$conn = oci_connect(USER, PASS, ADDR);
if ($conn ) {
echo "oci_connect Ok\n";
echo "Server Version: " . oci_server_version($conn) . "\n";
$st=oci_parse($conn, $sql="SELECT * FROM dept");
if (oci_execute($st))
{
$nrows = oci_fetch_all($st,$results);
print "<br />$sql<br />$nrows Records Selected<br />\n";
if ( $nrows > 0 ) {
print "<TABLE BORDER=\"1\">\n";
print "<TR>";
while ( list( $key, $val ) = each( $results ) ) {
print "<TH>$key</TH>";
}
print "</TR>\n";
for ( $i = 0; $i < $nrows; $i++ ) {
reset($results);
print "<TR>";
while ( $column = each($results) ) {
$data = $column['value'];
print "<TD>$data[$i]</TD>";
}
print "</TR>\n";
}
print "</TABLE>\n";
} else {
echo "No data found<BR>\n";
}
}
oci_close($conn);
}
else echo " oci_connect ERREUR\n";
print "\nConnexion pdo_oci\n";
try {
$db = new PDO ("oci:dbname=" . ADDR, USER, PASS);
printf("Connecté\n");
foreach ($db->query("SELECT * FROM dept") as $Row)
printf ("%d : %s, %s\n", $Row["DEPTNO"], $Row["DNAME"], $Row["LOC"]);
}
catch(PDOException $e) {
printf("ERREUR : %s\n", $e->getMessage());
}
?>
</PRE>
<HR SIZE=4>
</BODY>
</HTML>