📄 shop_list.asp
字号:
<!--#include file="top.asp"--><!--#include file="inc/shopstar.asp"-->
<BODY>
<TABLE width=760 border=0 align=center cellpadding="4">
<TBODY>
<TR align="center">
<TD vAlign=top>
<TABLE cellpadding="3" cellspacing="1" align="center" class="tableborder1">
<TBODY>
<TR>
<TD class=th>
<img border="0" src="images/news.gif" width="15" height="15">
最新店铺</TD>
</TR>
<!--#include file="inc/getshopzu.asp"-->
<!--#include file="inc/shopzu.asp"-->
<!--#include file="inc/GetSchool.asp"-->
<SCRIPT LANGUAGE="JavaScript">
<!--
function GoPage() {
window.location.href="?page_no="+ page.value;
}
//-->
</SCRIPT>
<%
'****************************************************
' 多多校园电子商务工作室 Power by ddtaobao.com
' Email:kayvin@sohu.com OICQ:6334278 站长:小羽
' Web: http://www.ddtaobao.com 淘宝旺旺:qq63334278
' Copyright (C) 2006 ddtaobao.com All Rights Reserved
'****************************************************
Dim StrSql,Rs
StrSql="select * from dduser where font='1' order by user_date desc"
Set Rs=Server.CreateObject("adodb.recordset")
Rs.Open StrSql,conn,1,1
%>
<tr>
<div align="center">
<TABLE cellpadding="3" cellspacing="1" align="center" class="tableborder1">
<tr>
<td align="center" class="tablebody1">序号</td>
<td align="center" class="tablebody1">店铺标志</td>
<td align="center" class="tablebody1">店铺名称</td>
<td align="center" class="tablebody1">店铺掌柜和OICQ</td>
<td align="center" class="tablebody1">店铺类别</td>
<td align="center" class="tablebody1">开店时间和所在学校</td>
<td align="center" class="tablebody1">人气</td>
</tr>
<%
IF not rs.eof and not rs.bof then
dim page_size
dim page_no
dim page_total
page_size=10
if request.QueryString("page_no")="" then
page_no=1
else
page_no=cint(request.QueryString("page_no"))
end if
rs.pagesize=page_size
page_total=rs.pagecount
rs.absolutepage=page_no
dim I,J
I=0
J=page_size
do while not rs.eof and J>0
J=J-1
I=I+1
%>
<tr>
<td align="center" class="tablebody1"><%=rs("user_id")%></td>
<td align="center" class="tablebody1"><a href="shop_info.asp?user_id=<%=rs("user_id")%>" target="_blank">
<img src="<%=rs("shop_img")%>" height=60 width=60 border=0 style="border: 1px solid #C0C0C0; "></a></td>
<td align="center" class="tablebody1"><%=rs("shop_name")%><br><%=top1(rs("star"))%></td>
<td align="center" class="tablebody1"><font color="#FF00FF">Mater:</font><a href=userinfo.asp?user_id=<%=rs("user_id")%> target=_blank><%=rs("user_name")%></a><br><a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin=<%=rs("user_qq")%>&Site=<%=homepage%>&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:<%=rs("user_qq")%>:16 alt="点击这里给我发消息"></a></td>
<td align="center" class="tablebody1"><a href=shoplist.asp?zu=<%=Rs("zu")%>><%=GetshopZu(Rs("zu"))%></a></td>
<td align="center" class="tablebody1"><%=rs("user_date")%><br><%=GetSchool(Rs("School"))%></td>
<td align="center" class="tablebody1"><%=rs("shop_hits")%></td>
</tr><%
Rs.MoveNext
Loop
End IF
%>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="page" >
<tr>
<td><div align="center">[本页是<%=int(page_no)%>/<%=int(page_total)%>] [<a href="?page_no=1">第一页</a>]
<%if int(page_no)>1 then%>
[<a href="?page_no=<%=cstr(int(page_no-1))%>">前一页</a>]
<%elseif int(page_no)<=1 then%>
[<a href="?page_no=1">前一页</a>]
<%end if%>
<%if int(page_no)<int(page_total) then%>
[<a href="?page_no=<%=cstr(int(page_no+1))%>">后一页</a>]
<%elseif int(page_no)>=int(page_total) then%>
[<a href="?page_no=<%=cstr(int(page_total))%>">后一页</a>]
<%end if%>
[<a href="?page_no=<%=page_total%>">最后一页</a>] 转到
<input name="page" type="text" value="<%=page_no%>" size="5">页
<input type="button" class=input name="Submit" value="转到" onclick="GoPage()"></div></td>
</tr>
</table>
</div>
</tr>
</TBODY>
</TABLE>
<!--#include file="bottom.asp"-->
<%
Rs.Close
Set rs=Nothing
conn.Close
Set conn=Nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -