📄 search.asp
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<%
searchname = request("searchname")
%>
<body leftmargin="0" topmargin="0" bgcolor="#ECECEC">
<table width=100% height=100% >
<tr valign=top><td width=60px height=100% style="color: white;"></td>
<td >
<table align="left" width="642" border="0" cellspacing="0" cellpadding="0">
<tr><td height=20px></td></tr>
<tr><td style="height: 9px"></td></tr>
<tr><td colspan=4><img src="images/searchresult.gif" /></td></tr>
<tr>
<%
set rs = server.createobject("adodb.recordset")
'sql="select top 2 sort_name,nsort_name,hw_name,hw_id,pifa,hw_pic from hw where charindex('"&searchname&"',sort_name+nsort_name)>0 order by hw_id DESC"
sql="select top 12 sort_name,nsort_name,hw_name,hw_id,pifa,hw_pic from hw where sort_name+nsort_name like '%"&searchname&"%' order by hw_id DESC"
'response.Write sql
'response.End()
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td class=smallfont valign=top>sorry there's no more shoes you want</td></tr>"
response.write "<tr>"
else
i=1
arr2 = 4 '每排个数
while not rs.eof
if i mod arr2 = 1 then
AlignType="left"
elseif i mod arr2 = 2 then
AlignType="center"
elseif i mod arr2 = 0 then
AlignType="right"
end if
response.write "<td class=list width='25%' align='center'> "
response.write "<table width='100%' border='0' cellspacing='0'cellpadding='0'>"
response.write "<tr><td align=left>"
response.write "<a class=picture href='detail.asp?hw_id="&rs("hw_id")&"'>"
response.write "<img class=picture src=pic/"&rs("hw_pic")&" width='140' height='115'></a>"
response.write "</td></tr>"
response.write "<tr><td align=left>"
response.write "<table width='160' border='0' cellspacing='1' cellpadding='0'>"
response.write "<tr><td width='4'> </td>"
response.write "<td height='15' >"
response.write "<a href='detail.asp?hw_id="&rs("hw_id")&"' class=shoesname target=blank>"&rs("nsort_name")&"</a>"
response.write "</td><td width=4> </td>"
response.write "</tr><tr><td colspan=3 height=2>"
response.write " <a href=detail.asp?hw_id="&rs("hw_id")&" class=shoestype title=Order target=blank>"&rs("hw_name")&"</a>"
response.write "</td></tr>"
response.write "<tr><td colspan=3 height=2>"
response.write " <a href=detail.asp?hw_id="&rs("hw_id")&" class=shoesprise title=Order target=blank>$"&rs("pifa")&"</a>"
response.write "</td></tr>"
response.write "</table>"
response.write "</td></tr>"
response.write "</table></td>"
if i mod arr2 = 0 then
response.write "</tr><tr><td width='33%' valign='top' align='center'><img width='1' height='25'></td></tr><tr>"
end if
rs.movenext
i=i+1
wend
end if
'response.write "</table>"
rs.close
set rs=nothing
%>
</table></td></tr></table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -