www.gusucode.com > 书生图片管理Asp源码程序 > code/search.asp
<!--#include file="articleconn.asp"--> <% dim rstype dim typesql dim typeid,typename1 if not isEmpty(request("typeid")) then typeid=request("typeid") else typeid=0 end if set rstype=server.createobject("adodb.recordset") typesql="select * from type where typeid="&typeid&"" rstype.open typesql,conn,1,1 if not rstype.eof then typename1=rstype("type") else typename1="全部图片" end if rstype.close '---------------------------search---------------------- name=trim(request("keyword")) name=replace(name,"'","''") 'Response.Write name if typeid=0 then sql="select * from learning where title Like '%"& name &"%' or title like title Like '%"& name &"%' or title Like '%"& name &"%'order by articleid desc" else sql="select * from learning where (typeid="&typeid&") and (title Like '%"& name &"%' or title like title Like '%"& name &"%' or title Like '%"& name &"%') order by articleid desc" end if set rs=conn.execute(sql) 'Rsponse.Write rs.RecordCount if name="" then 'response.redirect"index.asp" response.write"查找字符不能为空串,请重输入查找的信息<a href=""javascript:history.go(-1)"">返回重查</a>" response.end elseif rs.eof then response.write"没有你要查找的信息<a href=""javascript:history.go(-1)"">返回重查</a>" response.end else Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 'set rs=server.createobject("ADODB.recordset") 'rs.open sql,conn 'searchsub rs end if %> <% const MaxPerPage=10 dim totalPut dim CurrentPage dim TotalPages dim i,j dim typename typename="图片搜索结果" if not isempty(request("page")) then currentPage=cint(request("page")) else currentPage=1 end if set rst=server.CreateObject("ADODB.RecordSet") %> <html> <head> <title>查找结果</title> <script language="javascript"> function popwin2(id,path) { window.open("openarticle.asp?id="+id+"&ppath="+path,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); } </script> <link rel="stylesheet" type="text/css" href="css/style.css"> </head> <body marginwidth="0" leftmargin="0" bgcolor="#FFFFFF" > <div align="center"><!--#include file="home.asp" --> <center> <table border="0" width="760" cellspacing="0" cellpadding="0"> <tr> <td width="100%" > <p align="left"> <span style="font-size:12pt;"><font face="楷体_GB2312, 隶书, 宋体" size="4" color="#009900">查找结果</font>>><font color="#FF0000"><%response.write ""&typename1&""%></font></span><br> <div align="center"> </div> </table> <table width="600" border="0" align="center"> <tr> <td colspan="2" valign="top"> <div align="center"> <center> <p></p> </center> </div> <% ' dim sql 'dim rs 'if request("hits")="1" then ' sql="select * from learning order by hits desc" 'else ' sql="select * from learning order by articleid desc" 'end if 'Set rs= Server.CreateObject("ADODB.Recordset") 'rs.open sql,conn,1,1 if rs.eof and rs.bof then response.write "<p align='center'> 还 没 有 任 何 文 章</p>" else 'totalPut=rs.recordcount totalPut=rs.recordcount if currentpage<1 then currentpage=1 end if if (currentpage-1)*MaxPerPage>totalput then if (totalPut mod MaxPerPage)=0 then currentpage= totalPut \ MaxPerPage else currentpage= totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showpage totalput,MaxPerPage,"search.asp" showContent showpage1 totalput,MaxPerPage,"search.asp" else if (currentPage-1)*MaxPerPage<totalPut then rs.move (currentPage-1)*MaxPerPage dim bookmark bookmark=rs.bookmark showpage totalput,MaxPerPage,"search.asp" showContent showpage1 totalput,MaxPerPage,"search.asp" else currentPage=1 showpage totalput,MaxPerPage,"search.asp" showContent showpage1 totalput,MaxPerPage,"search.asp" end if end if rs.close end if set rs=nothing conn.close set conn=nothing sub showContent dim i i=0 %> <p> </p> <div align="center"> <center> <table width=550 border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF""> <tr class=f9 style="color:white"> <td colspan="3" align="center" bgcolor="#CCCCCC" background="IMAGES/mmto.gif"><font color="#000000"><b>缩 图 列 表</b></font></td> </tr> <%i=0 do while not rs.eof%> <tr> <td colspan="3" height="24" bgcolor="<%if (i mod 2)=0 then Response.write ""%>"> <table width="100%"> <tr> <td width="300"> <div align="center"><a href="javascript:popwin2(<%=rs("articleid")%>)"><% if not isnull(rs("images")) and rs("images")<> "" then response.write "<img src=" + rs("images") + " border=0 >" end if %></a></div> </td> <td width="40%" valign="bottom"> <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#FFFFCC"> <tr> <td>图片名称:<%=rs("title")%></td> </tr> <tr> <td>浏览次数:<%=rs("hits")%></td> </tr> <tr> <td>加入日期:<%=rs("dateandtime")%></td> </tr> <tr> <td><font face="Webdings" size="4" color="#FF0000">q</font> <a href="review.asp?ID=<%=rs("articleid")%>" target="_blank">图 片 点 评</a> <font color="#FF0000"><%=rs("reviewcount")%> 篇</font></td> </tr> </table> </td> </tr> </table> </td> </tr> <% i=i+1 if i>=MaxPerPage then exit do rs.movenext loop %> </table> <table width="550" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="IMAGES/bian.gif" width="550" height="13"></td> </tr> </table> </center> </div> <% end sub function showpage(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if Response.Write "<table border=""0"" cellspacing=""1"" width=""100%"">" response.write "<tr><td width=""38%"">" Response.Write "共有图片:<font face=""arial"" color=""red"">"&totalnumber&"</font>幅 <font face=""arial"" color=""red"">"&CurrentPage&"/"&n&"</font>页</td>" response.write "<form action=""search.asp"" method=""post"" name=""search"" onsubmit=""return checkinput()"">" response.write "<td width=""26%""><div align=""center""> "'图片搜索: response.write "<input type=""text"" name=keyword size=14 maxlength=""30"" value=""关键字搜索"" onFocus=this.value='' style=""font-size:9pt;background-color:#F7F7F7;border-left: 1px solid rgb(192,192,192); border-right: 1px solid rgb(192,192,192); border-top: 1px solid rgb(192,192,192); border-bottom: 1px solid rgb(192,192,192)"">" Response.Write "<input type=""hidden"" name=""typeid"" value="&typeid&">" response.write " <input type=""Image"" src=""images/ssearch.gif"" tppabs="""" align=""absmiddle"" width=""20"" height=""20"" title=""查询"" id=Image1 name=Image1>" response.write "</td></form>" response.write "<td width=""36%""><div align=""right"">" if CurrentPage<2 then response.write "<font color='999966'>首页 上一页</font> " else response.write "<a href="&filename&"?typeid="&typeid&"&page=1&>首页</a> " response.write "<a href="&filename&"?typeid="&typeid&"&page="&CurrentPage-1&">上一页</a> " end if if n-currentpage<1 then response.write "<font color='999966'>下一页 尾页</font>" else response.write "<a href="&filename&"?typeid="&typeid&"&page="&(CurrentPage+1) response.write ">下一页</a> <a href="&filename&"?typeid="&typeid&"&page="&n&">尾页</a>" end if Response.Write "</div></td></tr></table>" 'response.write " 页次: " 'response.write " 共<b>"&totalnumber&"</b>幅图片 <b>"&maxperpage&"</b>幅图片/页 " 'response.write " 转到:<input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">" ' response.write "<input class=buttonface type='submit' value=' 确定 ' name='cndok'></span></p></form>" end function function showpage1(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if Response.Write "<table border=""0"" cellspacing=""1"" width=""100%"">" response.write "<tr><td align=""left""><td width=""64%"">" gotopage response.write "<td width=""36%""><div align=""right"">" if CurrentPage<2 then response.write "<font color='999966'>首页 上一页</font> " else response.write "<a href="&filename&"?typeid="&typeid&"&page=1&>首页</a> " response.write "<a href="&filename&"?typeid="&typeid&"&page="&CurrentPage-1&">上一页</a> " end if if n-currentpage<1 then response.write "<font color='999966'>下一页 尾页</font>" else response.write "<a href="&filename&"?typeid="&typeid&"&page="&(CurrentPage+1) response.write ">下一页</a> <a href="&filename&"?typeid="&typeid&"&page="&n&">尾页</a>" end if Response.Write "</div></td></tr></table>" 'response.write " 页次: " 'response.write " 共<b>"&totalnumber&"</b>幅图片 <b>"&maxperpage&"</b>幅图片/页 " 'response.write " 转到:<input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">" ' response.write "<input class=buttonface type='submit' value=' 确定 ' name='cndok'></span></p></form>" end function sub gotopage%> <form action=<%response.write ""&filename&"?typeid="&typeid&"&keyword="&name&""%> method="POST" id=form2 name=form2> 转到 <input type="Text" name="page" value="1" size="4" maxlength="4" style="font-size:9pt;background-color:#f7f7f7;border-left: 1px solid rgb(192,192,192); border-right: 1px solid rgb(192,192,192); border-top: 1px solid rgb(192,192,192); border-bottom: 1px solid rgb(192,192,192)"> 页 <input type="Image" src="images/go.gif" tppabs="" width="20" height="20" align="absmiddle" title="执行" id=Image1 name=Image1> </form> <% end sub %> </td> </tr> <tr> <td colspan="2"> <div align="center"><a href="javascript:history.back()">[ 返 回 ]</a><br> <br> </div> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr valign="top"> <td height="19"><iframe src="bar.asp" width="100%" height=35 marginwidth="0" marginheight="0" hspace="0" vspace="0" frameborder="0" scrolling="NO"></iframe> </td> </tr> </table> </td> </tr> </table> <p> </p> </center> </div> <p><!--#include file="homes.asp" --> </body> </html>