php - 单击时无法弄清楚如何处理删除按钮

Question

我正在尝试在我的项目表上添加一个“删除”按钮，并有一个删除按钮来删除该项目以及有关这两个项目和卖家的信息。我在 table 上有删除按钮，但我无法弄清楚单击该按钮时如何处理该按钮。请帮忙!提前致谢!!

    <?php
    require 'authentication.inc';

    // connect to the server
    $connection = sqlsrv_connect( $hostName, $connectionInfo )
        or die("ERROR: selecting database server failed");

    // prepare SQL query
    $UserID = $_SESSION['userID'];
    $query = "SELECT * FROM ITEM WHERE userID= '$UserID'";


    // Execute SQL query
    $query_result = sqlsrv_query($connection, $query)
        or die( "ERROR: Query is wrong");

    // Output query results: HTML table
    echo "<table border=1>";
    echo "<tr>";

    // fetch attribute names
    foreach( sqlsrv_field_metadata($query_result) as $fieldMetadata)
        echo "<th>".$fieldMetadata['Name']."</th>";
    echo "</tr>";

    // fetch table records
    while ($line = sqlsrv_fetch_array($query_result, SQLSRV_FETCH_ASSOC)) {
        echo "<tr>\n";

        foreach ($line as $cell) {
            echo "<td> $cell </td>";
        }
        echo "<td></td>";
        echo "</tr>\n";
    }
    echo "</table>";

    // close the connection with database
    sqlsrv_close($connection);
?>

Answer 1

要添加删除功能，您需要两件事，一个是按钮，其次是对所述按钮的处理。我不确定表中的唯一值是什么，所以我使用了这个虚构的键:itemID。使用您的唯一列名称进行更新。

将您的表格循环替换为:

<table border=1>
    <tr>
<?php
    // fetch attribute names
    foreach( sqlsrv_field_metadata($query_result) as $fieldMetadata)
        echo "<th>".$fieldMetadata['Name']."</th>"; ?>
        </tr>
<?php
    // fetch table records
    while ($line = sqlsrv_fetch_array($query_result, SQLSRV_FETCH_ASSOC)) { ?>
        <tr>
<?php   foreach ($line as $cell) {
            echo "<td> $cell </td>";
        } ?>
            <td>
                <form method="post">
                    <input type="hidden" name="itemID" value="<?php echo $line['itemID']; ?>" />
                    <input type="submit" name="action" value="DELETE" />
                </form>
            </td>
        </tr>
<?php } ?>
</table>

在顶部的处理部分，添加处理:

if(!empty($_POST['action']) && ($_POST['action'] == 'DELETE')) {
        // Do some sort of validation here
        if(is_numeric($_POST['itemID']))
            sqlsrv_query($connection, "delete from ITEM where itemID = '".$_POST['itemID']."'");
    }