我有這個代碼<html><head> <meta charset="UTF-8"> <title> Game Library</title> <link href="css/style.css" type="text/css" rel="stylesheet"></head><body> <div id="wrapper"><div id="search"> <img id="del" src="img/delete.jpg" alt="Error"> <a class="A" href="index.php"><img class="AR" src="img/src.jpg" title="Search library"></a> <a class="A" href="insert.php"><img class="AR" src="img/add.png" title="Add game"></a> <div id="results"> <?php require("inc/connection.php");$query = "SELECT * FROM Library";$result = mysqli_query($conn,$query); if(mysqli_num_rows($result)>0){ while($row = mysqli_fetch_assoc($result)){ ?><div id="results"> <form action="inc/delete.php" method="GET"> <input type="checkbox" name="checkbox[]" value="<?php echo $row['ID'] ?>"> <p id="p1">Name: <?php echo $row['Name']?>;</p> <p>Genre: <?php echo $row['Genre']?></p> <p>Release date: <?php echo $row['Release_date']?></p> <p>Publisher: <?php echo $row['Publisher']?>:</p> <p>Platforms: <?php echo $row['Platforms']?></p> </div> <?php }?> <input type="submit" name = "submit" value = "Submit"></form> <?php}else{ echo "No results!"; } </div> </div></div></body></html>我應該創建action="inc/delete.php"腳本，允許我使用復選框和提交按鈕刪除多行。有人可以幫我解決這個問題嗎？老實說，我不知道如何完成這個....
3 回答
滄海一幻覺
TA貢獻1824條經驗 獲得超5個贊
<?php
if(isset($_POST['submit']))
{
if(!empty($_POST['checkbox']))
{
foreach ($_POST['checkbox'] as $key => $check)
{
// delete query
}
}
}
?>
注意：您未能在第 1 行關閉 PHP。40. 請確認您的 PHP 標簽是否關閉。
白豬掌柜的
TA貢獻1893條經驗 獲得超10個贊
需要先將表單方法設置為“POST”
所以，修改
<form action="inc/delete.php" method="GET">
至：
<form action="inc/delete.php" method="post">
而在inc/delete.php,
if (isset($_POST['submit'])){ // Check if form is submitted.
if (! empty($_POST['checkbox'])){ // Check if Checkbox is checked.
// Loop over the checkbox and get selected ids.
foreach($_POST['checkbox'] as $checkbox_id){
echo $checkbox_id."<br/>";
// Add your delete query here.
}
}
}
一只甜甜圈
TA貢獻1836條經驗 獲得超5個贊
所以解決方案是你得到你的idsdelete腳本array。您可以解析該數組并為每個執行 DELETE 查詢id：
if(isset($_POST['checkbox']))
{
foreach($_POST['checkbox'] as $val)
{
$stmt = $conn->prepare("DELETE FROM Library WHERE id = ?");
$stmt->bind_param('i', $val);
$stmt->execute();
}
}
- 3 回答
- 0 關注
- 152 瀏覽
添加回答
舉報
0/150
提交
取消