php连oracle的问题?select语句老是说“表或视图不存在”,但同样的sql语句在sql*plus里可以执行。 我不晓得怎么帮你不过 错误教你换个用户去连接sysdba 或者 sysoper 才可以在PHP中连接ORACLE吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 数据库连接成功。但我怎么显示字段name的值啊?<?$conn = ora_plogon("system","sa","local");$cursor = ora_open($conn ) or die("ora_open");$Query_String="select * from ctxsys.mytest";ora_parse($cursor ,$Query_String) or die("fail");ora_exec($cursor);//$data = $column['name'];这二句好象不行//echo $data;ora_close($cursor);?> <?php print "<HTML><PRE>\n"; $conn = OCILogon("TQ", "TQ","TQ"); $stmt = OCIParse($conn,"select * from m_user"); OCIExecute($stmt); while ( OCIFetch($stmt) ) { print "\n"; $ncols = OCINumCols($stmt); for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_value = OCIResult($stmt,$i); print $column_name . ': ' . $column_value . "\n"; } print "\n"; } OCIFreeStatement($stmt); OCILogoff($conn); print "</PRE>"; print "</HTML>\n";?> php调用mysql的存储过程失败!不返回结果!那个大侠能够帮助下,不胜感激啊! 两个FLOAT相加出现的奇怪现象~~~~ 请教关于TO_DAYS的效率问题 ICONV_IMPL 的使用方法? 如何反复打开一个网页传递参数进去 PHP中如何得到数组长度? sql关联问题A\B\C三个表, PHP@MySQL同时向两个表插入数据 使用jquery调用c#方法,前台展示数据的时候,并不是一次性展示,而是一块一块的展示 关于PHP 中,Ajax 发送后服务器端处理Header跳转的问题 那位朋友能送我一份WEB程序开发文档? "再"问如何将用户填入的表单信息,发送到指定邮箱!100分
<?
$conn = ora_plogon("system","sa","local");
$cursor = ora_open($conn ) or die("ora_open");
$Query_String="select * from ctxsys.mytest";
ora_parse($cursor ,$Query_String) or die("fail");
ora_exec($cursor);//$data = $column['name'];这二句好象不行
//echo $data;
ora_close($cursor);?>
print "<HTML><PRE>\n";
$conn = OCILogon("TQ", "TQ","TQ");
$stmt = OCIParse($conn,"select * from m_user");
OCIExecute($stmt);
while ( OCIFetch($stmt) ) {
print "\n";
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i++ ) {
$column_name = OCIColumnName($stmt,$i);
$column_value = OCIResult($stmt,$i);
print $column_name . ': ' . $column_value . "\n";
}
print "\n";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
print "</PRE>";
print "</HTML>\n";
?>