dongxi4235 2012-04-24 20:28
浏览 126
已采纳

获取多个查询结果并使用带有oracle的php显示到表中

My issue is I have a website that is linking to multiple tables in Oracle. I currently have PHP code that checks user input assigned to a variable to find data in a table, then the oci_fetch_row statement that grabs the row where the data matches. This works fine but I cannot find how to output more than one row from a table if some values are the same?

Currently the one row it grabs is put into a simple HTML table.

Any help in to how to fetch all rows that the data matches and output to table would be appreciated.

My code is:

$userfeedback = "SELECT * FROM ASSET_FEEDBACK WHERE USER_EMAIL = '$userEmail' ORDER BY FEEDBACK_DATE";

$stmt3 = oci_parse($conn, $userfeedback);

if(oci_execute($stmt3))

{


    $row=oci_fetch_row($stmt3) ;

    print"<h2 id='title'>This Users Feedback</h2>";
    "<table border='2'>";

    print"<tr><td><p>Feedback ID:</td><td>$row[0]</td></tr>";
    print"<tr><td>Asset ID:</td><td>$row[1]</td></tr>";
    print"<tr><td>Feedback:</td><td>$row[3]</td></tr>";
    print"<tr><td>Date added:</td><td>$row[4]</td></tr>";

    print"</table></br>";   

}
  • 写回答

2条回答 默认 最新

  • douyan1244 2012-04-24 20:34
    关注

    Put the oci_fetch_row statement into a while loop. OCI Fetch Array for a code sample

    print"<h2 id='title'>This Users Feedback</h2>";
    print"<table border='2'>";
    
    while ($row=oci_fetch_row($stmt3))
    {
    
        print"<tr><td><p>Feedback ID:</td><td>$row[0]</td></tr>";
        print"<tr><td>Asset ID:</td><td>$row[1]</td></tr>";
        print"<tr><td>Feedback:</td><td>$row[3]</td></tr>";
        print"<tr><td>Date added:</td><td>$row[4]</td></tr>";
    
    
    }
    print"</table></br>"; 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型