php连接远程oracle的老问题,没有接触过oracle,不知道哪里问题? 客户端装好后要配置监听的Warning: Unable to connect to ORACLE (ORA-12154: TNS:无法处理服务名) in D:\phpsite\hospital\TMPfeyxz77l60.php on line 33好像是说你的监听没有配好. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 监听怎么设定?还有那个php_oic8.dll怎么不能装载? 你都用php_oic8.dll了,怎么还用ora()来连接啊?应该用oic()来连接吧。 那个php_oraclle.dll也是打开的,我当然也可以用了。我是这两个都想用。问题现在是一个也用不上来。 $conn=OCILogon("$user","$pass","$tns");$q1 = "SELECT b.mc, sum(a.edcw) edcw, f_jcfx_get_zyrs1(b.xmxh,20040901) zyrs, round(sum(a.sycw)/decode(sum(a.edcw),0,null,sum(a.edcw)),4) syl, round(sum(a.cyrs)/decode(sum(a.edcw),0,null,sum(a.edcw)),4) zzl, sum(a.ryrs) ryrs, sum(a.cyrs) cyrs, sum(a.zrrs) zrrs, sum(a.zcrs) zcrs FROM jcfx_zy_zhxx a, jcfx_v_xmgl b WHERE a.jcfx_id >= 20040901 AND a.jcfx_id <= 20040901 AND b.bs = 'BQKS' AND a.ksdm = b.gldm GROUP BY b.mc, b.xmxh";$mycursor($conn,$q1);OCIDefineByName($mycursor,"RY_DM",$ry_dm);OCIDefineByName($mycursor,"RY_MC",$ry_mc);OCIExecute($show_zg);while(OCIFetch($mycursor)){ echo "RESULT: ora_getcolumn ($mycursor, 0), ora_getcolumn ($mycursor, 1) <br/>";}OCILogoff($conn);楼主试试吧! OCIDefineByName($mycursor,"RY_DM",$ry_dm);OCIDefineByName($mycursor,"RY_MC",$ry_mc);是我自己的字段,忘记修改了.呵呵!不好意思 不是代码问题。是连接都不行啊。PHP Warning: Unknown(): Unable to load dynamic library 'd:\php\extensions\php_oci8.dll' - 找不到指定的程序。 in Unknown on line 0 你看看这个 有用单元测试做php开发的吗 httpd.ini index.php? 301重定向到/ 关于页面之间大量传递数据的问题 php通用防注入程序 file_put_contents 为什么无法修改文件? 为什么使用wamp将short_open_tag设为on后仍然无法使用短标签 类属性访问 php问题,各位大哥进来看看,谢谢 关于类的问题,程序执行错误,高人给分析一下 下载的最新版本的php 4.2.3 在win2000下如何安装???在线等!急!!! cookie取不到值?在线等?? 我会ASP+SQLServer,PHP+MySQL好学吗?请大侠们给点意见。
还有那个php_oic8.dll怎么不能装载?
我是这两个都想用。
问题现在是一个也用不上来。
$q1 = "SELECT b.mc,
sum(a.edcw) edcw,
f_jcfx_get_zyrs1(b.xmxh,20040901) zyrs,
round(sum(a.sycw)/decode(sum(a.edcw),0,null,sum(a.edcw)),4) syl,
round(sum(a.cyrs)/decode(sum(a.edcw),0,null,sum(a.edcw)),4) zzl,
sum(a.ryrs) ryrs,
sum(a.cyrs) cyrs,
sum(a.zrrs) zrrs,
sum(a.zcrs) zcrs
FROM jcfx_zy_zhxx a, jcfx_v_xmgl b
WHERE a.jcfx_id >= 20040901
AND a.jcfx_id <= 20040901
AND b.bs = 'BQKS'
AND a.ksdm = b.gldm
GROUP BY b.mc, b.xmxh";
$mycursor($conn,$q1);
OCIDefineByName($mycursor,"RY_DM",$ry_dm);
OCIDefineByName($mycursor,"RY_MC",$ry_mc);
OCIExecute($show_zg);
while(OCIFetch($mycursor)){
echo "RESULT: ora_getcolumn ($mycursor, 0), ora_getcolumn ($mycursor, 1) <br/>";
}
OCILogoff($conn);
楼主试试吧!
OCIDefineByName($mycursor,"RY_MC",$ry_mc);
是我自己的字段,忘记修改了.呵呵!
不好意思
是连接都不行啊。
PHP Warning: Unknown(): Unable to load dynamic library 'd:\php\extensions\php_oci8.dll' - 找不到指定的程序。 in Unknown on line 0
你看看这个