php 与 oracle11g 的连接和基本操作
<?php
$conn = ocilogon('system','Oracle123','127.0.0.1:1521/orcl');
if (!$conn)
{
$Error = oci_error();
print htmlentities($Error['message']);
exit;
}
else
{
echo "Connected Oracle Successd!"."<br>";
//ocilogoff($conn);
$sql = "select * from scott.dept";
$ora_test = oci_parse($conn,$sql); //编译sql语句
oci_execute($ora_test,OCI_DEFAULT); //执行
while($r=oci_fetch_row($ora_test)) //取回结果
{
$i=0;
echo $ora_test[0];
echo "<BR>";
echo $r[$i++]." </t> ";
echo $r[$i++]." </t> ";
echo $r[$i++]." </t> ";
}
}
?>
