php 连接oracle

最新推荐文章于 2022-08-28 13:31:02 发布

暗影帝皇天

最新推荐文章于 2022-08-28 13:31:02 发布

阅读量364

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/dihuangtian01/article/details/50971197

版权

php 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

$dbconn=oci_connect('tzjh','tzjh',"(DESCRIPTION =  (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.136.20)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = zjqqcs)))");
if($dbconn!=false)
{}
else
{echo "连接失败";}

$sqle = "select  serial_no,init_date,fund_account,contract_code,entrust_bs,futures_direction,futu_business_price,business_amount,business_time,frozen_fare from hs_futures.fureal order by serial_no ASC,init_date ASC,fund_account ASC";
$ora_testr = oci_parse($dbconn,$sqle);  //编译sql语句
oci_execute($ora_testr,OCI_DEFAULT);  //执行

$h=0;
while($r=oci_fetch_row($ora_testr))  //取回结果
{
echo $r[0];
}