php5以后 oci_logon 、ORA_Logon 函数已经弃用了 所以只能用 oci_connect
1、
<?php
$conn = oci_connect('xjintgra','xjintgra','10.233.233.20/topprd');
if (!$conn) {
$Error = oci_error();
print htmlentities($Error['message']);
exit;
}
else
{
echo "Connected Oracle Successd!";
ocilogoff($conn);
}
?>
2、
<?php
$tns = "
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.233.233.20)(PORT = 1521))
)
(CONNECT_DATA =
(SID = topprd)
)
)
";
echo ("oracle demo");
try {
$dbh = new PDO("oci:dbname=".$tns, "xjintgra", "xjintgra");
echo ("success");
}
catch (PDOException $e) {
echo "Failed to obtain database handle " . $e->getMessage();
}
?>
