php - 无法检索 POST 数据

Question

我有一个网页，显示数据库中的信息表，每个 td 都有 id 和名称，并附加一个递增的数字。

while ($x <= $master_rows) {
if (isset($_POST["delete".$x])) {
    echo "test1".$_POST["price".$x]." ";
    $master_foodlist_delete = "DELETE FROM assig2_foodlist WHERE name=".$_POST["name".$x]."";
    $master_foodlist_delete_result=$mysqli->query($master_foodlist_delete);
    header("Location: ./masterlist.php");
}
$x++;
}

以及页面上对应的HTML(通过php生成后):

<form method="POST" name="master_submit_food">
<table id="master_foodlist">
    ...
    <tbody>
    <tr><td class="col1"><input class="col1" id="name1" name="name1" value="test" readonly=""></td>
    <td class="col2"><input class="col2" id="price1" name="price1" value="9.99"></td>
    <td class="col3"><input class="col3" id="lazenbys1" name="lazenbys1" type="checkbox" checked=""></td>
    <td class="col3"><input class="col3" id="theref1" name="theref1" type="checkbox" checked=""></td>
    <td class="col3"><input class="col3" id="tradetable1" name="tradetable1" type="checkbox" checked=""></td>
    <td class="col3"><input class="col3" id="thewalk1" name="thewalk1" type="checkbox" checked=""></td>
    <td class="col3"><input class="col3" id="thegrove1" name="thegrove1" type="checkbox" checked=""></td>
    <td class="col4"><input type="submit" class="col4" id="delete1" name="delete1" value="delete"></td></tr>
    ....
    </tbody></table>
<input id="submit" name="submit" type="submit" class="button" value="Submit">
</form>

基本上，我想单击“删除”，它会获取项目的名称并将其从数据库中删除。我有一个提交按钮来编辑整个表格，该按钮目前也不起作用，但它位于同一表单内，所以我认为这些问题可能是有关联的？

Answer 1

循环中的重定向导致第一个 DELETE 查询中的页面更改，在 while 之后移动此代码:

while ($x <= $master_rows) {
    if (isset($_POST["delete".$x])) {
        echo "test1".$_POST["price".$x]." ";
        $master_foodlist_delete = "DELETE FROM assig2_foodlist WHERE name=".$_POST["name".$x]."";
        $master_foodlist_delete_result=$mysqli->query($master_foodlist_delete);
    }
    $x++;
}
header("Location: ./masterlist.php");