ajax全选、全不选、反选、单删/批删

php
//链接数据库
$link = mysqli_connect('127.0.0.1','root','root','mone');
//设置字符集
mysqli_query($link,'set names utf8');


//接收当前页
$page = empty($_GET['page'])?1:$_GET['page'];
//求出总条数
$sql = "select * from user";
$res = mysqli_query($link,$sql);
$count = mysqli_num_rows($res);
//每页显示多少条
$length = 3;
//求出总页数
$num_page = ceil($count/$length);
//偏移量
$limit = ($page-1)*$length;
//查询
$sql2 = "select * from user limit $limit,$length";
$res2 = mysqli_query($link,$sql2);
while($a=mysqli_fetch_assoc($res2)){
    $data['data'][] = $a;
}


$data['home_page'] = 1;
$data['prev_page'] = $page-1<1?1:$page-1;
$data['next_page'] = $page+1>$num_page?$num_page:$page+1;
$data['last_page'] = $num_page;

?>

    foreach($data['data'] as $k=>$v){ ?>
    

    

        
选择
        
ID
        
用户名
        
密码
        
性别
        
年龄
        
班级
        
手机
        
编辑
    
    

        

        
echo $v['user_id'];?>
        
echo $v['username'];?>
        
echo $v['pwd'];?>
        
echo $v['sex'];?>
        
echo $v['age'];?>
        
echo $v['class_name'];?>
        
echo $v['phone'];?>
        

            修改
        
    
    



全选
全不选
反选
单删/批删

php
//接收传值
$id = $_GET['id'];
//链接数据库
$link = mysqli_connect('127.0.0.1','root','root','mone');
//设置字符集
mysqli_query($link,'set names utf8');
//拼接sql
$sql = "DELETE FROM user WHERE user_id in ($id)";
if(mysqli_query($link,$sql)){
    echo 1;
}else{
    echo 2;
}