Home > Backend Development > PHP Problem > Detailed explanation of how to use PHP to delete table data

Detailed explanation of how to use PHP to delete table data

PHPz
Release: 2023-04-04 12:34:01
Original
576 people have browsed it

Tables are a commonly used way to display data on web pages, and PHP is a programming language widely used in web development. In web applications, we often need to present data through tables, and we also need to provide corresponding operations, such as addition, deletion, modification, and query.

This article will introduce in detail how to use the table deletion function in PHP, allowing you to easily implement the deletion function of table data in web applications.

1. Basic process of table deletion

Table deletion generally consists of the following steps:

  1. Get the identifier of the deleted data, that is, the row to be deleted Or the ID of the column;
  2. Delete the corresponding data from the database through PHP code;
  3. Refresh the page so that the user can see the deleted results.

This article will introduce these steps in detail.

2. Obtain the identifier of the deleted data

Before implementing the table deletion function, we need to first understand how to obtain the identifier of the data to be deleted.

In a table, there is usually one column as the primary key (ID), which represents the unique identifier of each row. Therefore, when we want to delete the data of a certain row, we only need to get the ID of the row. You can use the following code to obtain the ID:

$id = $_POST['id'];
Copy after login

Among them, $_POST['id'] means obtaining the ID from the submitted form. The specific form writing method is introduced in the next section.

3. PHP code to implement table deletion function

Next, we need to write PHP code to delete the corresponding data from the database.

  1. Connect to the database

First, we need to connect to the database. You can use the following code to connect:

$dsn = "mysql:host=localhost;dbname=test;charset=utf8";
$username = "root";
$password = "123456";
$conn = new PDO($dsn, $username, $password);
Copy after login

Where, $dsn represents the connection string of the MySQL database. $username and $password are the database login account and password.

  1. Writing deletion code

After obtaining the ID of the row to be deleted, we can delete the corresponding data in the database based on the ID. You can use the following code to delete data:

$sql = "DELETE FROM table_name WHERE id = ?";
$sth = $conn->prepare($sql);
$sth->execute(array($id));
Copy after login

The table_name here represents the table name of the data to be deleted, id represents the primary key, and $id represents the ID of the data to be deleted.

  1. Refresh the page

Finally, we need to refresh the page so the user can see the results that have been removed. You can use the following code to refresh the page:

header('Location: table.php');
Copy after login

Where, table.php is the page to be refreshed.

4. Write the code to delete the table

After completing the above operations, we need to combine the table and delete operations. Specifically, we need to add a delete button to the table and when the button is clicked, get the ID of the data to be deleted and delete the data from the database through PHP code.

The following is a simple HTML table code, which includes a delete button. It should be noted that each button contains a hidden type input used to pass the ID of the data to be deleted.

<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Action</th>
        </tr>
    </thead>
    <tbody>
        <?php
        // 从数据库中获取数据
        $sql = "SELECT * FROM table_name";
        $sth = $conn->prepare($sql);
        $sth->execute();

        // 遍历展示数据
        while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
            ?>
            <tr>
                <td><?php echo $row[&#39;id&#39;]; ?></td>
                <td><?php echo $row[&#39;name&#39;]; ?></td>
                <td>
                    <form action="delete.php" method="post">
                        <input type="hidden" name="id" value="<?php echo $row[&#39;id&#39;]; ?>">
                        <button type="submit">Delete</button>
                    </form>
                </td>
            </tr>
            <?php
        }
        ?>
    </tbody>
</table>
Copy after login

Among them, delete.php is the form submission address, and $row['id'] represents the ID of each row of data.

5. Summary

Through the above steps, we can easily implement the PHP table deletion function. Just simply get the identifier of the data you want to delete and use PHP code to delete the data from the database. At the same time, adding a delete button to the table allows users to easily complete data deletion operations.

The above is the detailed content of Detailed explanation of how to use PHP to delete table data. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template