How to Implement a Delete Option for MySQL Table Rows in PHP Forms?

Adding a Delete Option to PHP Forms for MySQL Table Rows

The problem arises when displaying MySQL table results in an HTML table and adding a delete option to remove a user from the table. Here's a guide to resolve this issue:

You have a form that outputs the results of a MySQL table to an HTML table. In the last column, you want to add a delete option that calls another form and deletes the user from the table. However, it's not working as intended.

The issue is that you need to pass a variable in the delete link. Specifically, you need to pass the name value from the results in a hidden field or pass it in the URL.

Replace

<code class="php"><td class="contact-delete">
  <form action='delete.php' method="post">
    <input type="hidden" name="name" value="">
    <input type="submit" name="submit" value="Delete">
  </form>
</td></code>

With

<code class="php"><td class="contact-delete">
    <form action='delete.php?name="<?php echo $contact['name']; ?>"' method="post">
        <input type="hidden" name="name" value="<?php echo $contact['name']; ?>">
        <input type="submit" name="submit" value="Delete">
    </form>
</td></code>

Now, when the delete button is clicked, the value of the hidden input field is submitted to the 'delete.php' script, allowing you to identify and delete the correct user from the table.

The above is the detailed content of How to Implement a Delete Option for MySQL Table Rows in PHP Forms?. For more information, please follow other related articles on the PHP Chinese website!