📄 productreasch.asp
字号:
<%
dim key,toppath,dbpath
toppath=""
dbpath=""
%>
<!--#include file="db_conn.asp" -->
<!--#include file="include/shopsub.asp" -->
<!--#include file="my_lib/pages.asp" -->
<!--#include file="my_lib/my_request.asp" -->
<%
proname=my_request("proname",0)
if proname="" or isnull(proname) then
proname="您没有输入搜索关键字"
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/main.css" rel="stylesheet" type="text/css">
<title>商品搜索结果</title>
</head>
<body topmargin="1">
<!--#include file="top.asp" -->
<table border="0" width="760" id="table3" cellspacing="0" cellpadding="0" align=center>
<tr>
<td height="25">当前位置：<a href="index.asp">首页</a>>>>搜索结果</td>
</tr>
</table>
<div align="center">
<table border="0" width="760" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#D9E3EC" height="20">本次搜索关键字：<font color="#FF0000"><%=proname%></font>，查找结果如下：</td>
</tr>
<tr><td>
<%
response.write "<table width=100% border=0 cellpadding=0>"
response.write "<tr align=left>"
sql="select id,p_name,p_cmoney,p_mmoney,small_pic from yqj_product where p_name like '%"&proname&"%' and issale=1"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td valign=top>对不起，没有要找的数据</td></tr>"
response.write "<tr>"
else
rs.PageSize =20 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
end if
i=1
while not rs.eof and i<=rs.pagesize
set id=rs("id")
set small_pic=rs("small_pic")
set p_name=rs("p_name")
set p_cmoney=rs("p_cmoney")
set p_mmoney=rs("p_mmoney")
response.write "<td width=110 height=110 valign=top>"
response.write "<a href=product/product_list.asp?id="&id&" target=_blank>"
response.write "<img src=upimg/"&trim(small_pic)&" border=0 width=102 height=102><br></a>"
response.write "<a href=product/product_list.asp?id="&id&" target=_blank class=smallgrayu>"&p_name&"</a>"
response.write "<br>"
response.write "市场价:￥<s><font color=#FF6600>"&formatnumber(p_cmoney,2)&"元</font></s><br>"
response.write "会员价:￥<font color=#FF0000>"&formatnumber(p_mmoney,2)&"元</font><br>"
response.write "节 省:￥"&formatnumber((p_cmoney-p_mmoney),2)&"元<br>"
response.write "<img src=images/cart.gif><a href=buy.asp?id="&id&" class=smallgrayu title=点击购买>加入购物车</a></td>"
if i mod 5 = 0 then
response.write "</tr>"
end if
rs.movenext
i=i+1
wend
call PageControl(iCount,maxpage,page,"border=0 align=right","<p align=right>")
response.write "</table>"
rs.close
set rs=nothing
%></td></tr>
</table>
</div>
<!--#include file="end.asp" -->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -