表单与php混编2

最新推荐文章于 2021-06-22 18:28:50 发布

志男

最新推荐文章于 2021-06-22 18:28:50 发布

阅读量74

点赞数

分类专栏：表单 php 前端文章标签： php

本文链接：https://blog.csdn.net/qq_39612654/article/details/114107975

版权

php 同时被 3 个专栏收录

23 篇文章 0 订阅

订阅专栏

前端

15 篇文章 0 订阅

订阅专栏

表单

4 篇文章 0 订阅

订阅专栏

#查询邮件列表并批删除 foreach

<!DOCTYPE html>
<html lang="en">
<head>
   <meta charset="UTF-8">
   <title>remove email</title>
</head>
<body>
   <p>Please chose the email to remove</p>

   <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   <?php
       include 'dbc.php';
       //循环删除选择的id值
       if (isset($_POST['submit'])) {
           foreach ($_POST['todelete'] as $delete_id) {

               $query = "delete from emaillist where id = $delete_id";

               mysqli_query($dbc,$query) or die ('erro for delete');
           }
           echo 'Customers removed.<br/>';
       }

       //查询邮件列表
       $query = "select * from emaillist";
       $result = mysqli_query($dbc,$query);
       while ($row = mysqli_fetch_array($result)) {
           echo '<input type="checkbox" value="'.$row['id'].'" name="todelete[]" />';
           echo $row['firstname'];
           echo ' '.$row['lastname'];
           echo ' : '.$row['email'];
           echo '<br/>';
       }
       mysqli_close($dbc);
   ?>
   <input type="submit" name="submit" value="Remove">
   </form>

   <?php

   ?>
</body>
</html>