从 PHP while 循环中删除 MySQL 行

提供图片以更好地理解我想做什么:是的，我希望在点击绿色按钮时发送 MySQL 查询以删除该行(存在于我的数据库中).提供代码:query($sql);如果 ($result->num_rows > 0){//表格标题 - 不是 PHPecho "<tr><th style='background-color: #2d323a;颜色:白色；'>日期</th><th style='background-color: #2d323a;颜色:白色；'>数量<th style='background-color: #2d323a;颜色:白色；'>原因</th></tr>";//输出每一行的数据while($row = $result->fetch_assoc()){//RED//如果有"- "，则将金额声明为红色if(strpos($row['amount'],'-') !== false){回声"<tr><th style='font-weight: normal;background-color: #ff9999;'class='row-time'>" . $row['time'] . "</th><th style='font-weight: normal;background-color: #ff9999;'class='row-amount'>" . $row['amount'] . "</th><th style='font-weight: normal;background-color: #ff9999;'class='row-reason'>" . $row['reason'] . "</th></tr>";}//NORMAL//如果没有"- "，则使金额声明正常别的{回声"<tr><th style='font-weight: normal;'class='row-time'>" . $row['time'] . "</th><th style='font-weight: normal;'class='row-amount'>" . $row['amount'] . "</th><th style='font-weight: normal;'class='row-reason'>" . $row['reason'] . "</th></tr>";}}echo "</table>";}别的{echo "0 结果";} 解决方案 首先，表头只使用 元素.对于实际的数据单元格，请使用 元素.要允许删除单个数据库行，您可以在表中包含链接.在创建表行的循环中: <td>" . $row['time'] . "</td><td>" . $row['amount'] . "</td><td>" . $row['reason'] . "</td><td><a href='?deleteId=$row[keyID]'>删除</a></td></tr>在这种情况下，选择删除"链接时，它将使用$ _get变量调用相同的脚本:您可以测试的dellesid"，您可以测试，如果找到，则执行删除行.您也可以将表格嵌入到html表单中，并在每行的单元格中添加一个提交按钮，提交的值设置为要删除的行id.I have a while loop displaying my database columns and rows in table. I want make a button which can delete specific MySQL row but unfortunately I can't select which of all rows have to be deleted simply because I use "while loop" to display my database content in HTML.Providing picture for better understanding what I want to do:So yeah, I want that when the green button is clicked - send MySQL query to delete this row (which is existing in my DB).Providing code:<?php//CONECT TO MYSQLinclude 'database.php';//GET VALUES $sql = "SELECT * FROM amountcontainer"; $result = $conn->query($sql); if ($result->num_rows > 0) { //Table headlines - NOT A PHP echo "<table class='moneytable'> <tr> <th style='background-color: #2d323a; color: white;'>Date</th> <th style='background-color: #2d323a; color: white;'>Amount</th> <th style='background-color: #2d323a; color: white;'>Reason</th> </tr>"; // output data of each row while($row = $result->fetch_assoc()) { //RED //Make statement of amount red if it has a " - " if(strpos($row['amount'],'-') !== false) { echo " <tr> <th style='font-weight: normal;background-color: #ff9999;' class='row-time'>" . $row['time'] . "</th> <th style='font-weight: normal;background-color: #ff9999;' class='row-amount'>" . $row['amount'] . "</th> <th style='font-weight: normal;background-color: #ff9999;' class='row-reason'>" . $row['reason'] . "</th> </tr> "; } //NORMAL //Make statement of amount normal if it doesn't have a " - " else { echo " <tr> <th style='font-weight: normal;' class='row-time'>" . $row['time'] . "</th> <th style='font-weight: normal;' class='row-amount'>" . $row['amount'] . "</th> <th style='font-weight: normal;' class='row-reason'>" . $row['reason'] . "</th> </tr> "; } } echo "</table>"; } else { echo "0 results"; } 解决方案 First, only use <th> elements for the table headers. For the actual data cells use the <td> element.To allow deletion of individual database rows you can include links in your table. In your loop that creates the table rows: <tr> <td>" . $row['time'] . "</td> <td>" . $row['amount'] . "</td> <td>" . $row['reason'] . "</td> <td><a href='?deleteId=$row[keyID]'>Delete</a></td> </tr>In this case, when the "Delete" link is selected it calls your same script with a $_GET variable: "deleteId" which you can test for and if found, perform the delete of the row. You can also embed the table in an html form and add a submit button to a cell in each row, with the value of the submit set to the row id to delete. 这篇关于从 PHP while 循环中删除 MySQL 行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！