📄 eu_query.asp
字号:
<% @LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>
<%
'=================================================
' Copyright 2007-05 jinqiu. All Rights Reserved.
' Last Update: 2007-05-15 HTTP://www.wapfs.net
'=================================================
%>
<%
txtitle=request("txtitle")
%>
<%Response.ContentType = "text/vnd.wap.wml; charset=utf-8"%>
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<!--#include file="conn.asp"-->
<!--#include file="char.asp"-->
<!--#include file="const.asp"-->
<wml>
<head>
<meta http-equiv='Cache-Control' content='no-Cache'/>
<meta http-equiv='Cache-Control' content='max-age=0'/>
</head>
<card id='main' title='最新文章' >
<p><%
set rs = server.createobject("adodb.recordset")
sql="select * from article where title like '%"&txtitle&"%' order by articleid desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有任何文章<br/>"
else
If Request.QueryString("Page") = "" or Request.QueryString("Page") <= 0 then
Page = 1
Else
Page = CINT(Request.QueryString("Page"))
End If
rs.pagesize =10
total = rs.RecordCount
rs.absolutepage=page
mypagesize = rs.pagesize
dim i
i=1
do while not rs.eof and i<=mypagesize
if rs("articleon")=0 then
response.write "<a href='list.asp?id="&rs("articleid")&"'>"&((page-1)*10+i)&"."&untow(rs("title"))&"</a><br/> "
%>
<%end if%>
<%
i=i+1
rs.movenext
loop
%>
<%
if page>1 then
Response.Write "<anchor>上页<<<go href='eu_query.asp' method='post'><postfield name='txtitle' value='"&txtitle&"'/><postfield name='page' value='"&(page-1)&"'/></go></anchor>"
end if
%>
<%
if page<rs.pagecount then
Response.Write "<anchor>下页>><go href='ru_query.asp' method='post'><postfield name='txtitle' value='"&txtitle&"'/><postfield name='page' value='"&(page+1)&"'/></go></anchor>"
end if
%>
<br/><%=total%>篇文章,<%=page%>/<%=rs.pagecount%>页<%end if%>
<br/>-------------
<br/><a href='query.asp'>查找文章</a>
<br/><a href='main.asp'>管理首页</a></p>
</card>
</wml>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -