📄 dysms.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<%
dim rs,sql
dim classid
dim classname
if request("classid")<>"" then
classid=request("classid")
else
classid=1
end if
set rs = server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from Aclass where classID="&cstr(classid)
rs.open sql,conn,1,1
if not rs.eof then
classname=rs("class")
end if
rs.close
%>
<html>
<head>
<title>短句中心</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="sl.css" type="text/css">
</head>
<SCRIPT language=JavaScript src="window.js"></SCRIPT>
<body bgcolor="#FFFFFF" text="#000000" topMargin=0>
<%
sql="select top 5 "
sql=sql&"articles.articleid,articles.title,articles.dateandtime,articles.hits,articles.classid,articles.Nclassid,ANclass.Nclass "
sql=sql&" from articles,ANclass where articles.Nclassid=ANclass.Nclassid and articles.classid="&classid&" "
sql=sql&" order by articles.articleid desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
没有更新任何短句
<%else%>
<%do while not rs.eof%>
<table width="100%" border="0">
<tr>
<td width="13%">[<a href='http://sms.it801.com/it801.asp?classid=<%=rs("classid")%>&Nclassid=<%=rs("Nclassid")%>' target=_blank><%=rs("Nclass")%></a>]</td>
<td width="77%" bgcolor="#eeeeee">
<%if len(rs("title"))>28 then%>
<%=left(rs("title"),33)%>...
<%else%>
<%=rs("title")%>
<%end if%>
</td>
<td width="10%"><img src="images/send.gif" width="18" height="14"><a href="javascript:openwin('sendsms.asp?id=<%=rs("articleid")%>','top=10,left=80,width=380,height=250')">
发送</a> </td>
</tr>
<%
rs.movenext
loop
end if
rs.close
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -