PHP paging, select all, inverse selection, unselect all, batch delete_PHP tutorial
WBOY
Release： 2016-07-13 17:49:09
Original
1246 people have browsed it
/**
* User management
* 2011/8/22
* kcj
*
**/
include "isLogin.php";
include "../conn/conn.php";
$sql="select * from user";
$rst=mysql_query($sql);
$totalnum=mysql_num_rows($rst);
$pagesize=5;
$page=$_GET['page'];
if($page==''){
$page=1;
}
$begin=($page-1)*$pagesize;
$pagecount=ceil($totalnum/$pagesize);
?>
无标题文档
Background Management-& GT; Management User
/**
* User management
* 2011/8/22
* kcj
*
**/
include "isLogin.php";
include "../conn/conn.php";
$sql="select * from user";
$rst=mysql_query($sql);
$totalnum=mysql_num_rows($rst);
$pagesize=5;
$page=$_GET['page'];
if($page==''){
$page=1;
}
$begin=($page-1)*$pagesize;
$pagecount=ceil($totalnum/$pagesize);
?>
无标题文档
后台管理->管理用户
用户名 备注名 注册时间 操 作
if(isset($_POST['dell'])){ //批量删除
$ids=$_POST['dell'];
$ids=implode(",", $ids); //implode函数 把数组元素组合为一个字符串。
$sql="delete from user where id in ($ids)";
mysql_query($sql);
}
if(isset($_GET['del'])){
$id=$_GET['del'];
$sql="delete from user where id=".$id;
mysql_query($sql);
}
$sql="select * from user order by id limit $begin,$pagesize";
$rst=mysql_query($sql);
while ($row=mysql_fetch_array($rst)){
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
