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:
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'];
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.
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);
Where, $dsn represents the connection string of the MySQL database. $username and $password are the database login account and password.
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));
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.
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');
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['id']; ?></td> <td><?php echo $row['name']; ?></td> <td> <form action="delete.php" method="post"> <input type="hidden" name="id" value="<?php echo $row['id']; ?>"> <button type="submit">Delete</button> </form> </td> </tr> <?php } ?> </tbody> </table>
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!