我有這個(gè)代碼<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>我應(yīng)該創(chuàng)建action="inc/delete.php"腳本，允許我使用復(fù)選框和提交按鈕刪除多行。有人可以幫我解決這個(gè)問(wèn)題嗎？老實(shí)說(shuō)，我不知道如何完成這個(gè)....
3 回答
滄海一幻覺(jué)
TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超5個(gè)贊
<?php
if(isset($_POST['submit']))
{
if(!empty($_POST['checkbox']))
{
foreach ($_POST['checkbox'] as $key => $check)
{
// delete query
}
}
}
?>
注意：您未能在第 1 行關(guān)閉 PHP。40. 請(qǐng)確認(rèn)您的 PHP 標(biāo)簽是否關(guān)閉。
白豬掌柜的
TA貢獻(xiàn)1893條經(jīng)驗(yàn) 獲得超10個(gè)贊
需要先將表單方法設(shè)置為“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貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超5個(gè)贊
所以解決方案是你得到你的idsdelete腳本array。您可以解析該數(shù)組并為每個(gè)執(zhí)行 DELETE 查詢(xún)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 關(guān)注
- 151 瀏覽
添加回答
舉報(bào)
0/150
提交
取消