📄 admin_pic.asp
字号:
<!--#include file="conn.asp"-->
<%
pathset = 0
upset = 2
nameset = 2
session("item")=request("item")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<BODY leftmargin="0" bottommargin="0" rightmargin="0" topmargin="0" marginheight="0" marginwidth="0">
<%
if request("action")="save" then
set rs=server.CreateObject("ADODB.recordset")
sql="select * from pic where item='"&request("item")&"'"
rs.open sql,conn,3,3
rs.addnew
rs("item")=request("item")
rs("image")="pic/"&session("pic1")
rs.update
response.write "<script language=JavaScript>{window.alert('图片上传成功!');window.location='admin_pic.asp?item="&request("item")&"'}</script>"
response.end
rs.close
set rs=nothing
end if
%>
<%
if request("action")="del" then
set rs=server.CreateObject("ADODB.recordset")
sql="DELETE id from pic where id="&request("id")
rs.open sql,conn,3,3
rs.update
response.write "<script language=JavaScript>{window.alert('图片删除成功!');window.location='admin_pic.asp?item="&request("item")&"'}</script>"
response.end
rs.close
set rs=nothing
end if
%>
<br>
<%
set rs=server.CreateObject("ADODB.recordset")
sql="select * from products where item='"&request("item")&"'"
rs.open sql,conn,3,3
if rs.eof and rs.bof then
response.write "<script language=JavaScript>{window.location='error.asp'}</script>"
response.end
else
set rs1=server.CreateObject("ADODB.recordset")
sql="select * from pic where item='"&request("item")&"'"
rs1.open sql,conn,3,3
count=rs1.recordcount
i=0
%>
<table width="95%" border="0" cellspacing="1" cellpadding="3" align="center" class="tableBorder">
<tr>
<th width="100%" colspan="2" height="25">商品图片上传</th>
</tr>
<tr>
<td width="30%" height="25" class="forumrow">商品编号</td>
<td width="70%" height="25" class="forumrow"><%=rs("item")%></td>
</tr>
<tr>
<td width="30%" height="25" class="forumrow">图片数量</td>
<td width="70%" class="forumrow"><%=count%></td>
</tr>
<tr>
<td class="forumrow" colspan="2">
<form name="form" method="post" action="upfile1.asp" enctype="multipart/form-data">
<input type="hidden" name="act" value="upload">
<input type="file" name="file1" size="50">
<input type="submit" name="Submit" style="CURSOR:hand" value="上 传">
</form>
</td>
</tr>
<tr>
<td class="forumrow" colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<%do while not rs1.eof
i=i+1
%>
<td width="25%" align="center" height="120">
<img border="0" src="../<%=rs1("image")%>" width="80" height="91"><br>
<a href="admin_pic.asp?action=del&id=<%=rs1("id")%>&item=<%=rs("item")%>">点击删除</a>
</td>
<%if i mod 4 = 0 then%>
</tr>
<tr>
<%end if
rs1.movenext
loop
%>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<%
rs1.close
set rs1=nothing
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -