我想在每个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']);
希望这可以帮助。