duandou8457 2017-11-07 22:09
浏览 78
已采纳

PHP + HTML + MySQL查询

I need to echo a row from mysql database. When i echo this in the start (php) it works, but when in html, it doesn't work. Do i need to include something or what? I'm not very good with php, just learning...

  • 写回答

1条回答 默认 最新

  • dousao6313 2017-11-07 22:22
    关注

    It doesn't work in html because $row variable is visible only in the while loop scope!

    while($row = $result->fetch_assoc()) {

      if($_GET['email'] != $row["email"]){
        echo "ERROR: Emails don't match! <br>";
        echo "Please try again!";
        exit();
        $conn->close();
      }

      echo "Ticket Information: <br>";
      echo "Ticket: #" . $row["id"]. " - Name: " . $row["username"]. " - Message: " . $row["Message"]. "<br>";
      echo "MySQL: ";
      echo $row["email"];
    }

    Try something like this:

        while($row = $result->fetch_assoc()) {

              if($_GET['email'] != $row["email"]){
                echo "ERROR: Emails don't match! <br>";
                echo "Please try again!";
                exit();
                $conn->close();
              }

$rowId = $row["id"];

              echo "Ticket Information: <br>";
              echo "Ticket: #" . $row["id"]. " - Name: " . $row["username"]. " - Message: " . $row["Message"]. "<br>";
              echo "MySQL: ";
              echo $row["email"];
            }

    In HTML:

    <!DOCTYPE html>
<html lang="en">
  <head>
    <title>MrRockis's Website</title>
  </head>
  <body>
// Here i want to echo my ticket ID!
    <b>Ticket ID:<b> <?php echo $rowId; ?>
  </body>
</html>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥15 乘性高斯噪声在深度学习网络中的应用
  • ¥15 运筹学排序问题中的在线排序
  • ¥15 关于docker部署flink集成hadoop的yarn，请教个问题 flink启动yarn-session.sh连不上hadoop，这个整了好几天一直不行，求帮忙看一下怎么解决
  • ¥30 求一段fortran代码用IVF编译运行的结果
  • ¥15 深度学习根据CNN网络模型，搭建BP模型并训练MNIST数据集
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热（温度不同）的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
  • ¥30 python代码，帮调试，帮帮忙吧