📄 listusers.php.bak
字号:
<?
include_once("../include/check.php");
include_once("../../globla.php");
include_once("../include/page.php");
require $movie_root.("/Connections/showmov.php");
if ($_POST['Submit']!="")
{
if ($_POST['select']=="del")
{
$exe="delete from jdzcnnet_members where ";
$exe1="delete from jdzcnnet_memberdata where ";
}
else
{
$exe="update jdzcnnet_members set userlevel=".$_POST['select']." where ";
}
$delid=$_POST['delid'];
$count=count($_POST['delid']);
for ($i=0;$i<$count;$i++)
{
$sql=$exe."uid=".$delid[$i];
$sql1=$exe1."uid=".$delid[$i];
mysql_query($sql);
mysql_query($sql1);
}
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>天天网络会员管理系统</title>
<LINK href="../Images/Admin_Style.css" rel="stylesheet" type="text/css">
</head>
<body>
<script language=javascript>
function CheckAll(v)
{
var i;
for (i=0;i<document.form1.elements.length;i++)
{
var e = document.form1.elements[i];
e.checked = v;
}
}
</script>
<div align="center">
<table width="100%" border="1" cellpadding="5" cellspacing="1" style="border-collapse: collapse" height="58" class="border">
<tr>
<td height="22" class="topbg">
<div align="center"> <font color="#000000"><a href="listusers.asp">
<font color="#FFFFFF">显示所有用户</font></a></font></div>
</td>
</tr>
<tr>
<td height="34">
<div align="center">
<table width="81%" border="1" cellpadding="1" cellspacing="1" id="table1" style="border-collapse: collapse" bordercolor="#808080" class="border">
<form method="POST" action="?action="search"><tr>
<td width="88">
<p align="center">搜索用户:</td>
<td width="182"><input name="keyword" type="text" class="Input" id="keyword" size="30"></td>
<td width="178"><input type="radio" value="1" checked name="chkbox">
按用户名<input type="radio" name="chkbox" value="0">
按E-Mail地址</td>
<td width="136">
<input name="B1" type="submit" class="Button" value="提交">
<input name="B2" type="reset" class="Button" value="重置">
</td>
</tr></form>
</table>
</div>
</td>
</tr>
</table>
</div>
<div align="center">
<table width="100%" border="1" cellpadding="3" cellspacing="1" id="table2" style="border-collapse: collapse" class="border">
<form name="form1" method="post" action="?action=yes">
<tr>
<td colspan="7"><div align="center">
<a href="?">全部会员</a> <a href="?canlook=0">免费会员</a> <a href="?canlook=1">普通会员</a> <a href="?canlook=2">黄金会员</a> <a href="?canlook=3">钻石会员</a> <a href="?canlook=4">永久会员</a></div></td>
</tr>
<tr class="topbg">
<td align="center"><strong>编号</strong></td>
<td align="center"><strong>用户名</strong></td>
<td align="center" ><strong>注册日期</strong></td>
<td align="center" ><strong>剩余资源</strong></td>
<td align="center"><strong>登陆次数</strong></td>
<td align="center"><strong>用户等级</strong></td>
<td width="24%"><strong>
<input name="chkall" type="checkbox" class="Input" onClick="CheckAll(document.form1.chkall.checked)" value="on">
<label>
<select name="select">
<option value="del">删除会员</option>
<option value="1">设为普通会员</option>
<option value="2">设为黄金会员</option>
<option value="3">设为钻石会员</option>
<option value="4">设为永久会员</option>
<option value="0">设为电影游客</option>
</select>
</label>
<input name="Submit" type="submit" class="Button" value="提交" onClick="return confirm('确认这样操作吗？')">
</strong></td>
</tr>
<?
//开始分页查询
$keyword=trim($_POST['keyword']);
if ($keyword=="")
{
$keyword=trim($_GET['keyword']);
}
$canlook=$_POST['canlook'];
if ($canlook=="")
{
$canlook=trim($_GET['canlook']);
}
$chkbox=$_POST['chkbox'];
if ($chkbox=="")
{
$chkbox=$_GET['chkbox'];
}
if ($keyword!="")
{
if ($chkbox==1) //用户名查询
{
$exe1="select count(uid) from jdzcnnet_members where username like '%".$keyword."%' order by uid desc";
}
else
{
$exe1="select count(uid) from jdzcnnet_members where email='".$keyword."' order by uid desc";
}
}
elseif ($canlook!="")
{
$exe1="select count(uid) from jdzcnnet_members where userlevel=".$canlook." order by uid desc";
}
else
{
$exe1="select count(uid) from jdzcnnet_members order by uid desc";
}
$reslut1=mysql_query($exe1);
$rs1=mysql_fetch_array($reslut1);
$toltal=$rs1[0];
if (isset($_GET['page'])==false)
{
$page=1;
}
else
{
$page=$_GET['page'];
}
$maxperpage=50;
//
if ($keyword!="")
{
if ($chkbox==1) //用户名查询
{
$sql="select uid,username,userlevel,usertype,logins from jdzcnnet_members where username like '%".$keyword."%' order by uid desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
else
{
$sql="select uid,username,userlevel,usertype,logins from jdzcnnet_members where email='".$keyword."' order by uid desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
}
elseif ($canlook!="")
{
$sql="select uid,username,userlevel,usertype,logins from jdzcnnet_members where userlevel=".$canlook." order by uid desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
else
{
$sql="select uid,username,userlevel,usertype,logins from jdzcnnet_members order by uid desc limit ".($page-1)*$maxperpage.",".($maxperpage)."";
}
$reslut=mysql_query($sql);
while ($rs=mysql_fetch_object($reslut))
{?>
<tr onMouseOver="javascript:this.bgColor='#F5F4F0'" onMouseOut="javascript:this.bgColor='#E1F4EE'">
<td width="7%"><p align="center"><?=$rs->uid?></td>
<td width="18%"><p align="center"><a title="修改信息" href="editusers.php?id=<?=$rs->uid?>"><?=$rs->username?></a></td>
<td width="16%"><p align="center"><?=date("Y-m-d",$rs->regdate)?></td>
<td width="17%"><p align="center"><?
$exe="select money,endtime from jdzcnnet_memberdata where uid=".$rs->uid."";
$relt=mysql_query($exe);
$rs2=mysql_fetch_array($relt);
if ($rs->usertype==0)
{
echo $rs2['money']."点";
}
else
{
echo date("Y-m-d",$rs2['endtime']);
}
?></td>
<td width="9%"><p align="center"><?=$rs->logins?>次</td>
<td width="9%"><p align="center"><?=chklevel($rs->userlevel)?></td>
<td><p align="center">
<input name="delid[]" type="checkbox" id="delid" value="<?=$rs->uid?>" > </td>
</tr>
<?
}?>
</form>
</table>
<?
listpage($maxperpage,$toltal,$page,"news.php",$action,$canlook,$canlook,$keyword,$hidden);
mysql_close($showmov);
?>
</div>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -