📄 usertable.asp
字号:
<!--#include file="conn.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>{崭}设计_v1.0 [http://www.picicn.com] (会员列表)</title>
<link href="stely.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="top.asp"-->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="24" background="images/link_bg.gif" class="yellow"> <img src="images/link_vt.gif" width="13" height="13" align="absmiddle"> 您当前的位置:<a href="index.asp"><span class="red">{崭}设计</span></a> >>> 会员列表</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="6" bgcolor="#FFFFFF"></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr align="center" bgcolor="#FF4E00">
<td class="white">用户名</td>
<td><span class="white">注册时间</span></td>
<td><span class="white">发贴数</span></td>
<td><span class="white">置顶次数</span></td>
<td class="white">金钱数</td>
<td><span class="white">魅力值</span></td>
<td class="white">等级</td>
<td class="white">登陆次数</td>
</tr>
<%sql="select * from users order by regtime DESC"
set rec=Server.CreateObject("ADODB.Recordset")
rec.open sql,conn,1,1
do while not rec.eof
%>
<tr>
<td bgcolor="#F7F7F7"><%=rec("username")%></td>
<td bgcolor="#F7F7F7"><%=rec("regtime")%></td>
<td bgcolor="#F7F7F7"><%=rec("tcount")%></td>
<td bgcolor="#F7F7F7"><%=rec("tcounts")%></td>
<td bgcolor="#F7F7F7"><%=rec("Money")%></td>
<td bgcolor="#F7F7F7"><%=rec("Glamour")%></td>
<td bgcolor="#F7F7F7"> </td>
<td bgcolor="#F7F7F7"><%=rec("dlcs")%></td>
</tr> <%
rec.movenext
loop
%>
</table></td>
</tr>
</table>
<!--#include file="bottom.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -