php - 每行上回显的删除按钮

Question

每次用户插入信息并单击添加按钮时，新数据都会存储到数据库并回显到此表中

表格

<tr>
    <td colspan="4" align="right">
        <input  type="image" value="image"  src="images/btn_add.gif" onclick="action_1()">
    </td>
</tr>
<tr>
    <td colspan="2" class="title_all_u">Family Member Summary</td>
</tr>
<tr>
    <td>
        <?php 
            $query = "SELECT * FROM family_child WHERE LAS_login_id = ($emp_id)";
            $result = mysql_query($query) or die(mysql_error());
            echo "<table border='1'>
                    <tr>
                        <th>Family Type</th>
                        <th>Name</th>
                    </tr>";
                while($row = mysql_fetch_array($result))
                {
                echo "<tr>";
                echo "<td>" . $row['family_child_type'] . "</td>";
                echo "<td>" . $row['family_child_name'] . "</td>";
                echo "</tr>";
                }
            echo "</table>";
        ?>
    </td>           
</tr>   

这是插入查询

if ( $action ==3 ) {
   $spouse_type = $_POST['spouse_type'];
   $spouse_name = $_POST['spouse_name'];

   $sql1 = "INSERT INTO family_spouse (LAS_login_id, spouse_type, spouse_name)  VALUES ('$LAS_login_id', '".strtoupper($spouse_type)."','".strtoupper($spouse_name)."')";

这两个代码用于插入数据库并在页面中回显。如何在 echo "<td>" . $row['family_child_name'] . "</td>"; 下面添加删除按钮对于我回显的每一行，以便用户可以删除显示表中的错误行。

Answer 1

echo "<td>" . $row['family_child_name'] . " <a href='page.php&action=delete&id=family_name_id'>Delete</a></td>

然后在您的页面中 get (if action == delete) > 执行您的查询以删除 ID 为家庭子女姓名表 id 的行。