dongmacheng3222 2018-12-04 08:57
浏览 67

PHP查询不适用于Oracle数据库

I have a php page that is connecting to an oracle database. I am trying to print out the records from a table TEAM.

// Remember to replace 'username' and 'password'!
$conn = oci_connect('username','password','(DESCRIPTION=(ADDRESS_LIST= 
(ADDRESS=(PROTOCOL=TCP)(Host=db2.ndsu.edu)(Port=1521)))(CONNECT_DATA= 
(SID=cs)))');
echo $conn;
//put your query here
$query = "SELECT * FROM TEAM";
$stid = oci_parse($conn,$query);
oci_execute($stid,OCI_DEFAULT);

//iterate through each row
while ($row = oci_fetch_array($stid,OCI_ASSOC)) 
{
//iterate through each item in the row and echo it  
foreach ($row as $item)    
{
    echo $item.' ';
}   
echo '<br/>';}
oci_free_statement($stid);
oci_close($conn);
?>

I did change the user name and password. The echo $conn is printing out "Resource id #4" so I believe I am connected to the database.

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥65 永磁型步进电机PID算法
    • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
    • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
    • ¥15 如何处理复杂数据表格的除法运算
    • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
    • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
    • ¥200 uniapp长期运行卡死问题解决
    • ¥15 latex怎么处理论文引理引用参考文献
    • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
    • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?