php 访问oracle

最新推荐文章于 2024-04-17 15:51:46 发布

rznice

最新推荐文章于 2024-04-17 15:51:46 发布

阅读量822

点赞数

分类专栏： php

本文链接：https://blog.youkuaiyun.com/rznice/article/details/40652217

版权

php 专栏收录该内容

1 篇文章

订阅专栏

<html>
	<body>
		<?php
			header("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>