我有一个名为 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结果。
慕容森