PHP复选框多删除 [英] PHP Checkbox Multiple Delete
本文介绍了PHP复选框多删除的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我的实现似乎不工作。你能指出什么可能是问题或指向我一个更好的解决方案？当我检查复选框，并单击删除按钮，它似乎没有做任何事情...请帮助我。
My implementation doesn't seem to work. Can you point out what might be the problem or point me to a better solution? When I check the checkboxes and click the delete button, it doesn't seem to do anything... please help me.
<div id="container" class="page">
<img id="disclaimer" class="page" src="images/DISCLAIMER.png" alt="" />
<img id="logo" class="page" src="images/MI-LOGO.png" alt="" />
<div id="postItDiv" class="page">
<?php
$cxn = mysqli_connect('localhost', 'root', 'root', 'TimePost') or die(mysqli_error());
$query = "SELECT PostID, ClientName, VideoName, PostTime, Post, Date FROM tblTimePosts";
$result = mysqli_query($cxn, $query) or die(mysqli_error());
while($row = mysqli_fetch_assoc($result)) {
$post = $row['Post'];
$time = $row['PostTime'];
$idNo = $row['PostID'];
$postColor = rand(1, 4);
echo '<div id="post1"><p class="postParagraph">Post ID No.' . $idNo . '<br />' . $post . ' at ' . $time . ' seconds mark</p><div class="close"><form method="POST" action="videoJudge.php"><input type="checkbox" name="checkbox[]" id="checkbox[]" value="' . $idNo . '" /></form></div></div>';
}
if($_SERVER['REQUEST_METHOD'] == "POST" && $_POST['btnPost']) {
$postColors = rand(1, 4);
$toPost = $_POST['textPost'];
$date = date("y-m-d");
$postTime = $_POST['display'];
$postTime = floor($postTime);
$insertPostQuery = "INSERT INTO tblTimePosts VALUES('','Mimagazine Asia','Chelsea','$postTime','$toPost','$date')";
$query3 = "SELECT PostID FROM tblTimePosts";
$result = mysqli_query($cxn, $insertPostQuery) or die(mysqli_error());
$result3 = mysqli_query($cxn, $query3) or die(mysqli_error());
if($result > 0) {
while($row = mysqli_fetch_assoc($result3)) {
$idNo2 = $row['PostID'];
}
echo '<div id="post1"><p class="postParagraph">Post ID No.' . $idNo2 . '<br />' . $toPost . ' at ' . $postTime . ' seconds mark</p><div class="close"><form method="POST" action="videoJudge.php"><input type="checkbox" name="checkbox[]" id="checkbox[]" value="' . $idNo2 . '" /></form></div></div>';
}
else
echo "Add Failed";
}
/* if($_POST['chkDelete']) {
for($i=0;$i<5;$i++){
$del_id = $checkDelete[$i];
$sql = "DELETE FROM $tblTimePosts WHERE PostID='$del_id'";
$resulta = mysqli_query($cxn,$sql);
}
} */
if($_POST['btnDelete']) { // from button name="delete"
/* $checkbox = $_POST['checkbox']; //from name="checkbox[]"
$countCheck = count($_POST['checkbox']);
echo $countCheck;
for($i=0;$i<$countCheck;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM tblTimePosts WHERE PostID=".$del_id."";
$resulta = mysqli_query($cxn,$sql) or die(mysqli_error());
} */
$tbl_name = 'tblTimePosts';
foreach($_POST['checkbox'] as $id => $value) {
$sql = 'DELETE FROM `' . $tbl_name . '` WHERE `PostID`=' . (int) $id;
mysqli_query($cxn, $sql);
}
header('Location: videoJudge.php');
}
?>
</div>
<div id="videoContainer" class="page">
<video id="video" poster="images/cover.png" controls>
<source src="video/animationTest.m4v" />
</video>
</div>
<div id="etc" class="page">
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
<textarea name="textPost" id="textPost">
</textarea>
<input type="submit" name="btnPost" id="btnPost" value="Post" />
<div id="tae">
<input type="text" name="display" id="display" value="0" />
</div>
</form>
</div>
<div id="delButtonDiv">
<form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
<input type="submit" value="Delete" name="btnDelete" />
</form>
</div>
</div>
这里是我的代码现在下面你所有的评论，但仍然工作。 ：
HERE IS MY CODE NOW AFTER FOLLOWING ALL YOUR COMMENTS BUT STILL DIDNT WORK. :(
<?php
$cxn = mysqli_connect('localhost','root','root','TimePost') or die(mysqli_error());
$query = "SELECT PostID, ClientName, VideoName, PostTime, Post, Date FROM tblTimePosts";
$result = mysqli_query($cxn,$query) or die(mysqli_error());
while($row = mysqli_fetch_assoc($result)) {
$post = $row['Post'];
$time = $row['PostTime'];
$idNo = $row['PostID'];
$postColor = rand(1,4);
echo '<div id="post1"><p class="postParagraph">Post ID No.'.$idNo.'<br />'.$post.' at '.$time.' seconds mark</p><div class="close"><form method="POST" action="videoJudge.php"><input type="checkbox" name="checkbox[]" id="checkbox[]" value="'.$idNo.'" /></form>
</div></div>';
}
if ($_SERVER['REQUEST_METHOD'] == "POST" && $_POST['btnPost']) {
$toPost = $_POST['textPost'];
$date = date("y-m-d");
$postTime = $_POST['display'];
$postTime = floor($postTime);
$insertPostQuery = "INSERT INTO tblTimePosts VALUES('','Mimagazine Asia','Chelsea','$postTime','$toPost','$date')";
$query3 = "SELECT PostID FROM tblTimePosts";
$result = mysqli_query($cxn, $insertPostQuery) or die(mysqli_error());
$result3 = mysqli_query($cxn, $query3) or die(mysqli_error());
if ($result > 0) {
while($row = mysqli_fetch_assoc($result3)) {
$idNo2 = $row['PostID'];
}
echo '<div id="post1"><p class="postParagraph">Post ID No.'.$idNo2.'<br />'.$toPost.' at '.$postTime.' seconds mark</p><div class="close"><form method="POST" action="videoJudge.php"><input type="checkbox" name="checkbox[]" id="checkbox[]" value="'.$idNo2.'"
/></form></div></div>';
}
else
echo "Add Failed";
}
if($_POST['btnDelete'] == "Delete")
{
$tbl_name = 'tblTimePosts';
foreach ($_POST['checkbox'] as $id => $value)
{
$sql = 'DELETE FROM `'.$tbl_name.'` WHERE `PostID`='.(int)$id;
mysqli_query($cxn,$sql);
}
header('Location: videoJudge.php');
}
?>
</div>
<div id="videoContainer" class="page">
<video id="video" poster="images/cover.png" controls>
<source src="video/animationTest.m4v" />
</video>
</div>
<div id="etc" class="page">
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="POST">
<textarea name="textPost" id="textPost">
</textarea>
<input type="submit" name="btnPost" id="btnPost" value="Post" />
<div id="tae">
<input type="text" name="display" id="display" value="0" />
</div>
<div id="delButtonDiv">
<input type="submit" value="Delete" name="btnDelete" />
</div>
</form>
</div>
推荐答案
这样做可以解决问题， p>
Doing this should solve the problem, try:
<div id="etc" class="page">
<form action="<?php $_SERVER['PHP_SELF']?>" method="POST">
<textarea name="textPost" id="textPost"></textarea>
<input type="submit" name="btnPost" id="btnPost" value="Post" />
<div id="tae">
<input type="text" name="display" id="display" value="0" />
</div>
<!-- END FORM REMOVED HERE -->
<!-- FORM REMOVED HERE -->
<div id="delButtonDiv"> <input type="submit" value="Delete" name="btnDelete" /> </div>
</form>
</div>
提交按钮，然后你需要知道你正在采取什么行动，POST或DELETE，对吧？那么你可以在你自己的php脚本中创建一个基本的控制器到你的文章，例如：
You have two submit button in your form, then you need to know what exactly action you are taking, POST or DELETE, right? then you can create an basic controller to your post in your own php script, something like this:
这里是form - > < form action =<？php $ _SERVER ['PHP_SELF']？> method =POST>
Here is the form -> <form action="<?php $_SERVER['PHP_SELF']?>" method="POST">
，这里是提交按钮
<input type="submit" name="btnPost" id="btnPost" value="Post" />
<input type="submit" value="Delete" name="btnDelete" />
$ _ SERVER ['PHP_SELF'] 你会将表单数据发送到自己，如果是这样，然后在你的脚本开始执行这样的事情：
$_SERVER['PHP_SELF'] tells you that it will send the form data to itself, if so, then do something like this in the begin of your script:
if ($_POST[btnPost] == "Post")
// do some action to post the data
if ($_POST[btnDelete] == "Delete")
// do some action to delete the data
立即清除？
这篇关于PHP复选框多删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
