📄 bjtx.asp
字号:
<!--#include file="config.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<!--#include file="head.asp"-->
<%bid=clng(request("bid"))
if bid="" or bid<1 then ShowError("访问的班级不存在")
rs.open "select * from bj where id="&bid&"",conn,1,1
If Rs.eof Then ShowError("访问的班级不存在")
if rs("isopen")=1 and session("xyluserid")="" then ShowError("你访问的班级禁止游客访问")
if rs("isopen")=2 then
if session("xyluserid")="" then ShowError("你访问的班级禁止非班级成员访问")
if obj.inbj(session("xyluserid"),bid,SiteDatabase)<>1 then ShowError("你访问的班级禁止非班级成员访问")
end if
bjname=rs("bjname")
rs.close%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=Sitename%>-<%=bjname%>-班级同学</title>
<LINK href="css.css" type=text/css rel=stylesheet>
</head>
<body>
<%call bjhead(bid,bjname)%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" class="border">
<tr>
<td height="291" valign="top">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="border">
<tr>
<td height="25"> <img src="skins/1/xb3.gif"> 当前位置:<a href="bjindex.asp?bid=<%=bid%>">班级首页</a> >> <a href="bjtx.asp?bid=<%=bid%>">班级同学</a></td>
</tr>
</table>
<br>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="2" bgcolor="#F7F7F7">
<form name="form1" method="post" action=""><tr>
<td width="16%" height="25" bgcolor="#FFCFCE"><div align="center">
同学搜索</div></td>
<td width="41%"><div align="center">姓名：
<input name="bjname" type="text" class="formtext" id="bjname" value="<%=request("bjname")%>" maxlength="15">
<input name="Submit" type="submit" class="bottom" value="提交">
</div></td>
<td width="43%">如果对方禁止查看更多资料，请用邮件与他联系。</td>
</tr></form>
</table>
<br>
<table width="95%" border="0" align="center" cellpadding="1" cellspacing="2" class="border">
<tr bgcolor="#FFCFCE">
<td width="5%"><div align="center">ID</div></td>
<td width="11%" height="20"><div align="center">姓名</div></td>
<td width="7%"><div align="center">性别</div></td>
<td width="11%"><div align="center">生日</div></td>
<td width="23%"><div align="center">电子信箱</div></td>
<td width="17%"><div align="center">加入时间</div></td>
<td width="17%"><div align="center">最后登录</div></td>
<td width="9%"><div align="center">操作</div></td>
</tr>
<%bjname=request("bjname")
if bjname="" then
rs.open "select * from [user] where instr(','&bjid&',' ,',"&bid&",')>0 order by id desc",conn,1,1
else
rs.open "select * from [user] where realname like '%"&bjname&"%' and instr(','&bjid&',' ,',"&bid&",')>0 order by id desc",conn,1,1
end if
If Rs.eof and Rs.bof Then
Response.Write("<tr><td colspan=8>暂无成员</td></tr>")
else
dim strFileName,i,j,totalPut,CurrentPage,TotalPages
totalPut=rs.recordcount
const MaxPerPage=30
strFileName="?bjname="&bjname&"&bid="&bid&""
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
if currentPage<>1 and (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
else
currentPage=1
end if
i=0
do while not rs.eof%>
<tr bgcolor="#F7F7F7">
<td height="20"><div align="center"><%=rs("id")%></div></td>
<td><div align="center"><A href="datum.asp?userid=<%=rs("id")%>"><%=rs("realname")%></a></div></td>
<td><div align="center"><%=rs("sex")%></div></td>
<td><div align="center"><%=rs("birthday")%></div></td>
<td><div align="center"><%=rs("email")%></div></td>
<td><div align="center"><%=rs("joindate")%></div></td>
<td><div align="center"><%=rs("lastdate")%></div></td>
<td><div align="center"><A href="datum.asp?userid=<%=rs("id")%>">查看资料</a></div></td>
</tr>
<%i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
end if%>
</table>
<br>
<table width="95%" align="center" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC" class="border">
<tr>
<td height="25" bgcolor="#f9f8f2"><div align="center"><%=obj.showpage(strFileName,totalput,MaxPerPage,true,true,"条",currentPage)%></div></td>
</tr>
</table>
<%rs.close%>
</td></tr>
</table>
<%sitebottom%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -