?? u_lb.asp
字號:
<!--#include file="conn.asp" -->
<%
id=request("id")
exec="select * from user order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<link href="../css/aindex.css" rel="stylesheet" type="text/css" />
<link href="../css/index.css" rel="stylesheet" type="text/css" />
<link href="../css/alink.css" rel="stylesheet" type="text/css" />
<table width="100%" align="right" cellpadding="5" cellspacing="1" class="bx">
<tr>
<td colspan="9" bgcolor="#34A6DC" class="bg">會員列表</td>
</tr>
<tr>
<td colspan="9" bgcolor="#FFFFFF">
<!--#include file="u_so.asp" -->
</td>
</tr>
<tr>
<td colspan="9" class="bg4">
<!--#include file="pg.asp" -->
</td>
</tr>
<tr>
<td width="4%" class="bg">編號</td>
<td width="11%" class="bg">用戶</td>
<td width="9%" class="bg">姓名</td>
<td width="5%" class="bg">性別</td>
<td width="11%" class="bg">生日</td>
<td width="9%" class="bg">電話</td>
<td width="10%" class="bg">QQ</td>
<td width="20%" class="bg">操作</td>
<td width="21%" class="bg">√為已入學/時間</td>
</tr>
<% for i=1 to rs.pagesize %>
<% if rs.eof then
exit for
end if
%>
<tr bordercolor="#E6F7FB" bgColor=#FFFFFF onMouseOver="javascript:this.bgColor='#E6F7FB';"onMouseOut="javascript:this.bgColor='#FFFFFF';" >
<td bordercolor="#F2F4F4"><%=i%></td>
<td bordercolor="#F2F4F4">
<a href="u_u.asp?id=<%=rs("id")%>"><%=rs("uname")%></a>
<%if rs("img")<>"" then%>
<img src="../up/<%=rs("img")%>" width="16" height="20" border="0">
<%end if%>
</td>
<td bordercolor="#F2F4F4"><a href="u_u.asp?id=<%=rs("id")%>"><%=rs("un")%></a><font color=#009900"><strong><% if rs("rx")="是" then response.write"√" %></strong></font></td>
<td align="center" bordercolor="#F2F4F4"><%=rs("xb")%></td>
<td bordercolor="#F2F4F4"><%=rs("sr")%></td>
<td bordercolor="#F2F4F4"><%=rs("tel")%></td>
<td bordercolor="#F2F4F4"><a href="href=http://wpa.qq.com/msgrd?V=1&Uin=314191031&Site=互動服務&Menu=yes"target=blank ><%=rs("qq")%></a></td>
<td bordercolor="#F2F4F4">
<a href="u_check.asp?id=<%=rs("id")%>">修改</a>
<a href="u_del.asp?id=<%=rs("id")%>">刪除</a>
<a href="u_del.asp?id=<%=rs("id")%>">
<%
if rs("rx")="是" then
Response.Write "<a href=ubm.asp?rx=否&id="&rs("id")&">取消入學</a>"
else
Response.Write "<a href=ubm.asp?rx=是&rd="&date&"&id="&rs("id")&">確認入學 ●</a>"
end if
%>
</a> </td>
<td bordercolor="#F2F4F4"><a href="u_del.asp?id=<%=rs("id")%>">
<%
if rs("rx")="是" then
Response.Write "<a href=ubm.asp?rx=否&id="&rs("id")&">√</a> 入學時間:"
else
Response.Write "<a href=ubm.asp?rx=是&rd="&date&"&id="&rs("id")&">●</a>"
end if
%>
</a><%=rs("rd")%></td>
</tr>
<%
rs.movenext
next
%>
</table>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -