How to delete lists in batches in php

php method to delete lists in batches: 1. Connect to the database; 2. Write an HTML form for users to select the data to be deleted. The form usually contains a checkbox for selecting the data rows to be deleted; 3. A PHP script needs to be written to handle the form submission and perform the deletion operation; 4. The database connection needs to be closed. In PHP, you can use the `$conn->close()` method to close the connection.

The operating environment of this tutorial: windows10 system, php8.1.3 version, DELL G3 computer.

PHP is a widely used server-side scripting language for developing dynamic web pages and web applications. During the development process, it is often necessary to perform operations on the list, including batch deletion. This article will introduce how to use PHP to delete data in a list in batches.

1. To delete lists in batches, you first need to connect to the database. Assuming we are using a MySQL database, we can use PHP's MySQLi extension or PDO extension to connect to the database. The following is a sample code that uses the MySQLi extension to connect to the database:

$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "mydatabase";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接是否成功
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
?>

2. After connecting to the database, we need to write an HTML form for the user to select the data to be deleted. The form usually contains a checkbox for selecting rows of data to be deleted. The following is a simple HTML form example:

<form action="delete.php" method="post">
    <table>
        <tr>
            <th>选择</th>
            <th>数据</th>
        </tr>
        <tr>
            <td><input type="checkbox" name="ids[]" value="1"></td>
            <td>数据1</td>
        </tr>
        <tr>
            <td><input type="checkbox" name="ids[]" value="2"></td>
            <td>数据2</td>
        </tr>
        <tr>
            <td><input type="checkbox" name="ids[]" value="3"></td>
            <td>数据3</td>
        </tr>
    </table>
    <input type="submit" value="删除选中数据">
</form>

In the form, we use a checkbox array named `ids[]` to store the ID of the data row selected by the user . When the user submits the form, the selected ID value will be passed to the server-side PHP script.

3. Next, we need to write a PHP script to handle form submission and perform deletion operations. Here is a simple delete script example:

// 检查是否有选择的数据行
if(isset($_POST['ids'])){
// 循环遍历选中的ID值
foreach($_POST['ids'] as $id){
// 使用SQL语句删除对应的数据行
$sql = "DELETE FROM mytable WHERE id = $id";
if ($conn->query($sql) === TRUE) {
echo "数据删除成功";
} else {
echo "数据删除失败: " . $conn->error;
}
}
}
?>

In the above code, we first check if there is a selected data row. If there is, we use a loop to traverse the selected ID value and use a SQL statement to perform the delete operation. The delete operation uses a table named `mytable`, which contains a column named `id`, which is used to store the unique identifier of the data row.

4. Finally, we need to close the database connection. In PHP, you can use the `$conn->close()` method to close the connection. The complete code is as follows:

// 连接到数据库的代码
// 处理表单提交的代码
// 关闭数据库连接
$conn->close();
?>

Through the above steps, we can use PHP to delete data in the list in batches. When the user selects the data row to be deleted and submits the form, the PHP script will perform the deletion operation and return the corresponding results. In this way, we can easily manage and operate the data in the list .

The above is the detailed content of How to delete lists in batches in php. For more information, please follow other related articles on the PHP Chinese website!