php - 我如何删除php中的孔行?
问题描述
我必须按一个按钮来显示每个订单的信息,一个按钮可以在发货后删除订单。我怎样才能使删除按钮起作用。因为“查看顺序有效,但删除顺序无效。我需要使用按钮单独删除每一行。
<?php
require_once 'dbconnection.php';
$sql = "SELECT * from Orders";
$result = mysqli_query($conn, $sql);
if ($result -> num_rows > 0){
while ($row = $result-> fetch_assoc()){
echo "<tr><td>". $row["name"] ."</td><td>". $row["student_id"] ."</td><td>". $row["ordr_num"]
."</td><td><button class='btn btn-small' id='{$row["ordr_num"]}'>View Order</button></td>
<td><button class='btn btn-small'}'>Delete</button></td></tr>";
}
}
else{
echo "0 result";
}
我需要能够单独删除每一行,但我真的不知道如何。我尝试在 if 之前运行删除脚本,但它不起作用。
解决方案
我将假设您正在学习 PHP,因为您开发它的方式是一种不好的做法。所以,我会给你一个解决你的要求。
<?php
require_once 'dbconnection.php';
if(isset($_GET['idDelete'])){
$resultDelete = mysqli_query($conn, "DELETE FROM Orders WHERE ordr_num = " . $_GET['idDelete']);
if($resultDelete->affected_rows > 0){
echo "Order # " . $_GET['idDelete'] . " has been deleted";
}else{
echo "Order # " . $_GET['idDelete'] . " couldn't be deleted.";
}
}
$sql = "SELECT * from Orders";
$result = mysqli_query($conn, $sql);
if ($result -> num_rows > 0){
while ($row = $result-> fetch_assoc()){
echo "<tr>
<td>". $row["name"] ."</td>
<td>". $row["student_id"] ."</td>
<td>". $row["ordr_num"]."</td>
<td><button class='btn btn-small' id='" . $row["ordr_num"] ."'>View Order</button></td>
<td><a href='?idDelete=".$row["ordr_num"]."' class='btn btn-small'>Delete</a></td>
</tr>";
}
}
else{
echo "0 result";
}
?>
推荐阅读
- python - How to retrieve list of tasks in a queue in Celery?
- heroku - How do I host a discord.py bot that is using lavalink on heroku
- ssas-tabular - Data in server is not in tabular cube
- javascript - How come this arrow function has no initialiser? Is this syntax React exclusive?
- javascript - 如何在 JSON 对象中的第二个项目上映射()
- python - Python - UserWarning messages loading WSDL into Zeep client
- c - UDF not appearing in Ansys Fluent
- r - 基于另一个约束数字字符串的变量创建新变量?
- java - 是否可以将 ARCORE 与 CameraX 一起使用?
- jenkins - Jenkins:可编辑电子邮件通知的触发器类型说明