初学者：从表和数据库PHP / HTML / MySQL中删除行

debugcn 发表于 Dev

琼蒂

完成PHP / MySQL和HTML的新手，所以如果我不能正确解释自己的话，请忍受我。目前，我有一个订单，该订单将订单存储在数据库中，并在管理区域的表中显示。完成订单后，我希望能够从表和数据库中删除该行。

目前，我的代码如下所示：

<?php
//87229feely.php
include('connection.php');
$result = mysql_query("SELECT * FROM orderform");
echo "<table border='1' >
<tr>
<th><u>ID</th>
<th><u>Date</th>
<th><u>Product</th>
<th><u>Product Comments</th>
<th><u>Name</th>
<th><u>Address</th>
<th><u>Age</th>
<th><u>Delivery</th>
<th><u>Delete</th>

</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id']. "</td>";
echo "<td>" . $row['date'] . "</td>";
echo "<td>" . $row['product'] . "</td>";
echo "<td>" . $row['productcomments'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['address'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['delivery'] . "</td>";
echo "<td><a href=\"deleterow.php?id=".$row['id']."\">delete</a></td>";

echo "</tr>";
}
echo "</table>";
?>

    <?php
//deleterow.php
    include('connection.php');
    $id = $_GET['id']; //this needs to be sanitized 
    if(!empty($id)){
        $result = mysql_query("DELETE FROM orderform WHERE id=".$id.";");
    }
    header("Location: 87229feely.php");
    ?>

有什么帮助吗？所有人都表示赞赏。谢谢

庞斯

此答案不符合安全性标准，但应执行以下操作：

<?php
//index.php
include('connection.php');
$result = mysql_query("SELECT * FROM orderform");
echo "<table border='1' >
<tr>
<th><u>ID</th>
<th><u>Date</th>
<th><u>Product</th>
<th><u>Product Comments</th>
<th><u>Name</th>
<th><u>Address</th>
<th><u>Age</th>
<th><u>Delivery</th>
<th><u>Delete</th>

</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id']. "</td>";
echo "<td>" . $row['date'] . "</td>";
echo "<td>" . $row['product'] . "</td>";
echo "<td>" . $row['productcomments'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['address'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['delivery'] . "</td>";
echo "<td><a href=\"delete.php?id=".$row['id']."\">delete</a></td>";

echo "</tr>";
}
echo "</table>";
?>

<?php
//delete.php
include('connection.php');
$id = $_GET['id']; //this needs to be sanitized 
if(!empty($id)){
    $result = mysql_query("DELETE FROM orderform WHERE id=".$id.";");
}
header("Location: index.php");
?>

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。