📄 search.asp
字号:
<!--#include file="../setup.asp"-->
<!--#include file="login_admin.asp"-->
<!--#include file="conn.asp"-->
<%
'================================================================================
'Product:K-Search Version 2.1
'本“软件产品”受《中华人民共和国著作权法》和《中华人民共和国计算机软件保护条例》
'和国际条约的保护。如未经授权而擅自复制或传播本程序（或其中任何部分），将受到严厉
'的刑事及民事制裁，并将在法律许可的范围内受到最大可能的起诉！
'Homepage：http://www.lucoo.com/
'--------------------------------------------------------------------------------
'Copyright(c) 2005 lucoo.com All Rights Reserved 绿色互联 版权所有
'================================================================================
%>
<title>管理中心</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/style.css">
<script language=Javascript>
function checkall(all)
{
var a = document.getElementsByName("id");
for (var i=0; i<a.length; i++) a[i].checked = all.checked;
}
</script>
<script language="JavaScript">
function web_delete(id){
var id;
if (confirm("您确定删除吗？")){
document.location.href="web_ok.asp?action=del&id="+id+"";
}
}
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!--#include file="top.asp"--><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="60" height="24" valign="bottom" bgcolor="#e1e1e1"> <table border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="center">
<td width="55" height="23">网站查询</td>
</tr>
</table></td>
<td bgcolor="#e1e1e1"><table border="0" cellpadding="0" cellspacing="0">
<form name="search" method="get" action="search.asp">
<tr>
<td width="150" align="center"><input name="keyword" type="text" id="keyword"></td>
<td width="250"><input name="sort" type="radio" value="title" checked>
网站标题
<input type="radio" name="sort" value="url">
网站网址
<input type="radio" name="sort" value="content">
网站描述</td>
<td width="45"><input type="submit" value="查询"></td>
</tr>
</form>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="5">
<form name="form" method="get" action="web_ok.asp">
<tr>
<td>
<%
Time1=Timer()
dim rs
dim keyword
dim sort
keyword=request.querystring("keyword")
sort=request.querystring("sort")
select case sort
case "title"
sql="select id,sort_id,title,url,sequence,commend,one_click,verify,click,time from web where title like '%" & keyword & "%'"
count_sql="where title like '%" & keyword & "%'"
case "url"
sql="select id,sort_id,title,url,sequence,commend,one_click,verify,click,time from web where url like '%" & keyword & "%'"
count_sql="where url like '%" & keyword & "%'"
case "content"
sql="select id,sort_id,title,content,url,sequence,commend,one_click,verify,click,time from web where content like '%" & keyword & "%'"
count_sql="where content like '%" & keyword & "%'"
end select
dim web_count
dim web_countrs
set web_countrs=conn.execute("select count(id) from web "&count_sql)
if web_countrs.eof or web_countrs.bof Then
web_count=0
else
web_count=web_countrs(0)
end If
web_countrs.close
set web_countrs = nothing
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
'
else
dim totalPut
dim CurrentPage
dim TotalPages
Const MaxPerPage=20
dim page
page=Request.QueryString("page")
if Not isempty(page) then
currentPage=Cint(page)
else
currentPage=1
end if
totalPut=web_count
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
showContent
showpage totalput,MaxPerPage,"search.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"search.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"search.asp"
end if
end if
end if
sub showContent
dim id,title,url,sequence,commend,one_click,time
set id=rs("id")
set title=rs("title")
set url=rs("url")
set sequence=rs("sequence")
set commend=rs("commend")
set one_click=rs("one_click")
set time=rs("time")
for i=1 to 20 step 1
response.write "<br><input name='id' type='checkbox' id='id' value='"&id&"'> "
response.write "<a href='web_manage.asp?id="&id&"' target='_blank'>"&title&"</a> [<a href='web_manage.asp?id="&id&"' target='_blank'>管理</a>][<a href='javascript:web_delete("&id&")'>删除</a>]<br>"
response.write "<a href='"&url&"' target='_blank'>"&url&"</a><br>排名： "
if sequence<>0 then
response.write "Yes "
else
response.write "No "
end if
response.write "推荐： "
if commend<>0 then
response.write "Yes "
else
response.write "No "
end if
response.write "一点通： "
if one_click<>"" then
response.write "Yes "
else
response.write "No "
end if
response.write "加入日期："&time&"<br>"
rs.movenext
if rs.eof then exit for
next
response.write "<br>"
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
If CurrentPage<2 Then
response.write "第一页 上一页 "
Else
response.write "<a href='"&filename&"?sort="&sort&"&keyword="&keyword&"&page=1'>第一页</a> <a href='"&filename&"?sort="&sort&"&keyword="&keyword&"&page="&CurrentPage-1&"'>上一页</a> "
End If
If n-currentpage<1 Then
response.write "下一页 最后一页 "
Else
response.write "<a href='"&filename&"?sort="&sort&"&keyword="&keyword&"&page="&CurrentPage+1&"'>下一页</a> "
response.write "<a href='"&filename&"?sort="&sort&"&keyword="&keyword&"&page="&n&"'>最后一页</a> "
End If
response.write "共"&totalnumber&"个网站 页次："&CurrentPage&"/"&n&"页"
End Function
rs.close
set rs = nothing
conn.close
set conn=nothing
session("url")=""
session("url")="search.asp?sort="&sort&"&keyword="&keyword&"&page="&CurrentPage&""
Time2=Timer()
Response.Write(" 运行速度："&(Time2-Time1)*1000&" 毫秒")
%>
</td>
</tr>
<tr>
<td height="20"><input name="checkbox" type="checkbox" onclick="checkall(this)">
全选
<input type="submit" value="删除">
<input name="action" type="hidden" id="action" value="alldel">
</td>
</tr>
</form>
</table>
<!--#include file="bottom.asp"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -