Batch deletion of multi-select boxes in php

In Web development, checkbox is a common user interaction component. In some scenarios that require batch processing of data, we often use multi-select boxes to implement batch operations. In PHP, it is a very common requirement to implement batch deletion of multi-select boxes. This article will introduce how to use PHP to implement batch deletion of multi-select boxes.

1. HTML page design

Using multi-select boxes to achieve batch deletion requires adding multiple multi-select boxes to the HTML page and adding a "Delete" button at the same time. The following is a simple HTML page example, which uses the Bootstrap framework to beautify the page:

   <meta charset="UTF-8">
   <title>多选框批量删除</title>
   <link rel="stylesheet" href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.min.css">


   <div class="container mt-5">
       <h1 id="多选框批量删除">多选框批量删除</h1>
       <form method="post" action="delete.php">
           <div class="row">
               <div class="col-sm">
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="1">
                       <label class="form-check-label">选项1</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="2">
                       <label class="form-check-label">选项2</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="3">
                       <label class="form-check-label">选项3</label>
                   </div>
               </div>
               <div class="col-sm">
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="4">
                       <label class="form-check-label">选项4</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="5">
                       <label class="form-check-label">选项5</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="6">
                       <label class="form-check-label">选项6</label>
                   </div>
               </div>
           </div>
           <div class="mt-3">
               <button type="submit" class="btn btn-danger">删除选中项</button>
           </div>
       </form>
   </div>
   <script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
   <script src="https://cdn.bootcdn.net/ajax/libs/popper.js/2.9.3/umd/popper.min.js"></script>
   <script src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/js/bootstrap.min.js"></script>

This page contains 6 multi-select boxes and a "Delete selected item" button. The name attribute of each multi-select box is "ids[]", so when the user selects multiple options, we can use $_POST['ids'] to get the IDs of all selected items.

2. PHP implementation

In the HTML page, we set up a form form and designated the PHP file for processing the form as "delete.php". Let's take a look at how to handle form submission and implement batch deletion operations in the delete.php file.

First you need to get the value of the multi-select box selected by the user on the page (that is, the ID of the selected item). We can use $_POST['ids'] to get this value, where "ids" corresponds to the name attribute of the multi-select box in the HTML page.

$ids = $_POST['ids']; // 获取多选框选中项的ID值

Next, it is necessary to determine whether the user has selected the data item to be deleted and perform the deletion operation. Here we can delete the corresponding data one by one by traversing the ID of the selected item. Assume here that we have a students table, which contains three fields: id, name, and age. We need to delete all records whose id is in the selected item ID list.

if (!empty($ids)) {
   $dsn      = "mysql:host=localhost;dbname=test;charset=utf8";
   $username = "root";
   $password = "root";
   try {
       $pdo = new PDO($dsn, $username, $password);
   } catch (PDOException $e) {
       die("连接数据库失败：" . $e->getMessage());
   }
   $ids_str = implode(",", $ids); // 将选中项的ID值连接成逗号分隔的字符串
   $sql     = "DELETE FROM students WHERE id IN ($ids_str)"; // 生成删除语句
   $res     = $pdo->exec($sql); // 执行删除操作
   echo "成功删除 $res 条数据"; // 输出删除结果
}

In the above code, first determine whether the user has selected the data item to be deleted (that is, whether $_POST['ids'] is empty). If it is not empty, connect to the database and select it. The item's ID values ​​are concatenated into a comma-separated string using the implode() function. Then use the DELETE FROM...WHERE... statement to generate a delete statement, and use the ID value of the selected item as the WHERE condition to perform the delete operation. Finally, the deletion result is output.

3. Complete code

The above code snippet only implements the core part of the delete operation. The following is the complete delete.php code:

   <meta charset="UTF-8">
   <title>多选框批量删除</title>
   <link rel="stylesheet" href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.min.css">


   <div class="container mt-5">
       <h1 id="多选框批量删除">多选框批量删除</h1>
       <?php if (!empty($_POST)) {
           $ids = $_POST['ids'];
           if (!empty($ids)) {
               $dsn      = "mysql:host=localhost;dbname=test;charset=utf8";
               $username = "root";
               $password = "root";
               try {
                   $pdo = new PDO($dsn, $username, $password);
               } catch (PDOException $e) {
                   die("连接数据库失败：" . $e->getMessage());
               }
               $ids_str = implode(",", $ids);
               $sql     = "DELETE FROM students WHERE id IN ($ids_str)";
               $res     = $pdo->exec($sql);
               echo "<div class="alert alert-success">成功删除 $res 条数据</div>";
           } else {
               echo "<div class="alert alert-danger">请至少选择一条数据</div>";
           }
       }
       ?>
       <form method="post" action="">
           <div class="row">
               <div class="col-sm">
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="1">
                       <label class="form-check-label">选项1</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="2">
                       <label class="form-check-label">选项2</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="3">
                       <label class="form-check-label">选项3</label>
                   </div>
               </div>
               <div class="col-sm">
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="4">
                       <label class="form-check-label">选项4</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="5">
                       <label class="form-check-label">选项5</label>
                   </div>
                   <div class="form-check">
                       <input class="form-check-input" type="checkbox" name="ids[]" value="6">
                       <label class="form-check-label">选项6</label>
                   </div>
               </div>
           </div>
           <div class="mt-3">
               <button type="submit" class="btn btn-danger">删除选中项</button>
           </div>
       </form>
   </div>
   <script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
   <script src="https://cdn.bootcdn.net/ajax/libs/popper.js/2.9.3/umd/popper.min.js"></script>
   <script src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.6.0/js/bootstrap.min.js"></script>

This code is in HTML PHP code is embedded in the page to display the deletion results. At the same time, do not fill in the action attribute in the form, so that the form will be submitted to the current page, which facilitates us to process the data. When the user submits the form, the judgment logic in the PHP code will be executed first, and then the deletion operation will be executed. Finally, based on the execution results, the deletion results are displayed to the user.

4. Summary

It is common to use multi-select boxes to implement batch deletion operations in PHP, and it is a technology we often need to use in web development. In this article, we introduce how to use PHP to implement batch deletion of multi-select boxes and explain the specific implementation steps. I hope this article can provide some reference and help for beginners.

The above is the detailed content of Batch deletion of multi-select boxes in php. For more information, please follow other related articles on the PHP Chinese website!