📄 join.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<!--#include file="conn.asp"-->
<!--#include file="mfk_body.asp"-->
<title><%=title1%>--我要入团</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
call pagestart
set rs=server.createobject("adodb.recordset")
set rs.activeconnection=conn
sql="select id,jid,godt,redt,rxianlu,rfrom,rn from ejoin order by id desc"
rs.open sql,,3,1
%>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="27"><img src="skins/mfk_skin(<%=skin%>)/mfk_lefttitle1.gif"></td>
<td width="701" background="skins/mfk_skin(<%=skin%>)/mfk_midtitle1.gif"> </td>
<td width="27"><img src="skins/mfk_skin(<%=skin%>)/mfk_righttitle1.gif"></td>
</tr>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0" class="lefttablebox">
<tr>
<td width="30" height="30"> </td>
<td width="723">我 要 入 团</td>
</tr>
<tr valign="top">
<td colspan="2" class="tablebg"><table width="751" border="0" align="center" cellpadding="0" cellspacing="1" class="tablebg">
<tr align="center" class="titletable">
<td width="73" height="26">团队编号</td>
<td width="74">出发日期</td>
<td width="74">返程日期</td>
<td width="150">团队来自</td>
<td width="64">团队人数</td>
<td width="239">出行线路</td>
<td>详情情况</td>
</tr>
<%
if rs.eof or rs.bof then
%>
<tr class="table1">
<td height="26" colspan="7" align="center"><font color="#FF0000">最近没有要出发的团队！请选择其它项目！</font></td>
</tr>
<%
else
i=0
rs.pagesize=10'设置每页显示记录数
page=trim(request("page"))
if page<>"" then
page=cint(page)
else
page=1
end if
pagec=rs.pagecount
if page>pagec then
page=pagec
end if
rs.absolutepage=page
while not rs.eof and a<rs.pagesize
set xrs=conn.execute("select id,x_name from xianlu where id="&rs("rxianlu")&"")
%>
<tr class="table1">
<td height="26" align="center"><%=rs("jid")%></td>
<td align="center"><%=rs("godt")%></td>
<td align="center"><%=rs("redt")%></td>
<td align="center"><%=rs("rfrom")%></td>
<td align="center"><%=rs("rn")%>/人</td>
<td><%
ttt=xrs("x_name")
if len(ttt)>19 then
ttt=left(ttt,17)&"..."
end if
response.write ("<a href='listxianlu.asp?id="&xrs("id")&"' title='查看此线路详情'>"&ttt&"</a>")
closers(xrs)
%></td>
<td align="center"><a href="lookjoin.asp?id=<%=rs("id")%>" title='查看此团队详情'>点击查看</a></td>
</tr>
<%
rs.movenext
a=a+1
wend
%>
</table>
<tr align="center">
<td height="26" colspan="2" class="titletable">
<%
response.write("共有记录："&rs.recordcount&" 每页显示："&rs.pagesize&" 页数："&rs.pagecount&" ")
response.write ("<a href=?page=1>首页</a> ")
if page>1 then
response.write ("<a href=?page="&page-1&">上一页</a> ")
else
response.write("上一页 ")
end if
if page<pagec then
response.write("<a href=?page="&page+1&">下一页</a> ")
else
response.write("下一页 ")
end if
response.write ("<a href=?page="&pagec&">尾页</a> ")
response.write ("当前："&page&"/"&pagec&"")
%> </td>
</tr>
</td>
</tr>
<%
closers(rs)
end if
%>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="7"><img src="skins/mfk_skin(<%=skin%>)/mfk_lefttitle1_1.gif"></td>
<td width="741" background="skins/mfk_skin(<%=skin%>)/mfk_midtitle1_1.gif"> </td>
<td width="7"><img src="skins/mfk_skin(<%=skin%>)/mfk_righttitle1_1.gif"></td>
</tr>
</table>
<table width="755" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4"></td>
</tr>
</table>
<%
call pageend
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -