admin_links.asp

来自「能进行网上购物的需求」· ASP 代码 · 共 219 行

ASP
219
字号
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
        response.redirect "default.asp"
end if
dim action, linkid
linkid=request.QueryString("id")
action=request.QueryString("action")
select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from 56770_huoban", conn, 1, 3
rs.AddNew
rs("wordlink")=trim(request("wordlink"))
rs("url")=trim(request("url"))
rs("logo")=trim(request("logo"))
rs("bs")=int(request("bs"))
xs=rs("xs")
if xs="on" then conn.execute "update 56770_huoban set xs=true where id="&linkid
        rs.Update
rs.Close
set rs=nothing
response.Redirect "admin_links.asp"
response.end
'----------------------------------------
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from 56770_huoban where id=" &linkid, conn, 3, 3
rs("wordlink")=request("wordlink")
rs("url")=trim(request("url"))
rs("logo")=trim(request("logo"))
rs("bs")=int(request("bs"))
xs=request("xs")
if xs="on" then
        conn.execute "update 56770_huoban set xs=true where id=" &linkid
else
        conn.execute "update 56770_huoban set xs=false where id=" &linkid
end if
rs.update
rs.close
response.Redirect "admin_links.asp"
response.end
set rs=nothing
'--------------------------------
case "del"
conn.execute "delete from 56770_huoban where id="&linkid
response.Redirect "admin_links.asp"
response
end select
%>

<body bgcolor="#FFFFCC" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" vspace="0" hspace="0">
<tr>
<td height="27" background="images/admin_bg_1.gif">.:: 您可以在这里进行友情连接的相关操作</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
<tr>
<td class="12v" >
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#006600">
<tr>

<td bgcolor="#2FACFF" background="images/admin_bg_1.gif" height="25">
<div align="center"><font color="#FFFFFF">合作站点列表</font></div>
</td>
</tr>
<tr>
<td height="99" valign="top" bgcolor="#D6DFF7"><br>
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select * from 56770_huoban order by bs", conn, 3, 3
dim i
i=rs.recordcount%>
<table width="100%%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="26%" height="16" bgcolor="#D6DFF7">
<div align="center">网站名称</div>
</td>
<td width="18%" height="16" bgcolor="#D6DFF7">
<div align="center">网站地址</div>
</td>
<td width="17%" bgcolor="#D6DFF7">
<div align="center">LOGO</div>
</td>
<td width="9%" bgcolor="#D6DFF7">
<div align="center">图片</div>
</td>
<td width="8%" bgcolor="#D6DFF7">
<div align="center">排序</div>
</td>
<td width="23%" bgcolor="#D6DFF7">
<div align="center">操 作</div>
</td>
</tr>
<%if rs.eof and rs.bof then
response.write "还没有数据,请添加!"
else
        do while not rs.eof%>
<tr>
<form name="form1" method="post" action="admin_links.asp?action=edit&id=<%=rs("id")%>">
<td height="35" bgcolor="#D6DFF7">
<div align="center">
<input name="wordlink" type="text" id="linkname" value="<%=trim(rs("wordlink"))%>" size="16">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="url" type="text" id="linkurl" value="<%=trim(rs("url"))%>" size="20">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="logo" type="text" id="LOGO" size="20" value=<%=trim(rs("logo"))%>>
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input type="checkbox" name="xs" <%if rs("xs")=true then%> checked <%end if%> >
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="bs" type="text" id="linkidorder" value=<%=rs("bs")%> size="3">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input type="submit" name="Submit" value="修 改">
&nbsp; &nbsp; <a href=admin_links.asp?action=del&id=<%=rs("id")%>><font color="#FF0000">删除</font></a>
</div>
</td>
</form>
</tr>
<%rs.movenext
loop
end if
rs.close
set rs=nothing%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#006600">
<tr>

<td bgcolor="#2FACFF" background="images/admin_bg_1.gif" height="25">
<div align="center"><font color="#FFFFFF">添加合作站点</font></div>
</td>
</tr>
<tr>
<form name="form2" method="post" action="admin_links.asp?action=add">
<td height="100%" bgcolor="#D6DFF7">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="15" bgcolor="#D6DFF7">
<div align="center">网站名称</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">网站地址</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">网站LOGO</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">排 序</div>
</td>
</tr>
<tr>
<td height="15" bgcolor="#D6DFF7">
<div align="center">
<input name="wordlink" type="text" id="wordlink" size="16">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="url" type="text"  size="20" id="url">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="logo" type="text"  size="20" id="logo">
</div>
</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input name="bs" type="text" id="bs" value=<%=i+1%> size="3">
</div>
</td></tr>
<tr><td> <input type="checkbox" name="xs">图片连接</td>
<td bgcolor="#D6DFF7">
<div align="center">
<input type="submit" name="Submit2" value="添 加">
</div>
</td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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