📄 admin_st_delok.asp
字号:
<%
if request.Cookies("user")<>"管理员" then
response.Write("未知来源!请先登陆!")
response.End()
end if
%>
<!--#include file="conn.asp"-->
<!--#include file="char.asp"-->
<%
UserId=trim(request("keywords"))
set rsUser=server.createobject("adodb.recordset")
sqltext="delete * from stinfor where st_name='"& UserId&"'"
rsUser.open sqltext,conn,3,3
set rsUser=nothing
set rsUser=server.createobject("adodb.recordset")
sqltext="select hy_st from hyinfor where hy_st like '%"&UserId&"%'"
rsUser.open sqltext,conn,3,3
%>
<%
while not rsUser.Eof
%>
<%
resl=trim(rsUser("hy_st"))
resl = replace(""&resl&"", ""&UserId&"","")
resl = replace(""&resl&"",",,",",")
rsUser("hy_st") = trim(resl)
rsUser.MoveNext()
%>
<%
Wend
%>
<%
' rsUser.update
rsUser.close
set rsUser=nothing
set rsUser=server.createobject("adodb.recordset")
sqltext="select hy_st from hydsh where hy_st like '%"&UserId&"%'"
rsUser.open sqltext,conn,3,3
%>
<%
while not rsUser.Eof
%>
<%
resl=trim(rsUser("hy_st"))
resl = replace(""&resl&"", ""&UserId&"","")
resl = replace(""&resl&"",",,",",")
rsUser("hy_st") = trim(resl)
rsUser.MoveNext()
%>
<%
Wend
%>
<%
' rsUser.update
rsUser.close
conn.close
response.write "<script language=JavaScript>{window.alert('资料成功删除!');window.location.href='admin_st.asp'}</script>"
response.end
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -