我想在每个div中插入一个“删除”按钮,以便可以使用“删除”按钮删除数据库的行和div。

div的数量根据数据库中的行数而变化。

It should appear as follows,

显示数据效果很好。但是,删除(删除按钮)不起作用。

的PHP
    

    function deleteUser($connection, $userID){  //  this function calls within the "currentUsers" Function
        $sql2 = "DELETE FROM users_table WHERE user_id = '$userID' ";

        if (mysqli_query($connection, $sql2)) {
            header("Location: main.php");

        } else {
                echo "Error! ";
        }

    }


    function currentUsers($connection){
        $sql1 = "SELECT * FROM users_table ";
        $result1 = mysqli_query($connection, $sql1);

        if(mysqli_num_rows($result1) > 0){
            while($row = mysqli_fetch_assoc($result1)) {
                $userID = $row['user_id'];
                $name = $row['name'];
                $country = $row['country'];

                echo '<div>
                        <h3>'. $userID. " ". $name. " ". $country. '</h3>
                        <input type = "button" name = "removeButton" value = "Remove" method = "GET">
                     </div>';

                if (isset($_GET['removeButton'])) {
                    deleteUser($connection, $userID);
                }
            }
        }else{
            echo "Currently there are no users!";
        }

        mysqli_close($connection);
    }

    currentUsers($connection);


?>

最佳答案

删除按钮不起作用,因为您永远不会进入deleteUser()方法。

你不能写

<input type = "button" name = "removeButton" value = "Remove" method = "GET">


因为它在表格内。要触发它,请这样编写:

<form method="GET">
    <input type = "submit" name = "removeButton" value = "<?php echo $userID;?>">
</form>


然后,当打电话

deleteUser($connection, $_GET['removeButton']);


希望这可以帮助。

09-30 19:11
查看更多