📄 xh.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"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=Sitename%>-学校校花</title>
<LINK href="css.css" type=text/css rel=stylesheet>
</head>
<body>
<%sitehead%>
<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 width="86%" height="25"> <img src="skins/1/xb3.gif"> 当前位置:<a href="index.asp">首页</a> >> <a href="xh.asp">学校校花</a></td>
<td width="14%"><a href="hcjoin.asp">报名参加</a></td>
</tr>
</table>
<br>
<%if request("page")="" or request("page")=1 then%>
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="2" class="border">
<tr>
<td height="20" colspan="3" bgcolor="#FFCFCE"> <b>最新选手</b></td>
</tr>
<tr>
<%rs.open "select top 6 id,realname,shengxiao,birthday,sex,hccount,userphoto,hcdate from [user] where ishc=1 and sex='女' order by hcdate desc,hccount desc",conn,1,1
If Rs.eof and Rs.bof Then
Response.Write("<tr><td colspan=8>暂无成员</td></tr>")
else
i=0
do while not rs.eof%>
<td><table width="98%" border="0" cellpadding="0" cellspacing="0" class="border">
<tr>
<td width="49%" height="100"><div align="center"><A href="hcview.asp?id=<%=rs("id")%>"><img src="<%=rs("userphoto")%>" width="105" height="80" class="picborder" alt="进入选手展示页"></a></div></td>
<td width="51%">姓名：<A href="datum.asp?userid=<%=rs("id")%>" target=_blank><%=rs("realname")%></a><br>
性别：<%=rs("sex")%><br>
生属：<%=rs("shengxiao")%><br>
鲜花：<%=rs("hccount")%><br>
生日：<%=rs("birthday")%><br>
参选：<%=rs("hcdate")%></td>
</tr>
</table></td>
<%i=i+1
if i mod 3=0 then response.write "</tr><tr>"
rs.movenext
loop
end if
rs.close%>
</tr>
</table>
<br>
<%end if%>
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="2" class="border">
<tr>
<td height="20" colspan="3" bgcolor="#FFCFCE"> <b>校花排行</b></td>
</tr>
<tr>
<%rs.open "select top 15 id,realname,shengxiao,birthday,sex,hccount,userphoto,hcdate from [user] where ishc=1 and sex='女' order by hccount desc,id desc",conn,1,1
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=18
strFileName="?"
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%>
<td><table width="98%" border="0" cellpadding="0" cellspacing="0" class="border">
<tr>
<td width="49%" height="100"><div align="center"><A href="hcview.asp?id=<%=rs("id")%>"><img src="<%=rs("userphoto")%>" width="105" height="80" class="picborder" alt="进入选手展示页"></a></div></td>
<td width="51%">姓名：<A href="datum.asp?userid=<%=rs("id")%>" target=_blank><%=rs("realname")%></a><br>
性别：<%=rs("sex")%><br>
生属：<%=rs("shengxiao")%><br>
鲜花：<%=rs("hccount")%><br>
生日：<%=rs("birthday")%><br>
参选：<%=rs("hcdate")%></td>
</tr>
</table></td>
<%i=i+1
if i>=MaxPerPage then exit do
if i mod 3=0 then response.write "</tr><tr>"
rs.movenext
loop
end if%>
</tr>
</table>
<table width="98%" 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%><br>
</td></tr>
</table>
<%sitebottom%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -