PHPajax+jQuery实现批量删除功能实例代码小结

<&＃63;php 
  require_once './db_conn.php';
  $sql = "select * from user";
  $result = mysqli_query($conn, $sql);
&＃63;>


  
  
  
  
  
  


  
    

      批量删除
          <&＃63;php 
          while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
            echo  '';
          }
          &＃63;>
        

        
        

          

            

            
First Name
            
Last Name
            
Username
          
        
        

            

            
'.$row['id'].'
            
'.$row['username'].'
            
'.$row['sort'].'
            
      
    
  
  
  
  

<&＃63;php 
  header("content-type:text/html;charset='utf-8'");
  require_once './db_conn.php';
  
  $ids = trim($_POST['ids']);
  $ids = explode(',', $ids);
  foreach ($ids as $key => $val) {
     $del_sql = "DELETE FROM `user` WHERE id = '$val'";
     $result = mysqli_query($conn, $del_sql);
  }
  if ($result) {
    echo "yes";
  }
  else{
     echo "no";
  }
&＃63;>