php 访问oracle

来源:互联网 发布:flash整站源码 编辑:程序博客网 时间:2024/06/05 19:11
<html><body><?phpheader("Content-Type:text/html;charset=gbk"); $dbconn=OCILogon("dbusername","dbpassword","(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=ip)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME=servername)))"); if($dbconn!=false) { echo "连接成功"; echo "<br>"; $stmt=oci_parse($dbconn,"select 1 from dual"); oci_execute($stmt,OCI_DEFAULT); $result=oci_fetch_assoc($stmt);     print_r($result);     echo "<br>"; if(OCILogOff($dbconn)==true)      {       echo "关闭连接成功!";     } }else {  echo "连接失败";  }  echo "<br>";</body></html>

0 0