php - 更新在数据库中不起作用

Question

不要介意安全问题，这只是本地测试，但是当我单击更新按钮时，页面或查询上不会发生任何更改，并且我没有收到任何错误。

<?php 

$link = mysqli_connect("localhost", "root", "", "test") or die("could not connect");

if (isset($_POST['update'])) { 

$updateQuery = (" UPDATE `test1` SET f_name = '$_POST[f_name]', l_name='$_POST[l_name]', email='$_POST[email]' WHERE id='$_POST[id]'");
mysqli_query($link, $updateQuery);


};


$query = ("SELECT * FROM `test1`");
$result = mysqli_query($link, $query);

echo "<table border=1
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Email</th> 
</tr>";

while($row = mysqli_fetch_array($result)) {
echo "<form method=post action=update.php>";
echo "<tr>";
echo "<td>" . "<input type=text name=f_name value=" . $row['f_name'] . " </td>";
echo "<td>" . "<input type=text name=l_name value=" . $row['l_name'] . " </td>";
echo "<td>" . "<input type=text name=email value=" . $row['email'] . " </td>";
echo "<td>" . "<input type=hidden name=id value=" . $row['id'] . " </td>";
echo "<td>" . "<input type=submit name=submit value=update" .  " </td>";
echo "</tr>";
}

？>

Answer 1

将您的表单更改为

while($row = mysqli_fetch_array($result)) {
    echo "<form method=post action=update.php>";
    echo "<input type=hidden name=update>";
    echo "<tr>";
    echo "<td>" . "<input type=text name=f_name value=" . $row['f_name'] . " </td>";
    echo "<td>" . "<input type=text name=l_name value=" . $row['l_name'] . " </td>";
    echo "<td>" . "<input type=text name=email value=" . $row['email'] . " </td>";
    echo "<td>" . "<input type=hidden name=id value=" . $row['id'] . " </td>";
    echo "<td>" . "<input type=submit name=submit value=update" .  " </td>";
    echo "</tr>";
}