📄 xinpin.asp
字号:
</td>
<td width=60>
<div align="center">贵宾价</div>
</td>
</tr>
</tbody>
</table>
</form>
</td>
<td><img height=35 src="images/pics2/wp_sbox_03.gif"
width=5></td>
</tr>
</tbody>
</table>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD height=6></TD>
</TR>
</TBODY>
</TABLE>
<table width="576" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="2" width="14%" valign="top" background="images/pics2/top_bg.gif"> </td>
<td height="2" width="60%" background="images/pics2/top_bg.gif" valign="top"> </td>
<td height="2" width="4%" align="right" valign="top"><img src="images/pics2/join.gif" width="56" height="41"></td>
<td height="2" width="10%" align="right" valign="top"><a href="ding1.asp"><img src="images/pics2/avarta_bu.gif" width="128" height="41" border="0"></a></td>
<td height="2" width="12%" align="right" valign="top"><a href="ding2.asp"><img src="images/pics2/item_bu.gif" width="125" height="41" border="0"></a></td>
</tr>
<tr>
<TD height=6></TD>
</tr>
</table>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=537>
<TBODY>
<TR>
<TD width="606"><img height=24
src="IMAGES/pics2/today.gif" width=570></TD>
</TR>
<TR>
<TD height="67" valign="top">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" background="IMAGES/pics/tile_bg.gif" style="margin-bottom: 6">
<tr>
<td height="100" bgcolor="#FFFFFF">
<div align="center"></div>
<table width="100%" height="5" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width=478 height="2">
<form method="post" action="xinpin.asp">
按日期查找
<input type="text" name="key" value="<%if key="" then%><%=date()%><%else%><%=key%><%end if%>">
<input type="submit" name="Submit" value="查找">
</form>
</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
page=request.querystring("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)
if key="" then
sql="select * from hw where hw_date=date()"
else
sql="select * from hw where hw_date Like '%"&key&"%'"
end if
rs.open sql,conn,3,3
if rs.eof then
response.write"对不起， "
response.write key
response.write " 这一天没有新商品"
response.end
else
rs.pagesize=5
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
i=0
dim hw_id(),hw_name(),hw_cash(),pifa(),daili(),hw_views(),hw_buys(),hw_content(),hw_pic(),hw_date()
do while not rs.eof and (i<rs.pagesize)
i=i+1
redim preserve hw_id(i),hw_name(i),hw_cash(i),pifa(i),daili(i),hw_views(i),hw_buys(i),hw_content(i),hw_pic(i),hw_date(i)
hw_id(i)=rs("hw_id")
hw_name(i)=rs("hw_name")
hw_cash(i)=rs("hw_cash")
pifa(i)=rs("pifa")
daili(i)=rs("daili")
hw_views(i)=rs("hw_views")
hw_buys(i)=rs("hw_buys")
hw_content(i)=rs("hw_content")
hw_pic(i)=rs("hw_pic")
hw_date(i)=rs("hw_date")
rs.movenext
loop
end if
rs.close
%>
<tr>
<td width=478 height="1">
<div align="center"> </div>
</td>
</tr>
<tr>
<td width=478 height="23">
<p align="right"><strong>第 <font color=#FF6600><%=page%></font>
页/共 <font color=#FF6600><%=totalpage%></font> 页
<font color=666666>
<%if page-1>0 then%>
<a href="sort.asp?sort_id=<%=sort_id%>&page=<%=page-1%>">上一页</a>
<%else%>
上一页
<%end if%>
<%if page+1<=totalpage then%>
<a href="sort.asp?sort_id=<%=sort_id%>&page=<%=page+1%>">下一页</a>
<%else%>
下一页
<%end if%>
</font></strong><font color=666666> </font></p>
</td>
</tr>
<tr>
<td width=478 height="10"> </td>
</tr>
<tr>
<td width="100%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<div align="center"> </div>
<%
for i=1 to ubound(hw_id)
%>
<table width="575" height="157"
border=0 align="center" cellpadding=0 cellspacing=0>
<tbody>
<tr>
<td width="575"
height=25 align=middle
background=images/pics2/s_box_name2.gif class=text1><font color="#000000"><b><img src="IMAGES/pics2/login_im5.gif" width="24" height="16" border="0" align="absmiddle"><a href="views.asp?hw_id=<%=hw_id(i)%>"><b><font color="#FF6600"> </font><font color="#FF6600"><%=hw_name(i)%></font></b></a></b></font></td>
</tr>
<tr>
<td height="140" valign=top>
<table cellspacing=0 cellpadding=0 width="100%"
border=0>
<tbody>
<tr>
<td width=1 bgcolor=#999999></td>
<td valign=middle>
<table width="100%"
border=0 cellpadding=0 cellspacing=0>
<tbody>
<tr>
<td align=middle width=274 height=110>
<div align="center"><a href="views.asp?hw_id=<%=hw_id(i)%>"><br>
<img border="0" src="<%=hw_pic(i)%>" width="160" height="120"></a><br>
<br>
</div>
</td>
<td width=58>
<div align="center"><img height=94 alt=border=0
src="images/pics2/s_h_line.gif"
width=1></div>
</td>
<td valign=center align=middle width=241
height="100%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="45%" height="19">
<div align="center"><img src="IMAGES/pics2/icon_money.gif" width="19" height="13">
原 价 </div>
</td>
<td width="55%" height="19">
<div align="center"><font color="#000000"><b><s>￥</s></b></font><b><s><%=pifa(i)%></s></b>元</div>
</td>
</tr>
<tr>
<td height="20">
<div align="center"><img src="IMAGES/pics2/icon_unisex.gif" width="14" height="13">
会员卡 </div>
</td>
<td height="20">
<div align="center"><font color="#D03430"><b>￥</b></font><font color="#D03430"><b><%=hw_cash(i)%></b></font>元</div>
</td>
</tr>
<tr>
<td height="20">
<div align="center"><img src="IMAGES/pics2/icon_heart.gif" width="14" height="12">
贵宾卡 </div>
</td>
<td height="20">
<div align="center"><font color="#D03430"><b>￥<%=daili(i)%></b></font>元</div>
</td>
</tr>
<tr>
<td colspan="2" height="28">
<div align="center"><a href='javascript:openbag(<%=hw_id(i)%>)'><img src="IMAGES/pics2/s_button000-1.gif" width="81" height="20" border="0" align="absmiddle"></a></div>
</td>
</tr>
<tr>
<td colspan="2" height="28">
<div align="center"><a href="morepics.asp?hw_id=<%=hw_id(i)%>" target="_blank"><img src="IMAGES/pics2/piczoom.gif" width="81" height="20" border="0"></a></div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="bottom">
<td height=20 colspan="3" align=middle>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<%if len(hw_content(i))>75 then
hw_content(i)=left(hw_content(i),75)
response.write hw_content(i)
response.write "……"
else
response.write hw_content(i)
end if
%>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</td>
<td width=1 bgcolor=#999999
height=140></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="5"><img height=8
src="IMAGES/pics2/box_down3.gif"
width=575></td>
</tr>
</tbody>
</table>
<%next%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" height="20">
<div align="center"><img src="IMAGES/pics/seperator.gif" width="359" height="1"></div>
</td>
</tr>
<tr>
<td width=478 height="23">
<p align="right"><strong>第 <font color=#FF6600><%=page%></font>
页/共 <font color=#FF6600><%=totalpage%></font> 页
<font color=666666>
<%if page-1>0 then%>
<a href="sort.asp?sort_id=<%=sort_id%>&page=<%=page-1%>">上一页</a>
<%else%>
上一页
<%end if%>
<%if page+1<=totalpage then%>
<a href="sort.asp?sort_id=<%=sort_id%>&page=<%=page+1%>">下一页</a>
<%else%>
下一页
<%end if%>
</font></strong></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<!--#include file="copy.asp"-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -