banner.asp

来自「asp的新闻网站」· ASP 代码 · 共 102 行

ASP
102
字号
<%
'设计:潘树文
'开发时间:2001.12
%>
<!--#include file="../include/odbc.asp" -->
<!--#include file="../include/killStr.asp" -->
<!--#include file="../include/checkUser.asp" -->
<!--#include file="../include/checkServer.asp" -->
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from news2_starcommend where picmenuid='"&request("picmenuid")&"' and flag='"&request("flag")&"' order by infoindex "
rs.open sql,conn,3,3%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Qinhp NetModel Generator">
<link rel="stylesheet" href="../script/style.css" type="text/css">
<title>新闻推荐表管理</title>
<base target=_self>
<script language='JavaScript'>
function check(form1){
	if (isNaN(form1.webnum.value))
		{alert('WEB上条目必须是数字!');
		form1.webnum.focus();
		form1.webnum.select();
		return (false);
		}
	if (form1.webnum.value<1)
		{alert('WEB上条目必须大于1!');
		form1.webnum.focus();
		form1.webnum.select();
		return (false);
		}
	}
</script>

</head>
<%
if trim(request("submit"))<>"" then
     nwebcount=clng(request("webnum"))
     rsRecordCount=rs.RecordCount 
     '***********************
     set rs2=server.CreateObject("adodb.recordset")
     sqll="select * from news2_starcommend order by commendid desc"
            
	
     '**********************
     if rsRecordCount<nwebcount then
         for i=1 to nwebcount-rsRecordCount
             rs2.open sqll,conn,3,3
          rs.AddNew
         	if rs2.eof then
				tempno=1
			else
				tempno=clng(rs2("commendid"))+1
			end if
			 rs2.close
					 
			this1Id=right("00000000000000000000"&cstr(tempno),10)
			rs("commendId")= this1Id
            rs("picmenuid")=trim(request("picmenuid"))
            rs("photoid")="0000000000"
            rs("phototitle")="新增加的明星"
            rs("infoindex")=rsRecordCount+i
            rs("visible")="0"
            rs("flag")=request("flag")
            rs.Update 
          next
     else
    ' Response.Write
    sqqq="delete  from news2_starcommend where picmenuid='"&trim(request("picmenuid"))&"' and flag='"&trim(request("flag"))&"' and infoindex >"&cstr(nwebcount)
    conn.execute sqqq
     end if      
end if
rs.Close 
rs.open sql,conn,3,3
%>
<body bgcolor="#DDDDDD"><p align=center><b><font size=4 color=#0000FF>明星推荐表</font></b></p>
<form method=POST action=<%=request.servervariables("path_info")%> name=add onsubmit="return check(this);">
<table width="100%">

<%'显示推荐新闻
for i2=1 to  rs.RecordCount %>
<tr><td width='80%'><%=i2%>&nbsp;<%=rs("phototitle")%></td>
<td><a href="srch.asp?picmenuid=<%=request("picmenuid")%>&commendid=<%=rs("commendid")%>" target="right">更新</A></td></tr> 
<%
rs.MoveNext
next 
%>
</table><table>
<tr><td>&nbsp;</td></tr>
<tr>
<td>WEB条目:
<input type=Text name=webnum size=3 value=<%=rs.RecordCount%> maxLength=2>&nbsp;<input type=submit name=submit value="修改">
</td><td><input type=submit name=刷新 value="刷新"></td></tr></table>
<input type=hidden name=picmenuid  value=<%=request("picmenuid")%> >
<input type=hidden name=flag  value=<%=request("flag")%> >
</form>
<p>[<a href=../user/loginProcess.asp target=_top>返回</a>][<a href=../user/logout.asp target=_top>退出</a>]</p></body></html>
<%rs.Close

%>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?