php - 使用 PHP 按钮删除单独的行/行

Question

我想做的是让一个 PHP 页面显示 MySQL 数据库的内容，并且它显示的每一行都给我一个删除按钮，这样我就可以删除单独的行。我的代码可以工作。该代码删除了代码行，但不是我选择的代码行，而是删除了最后一行，而不是我告诉它删除的代码行。

这是一个屏幕截图，我知道它看起来不太漂亮，我打算在代码运行后清理它。

HTML:

    <?php
        // Delete php code
        if(isset($_POST['delete_series']))
        {
            // here comes your delete query: use $_POST['deleteItem'] as your id
            $delete = $_POST['delete_series'];
            $delete_sql = "DELETE FROM `Dropdown_Series` where `id` = '$delete'"; 

            if(mysql_query($delete_sql, $conn))
            {
                echo "Row Deleted </br>";
                echo "$delete";

            };
        }

        //Insert Code
        if(isset($_POST['add_series']))
        {           
            $insert_sql = "INSERT INTO dropdown_series (series) VALUES ('$_POST[add_series]' )";

            if(!mysql_query($insert_sql, $conn))
                {
                    die ('Error: ' . mysql_error());
                } 

            echo "Series Added <br><br>";

        }

    ?>
    <br />
    <h1>Add New Series Title</h1>

    <h3>Add New: </h3><br />

    <form name = action="add_series.php" method="POST">

    <input type = "text" name = "add_series" required/><br /><br />
    <input type ="submit" name="submit" value="Add">

    </form>

    <h3>Current Series: </h3><br />


    <?php
            //Delete button on each result of the rows
            $query = mysql_query("SELECT id, series FROM Dropdown_Series");     // Run your query

            // Loop through the query results, outputing the options one by one
            echo "<form action='' method='POST'>";
            while ($row = mysql_fetch_array($query)) 
            {

                echo $row['series'] . " ";
                echo $row['id'];
                echo "<input type='hidden' name='delete_series' value=' " . $row['id'] . "' />";
                echo "<input type='submit' name='submit' value='Delete'>";
                //echo $row['series'] . " ". $row['id'] . "<input type='submit' value='delete'>";
                echo "<br />";

            } 

        echo "</form>";
    ?>

Answer 1

您的循环将导致在同一表单内产生多个delete_series 输入。

您可以为每个选项创建单独的表单:

while ($row = mysql_fetch_array($query)) 
{
  echo "<form action='' method='POST'>";
  // ...
  echo "<input type='hidden' name='delete_series' value=' " . $row['id'] . "' />";
  echo "<input type='submit' name='submit' value='Delete'>";
  // ...
  echo "</form>";
}