我有一个while循环来显示表中的数据库列和行。
我想做一个按钮,可以删除特定的mysql行,但不幸的是,我不能选择所有行中的哪些必须删除,因为我使用“while循环”以html显示我的数据库内容。
<?php
$db=mysqli_connect("localhost","root","root","done");
if(isset($_POST['deletesubmit'])){
$deleteId=$_POST['deleteId'];
$query3="DELETE FROM dones WHERE id=deleteId";
$result3=mysqli_query($db,$query);
}
?>
<?php
$query="SELECT * FROM dones where id>3";
$result1=mysqli_query($db,$query);
while($row=mysqli_fetch_array($result1))
{
echo '<div class="accordion" id="accordionExample">';
echo '<div class="card" style="margin-left:10px; margin-right:10px;">';
echo '<div class="card-header">';
echo '<h5 class="mb-0">';
echo '<form action="" method="POST" enctype="multipart/form-data"
style="height:430px;">';
echo '<button class="btn btn-link" style="text-decoration:none; font-
family:Times New Roman, Times, serif; font-size:18px; " type="button"
data-toggle="collapse" data-target="#collapseOne" aria-expanded="true"
aria-controls="collapseOne">';
echo $row['title'];
echo '</button>';
echo '</h5>';
echo '</div>';
echo '<div id="collapseOne" class="collapse show" aria-
labelledby="headingOne" data-parent="#accordionExample">';
echo '<div class="card-body">';
// Content Of new banner
echo '<h5 style="text-align:left; margin-left:20px; margin-top:20px;">
<small>Title</small></h5>';
echo '<input style="width:290px; margin-left:158px; height:30px; margin-
top:-30px;" name="title" type="text" class="form-control"
placeholder="Title">';
echo ' <br>';
echo ' <div class="custom-file" style="height:10px; width:290px; margin-
right:1050px; top-padding:20px; float:right;">';
echo ' <input type="file" name="uploadfile" class="custom-file-input"
id="validatedCustomFile">';
echo ' <label class="custom-file-label" for="validatedCustomFile">Choose
file...</label>';
echo ' </div>';
echo ' <h5 style="text-align:left; margin-left:20px;"><small>File</small>
</h5>';
echo ' <br>';
echo ' <h5 style="text-align:left; margin-left:20px;"><small>Banner
Image</small></h5>';
echo ' <div style="height:130px; width:290px; border-width:1px; border-
style:solid; float:right; margin-right:1050px; margin-top:-15px;">';
$sql="SELECT image FROM dones where status=1";
$result=mysqli_query($db,$sql);
$data = mysqli_fetch_array($result);
echo '<img src= "images/'.$data['image'].'" style="height:130px;
width:290px;">';
echo '</div>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<h5 style="text-align:left; margin-left:20px;">
<small>Status</small></h5>';
echo '<select name="status" id="" style="width:290px; float:right;
margin-right:1050px; margin-top:-25px;">';
echo '<option value="1" name="enable">Enable</option>';
echo '<option value="0" name="disable">Disable</option>';
echo '</select>';
echo '<br>';
echo '<br>';
echo '<button type="submit" name="tbsubmit" style="margin-left:250px;"
class="btn btn-primary">Save Changes</button>';
echo '<a name="deleteId" href="?deleteId=$row[keyID]"></a>';
echo '<button type="submit" name="deletesubmit" style="margin-
left:250px;" class="btn btn-primary">Delete Banner</button>';
echo '</div>';
echo '</form>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
}
?>
所以任何解决问题的办法。
暂无答案!
目前还没有任何答案,快来回答吧!