📄 user.php
字号:
<?php
require_once 'common.php';
if($editsubmit){
if($delete){;
foreach($delete as $val){
$db->query("delete from member where uid=$val");
}
show("操作成功：删除用户成功", "user.php", "请点击返回");
}else{
show("错误：没有选中的用户", "back", "请点击返回");
}
}
$perpage=20;
$page=$page==0?1:$page;
$start=($page-1)*$perpage;
$query=$db->query("select * from member");
$wheres=array();
$url="user.php";
$oldstarttime=$starttime;
$oldendtime=$endtime;
if(strpos($starttime, '-')) {
$time = explode('-', $starttime);
$starttime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]) ;
} else {
$starttime = 0;
}
$tendtime = gmdate('Y-n-j', $timestamp);
if ($endtime==$tendtime){
$endtime=$timestamp;
}else{
if(strpos($endtime, '-')) {
$time = explode('-', $endtime);
$endtime = gmmktime(0, 0, 0, $time[1], $time[2], $time[0]);
} else {
$endtime = 0;
}
}
if ($starttime){
$wheres[]="regtime>=$starttime";
$url=$url."&starttime=$oldstarttime";
}
if ($endtime){
$wheres[]="regtime<=$endtime";
$url=$url."&endtime=$oldendtime";
}
if ($susername=trim($susername)){
$wheres[]="username LIKE '%".str_replace('_', '\_', $susername)."%'";
$url=$url."&susername=$susername";
}
if ($group){
$wheres[]="groupid=$group";
$url=$url."&group=$group";
}
if (count($wheres)){
$wherestr=" where ".implode(" and ", $wheres);
}
$result=$db->query("select count(*) from member".$wherestr);
$tcount=$db->fetch_array($result);
$count=$tcount['count(*)'];
$pagecount=ceil($count/$perpage);
$pagestr=makepage($page, $pagecount, $url);
$qstr="select * from member".$wherestr." limit $start, $perpage";
$lists=array();
$result=$db->query($qstr);
while($tmp=$db->fetch_array($result)){
$lists[]=$tmp;
}
//print_r($lists);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>广告管理系统 - 用户管理 </title>
<meta name="robots" content="noindex, nofollow">
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<link href="styles/general.css" rel="stylesheet" type="text/css" />
<link href="styles/main.css" rel="stylesheet" type="text/css" />
<script>
function checkall(form, prefix, checkall) {
var checkall = checkall ? checkall : 'chkall';
for(var i = 0; i < form.elements.length; i++) {
var e = form.elements[i];
if(e.name != checkall && (!prefix || (prefix && e.name.match(prefix)))) {
e.checked = form.elements[checkall].checked;
}
}
}
</script>
</head>
<body>
<h1>
<span>后台管理 - 用户管理 </span>
</h1>
<div id="tabbody-div">
<form method="post" action="user.php">
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="2" style="font-size: 14px;"> <b>查找用户</b></td></tr>
<tr><td width="20%" align="right"><b>用户名：</b> <br></td>
<td width="60%"><input type="text" size="20" name="susername" value=""></td></tr>
<tr><td width="20%" align="right"><b>注册日期范围：</b>
</td>
<td width="60%">
<input type="text" size="10" name="starttime" value=""> 至
<input type="text" size="10" name="endtime" value="" > 格式：YYYY-MM-DD(2007-02-03)
</td></tr>
</table>
<br />
<center><input class="button" type="submit" name="searchsubmit" value="提 交"> </center>
</form>
<br />
<br />
<br />
<form enctype="multipart/form-data" name="theForm" action="user.php" method="post">
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="3" style="font-size: 14px;"> <b>删除用户</b></td></tr>
<tr align="center" class="category" style="background: #ADDBFF">
<td width="48" height="24"><input class="checkbox" type="checkbox" name="chkall" class="category" onclick="checkall(this.form)">删?</td>
<td><b>用户名</b></td>
<td><b>IP数</b></td>
<td><b>注册日期</b></td></tr>
<?php
foreach ($lists as $key=>$val){
$suid=$val['uid'];
$nusername=$val['username'];
$datestr=gmdate('Y-n-j', $val['regtime']);
$ipnum2=$val['ipnum'];
?>
<tr align="center"><td class="altbg1"><input class="checkbox" type="checkbox" name="delete[]" value="<?=$suid?>" ></td>
<td><a href="edituser.php?edituid=<?=$suid?>" ><?=$nusername?></a></td>
<td><?=$ipnum2?></td>
<td width="300"><?=$datestr?></td>
</tr>
<? } ?>
</table>
<br />
<center><input class="button" type="submit" name="editsubmit" value="提 交"> </center>
</form>
<br />
<span style="float: right; padding-right: 30px;"><b><?=$pagestr?></b>    </span>
<br>
</div>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -