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这个错误是怎么回事? php能调用C#的exe程序吗,,如果能,怎么在网页中显示出来呢 PHP写不进配置文件 求mysql查询语句 javascript 传值的问题 急!在线人数统计和点击下载功能如何实现!!! 怎么把字符串转换成16进制编码形式的字符串?? 实现注册时ID的先检测 http://www.abc.com/index.php?=1234 那位朋友能送我一份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";
?>