如何删除以逗号分隔的行 - How to delete rows separated by comma?

How to delete rows separated by comma?

本文关键字：分隔何删除删除 | 更新日期: 2023-09-27

嗨，我这里有一个简单的问题。我可以从网站的 url 获取 id，并使用 php 中的函数获取$_GET['']该 id。我的链接是这样的：.php?id=10,11,&from=user.我想知道的是，如果用户的ID有一个删除sql。

if($_POST['action']){
      $id = $_GET['id'];
      $from = $_GET['from'];
      if(!empty($id))
      {
            $statement = " <-- SQL STATEMENT --> ";
            $result = mysql_query($statement);
            if($result)
            {header("location:user.php");}
      }

编辑好。我的表格是这样的：

ID, Username, Password, Role     Checkbox
1    test       test    Admin       []
2    branch     branch  Manager     []
3    hello      hello   Manager     []

我

有一个复选框，我使用 javascript 中的函数获取这些值

    var id="";
    $("#form1 input:checkbox:checked").each(function(){
        id = $(this).data('id')+' '+id;
    });
    $.pgwModal({
            url: 'modaldeleteuser.php?id='+id,
            modalData : {
                id : ''+id
            },
            loading: '<span style="text-align:center">Loading in progress</span>',
            title: 'Delete User',
            close: false
        });

我将值传递给modaldelete.php通过使用模态脚本的URL将其传递给php变量

    <div>
        <?php 
            $id = $_GET['id'];
        ?>
    <form action="submit.php?id=<?php echo $id;?>&from=user" method="post" enctype="multipart/form-data">
        <p class="text-center">Are you sure you want to delete user(s) <?php echo $_GET['id'];?> from user table?</p>
        <!-- <p id ="demo" class="text-center"></p> -->
        <p class="text-center"><input type="hidden" name="action" value="delete"/>
       <button class="btn btn-danger">Delete</button> &nbsp; <a href="javascript:void(0)" class="btn btn-inverse" onclick="$.pgwModal('close');">Cancel</a></p>
    </form>
    </div>

所以对于提交.php

    if($_POST['action']=="delete") {
        if(!empty($_GET['id']))
        {
        $statement = "DELETE FROM user WHERE `Employee_ID` IN (" . implode(", ",$_GET['id']) . ")";
        $result = mysqlparser($statement, $db);
        header("location:user.php?delete=1");   
        }
        else
        {header("location:user.php?delete=2");  }
    }

所以现在。我的问题又..如何从用逗号分隔的 URL 中删除 ID？

$from = mysql_real_escape_string($_GET['from']); // Protect against SQL injection
$ids = implode(',', array_map('intval', explode(',', $_GET['id'])));
$statement = "DELETE FROM yourtable 
              WHERE from = '$from' AND id IN ($ids)";