将我的内存数据添加到 HTML 表中

我有一个名为 mysql 的数据库和一个名为 的表。该表有 6 列:waterparamsdbwaterparams


Temperature

Acidity

Ammonia

Nitrite

Nitrate

Phosphate

我使用HTML表单用数字更新表格。这部分工作正常。在 PHPMYADMIN 中,我看到包含以下信息的新行:


temperature ¦ acidity ¦ ammonia ¦ nitrite ¦ nitrate ¦ phosphate 

25.50 ¦ 7.60 ¦ 0.25 ¦ 0.00 ¦ 0.00 ¦ 1.00 

26.00 ¦ 7.80 ¦ 0.50 ¦ 0.25 ¦ 0.25 ¦ 2.00

我遵循 https://www.w3schools.com/php/php_mysql_select.asp 示例,并能够首先使用以下方法获取信息:


<!DOCTYPE html>

<html>


<head>

<meta content="text/html; charset=utf-8" http-equiv="Content-Type">

<title>Untitled 1</title>

</head>


<body>

<?php 

$username = "redacted"; 

$password = "redacted"; 

$database = "waterparamsdb"; 

$mysqli = new mysqli("localhost", $username, $password, $database); 

$query = "SELECT * FROM waterparams";



echo '<table border="0" cellspacing="2" cellpadding="2"> 

      <tr> 

          <td> <font face="Arial">Temperature</font> </td> 

          <td> <font face="Arial">Acidity</font> </td> 

          <td> <font face="Arial">Ammonia</font> </td> 

          <td> <font face="Arial">Nitrite</font> </td> 

          <td> <font face="Arial">Nitrate</font> </td> 

          <td> <font face="Arial">Phosphate</font> </td> 

      </tr>';


if ($result = $mysqli->query($query)) {

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

        $field1name = $row["col1"];

        $field2name = $row["col2"];

        $field3name = $row["col3"];

        $field4name = $row["col4"];

        $field5name = $row["col5"]; 

        $field5name = $row["col6"];


        echo '<tr> 

                  <td>'.$field1name.'</td> 

                  <td>'.$field2name.'</td> 

                  <td>'.$field3name.'</td> 

                  <td>'.$field4name.'</td> 

                  <td>'.$field5name.'</td> 

                  <td>'.$field6name.'</td>

              </tr>';

    }

    $result->free();

?>

</body>

</html>

这工作正常,并以纯格式显示两行信息。我想做的是只将最后一行的值输出到HTML表中,并在网页上显示信息,如下所示:


Temperature ¦ Value

Acidity ¦ Value

Ammonia ¦ Value

Nitrite ¦ Value

Nitrate ¦ Value

Phosphate ¦ Value

我已经尝试了从上面的网站改编的以下内容,但它返回0结果。


繁花如伊
浏览 92回答 1
1回答

慕容森

像这样更改 if 循环if ($result->num_rows > 0) {&nbsp; &nbsp; echo "<table><tr><th>Temperature</th><th>Acidity</th><th>Ammonia</th><th>Nitrite</th><th>Nitrate</th><th>Phosphate&nbsp; &nbsp; </th></tr>";&nbsp; &nbsp; // output data of each row&nbsp; &nbsp; while($row = $result->fetch_assoc()) {&nbsp; &nbsp; &nbsp; &nbsp; echo "<tr><td>" . $row["Temperature"]. "</td><td>" . $row["Acidity"]."</td><td>" . $row["Ammonia"]."</td><td>" . $row["Nitrite"]."</td><td>" . $row["Nitrate"]."</td><td>" . $row["Phosphate"]."</td></tr>";&nbsp; &nbsp; }&nbsp; &nbsp; echo "</table>";} else {&nbsp; &nbsp; echo "0 results";}但请确保这些数组中的值应是正确的列名$row["Temperature"]并将 sql 查询更改为此查询$sql = "SELECT * FROM waterparams";
打开App,查看更多内容
随时随地看视频慕课网APP