📄 adminupd.asp
字号:
<%@ Language=VBScript %>
<%
'wrong login ...?
if session("login") <> "yes" then
Response.Redirect ("adminlog.asp")
end if
%>
<%
a = session("titlea")
'create connection
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("../fpdb/engglas.mdb")
'query to select active data...
sql = "SELECT * FROM title where title like '" & a & "'" ', vote where title.id = vote.id and title.title like '" & a & "'"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
%>
<html>
<head>
<title>Update</title>
<link rel="stylesheet" href="stili.css" type="text/css">
</head>
<body>
<%
'update title
rs.Fields("title") = Request.Form("title")
rs.Update
d = rs.fields("id")
%>
<%
rs.close
set rs = nothing
'query to select active data...
sql = "SELECT * FROM vote where id = " & d
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
'10 textboxses on previous page ... go from 1 to 10
for b = 1 to 10
on error resume next
'if last answer was deleted...
if Request.form(int(b)+1) = "" and rs.fields("answer") <> "" then
rs.delete
else
'update records...
rs.fields("answer") = Request.form(int(b)+1)
rs.update
'textbox on a form is empty ...
if Request.Form (int(b)+1) = "" then
'Response.Redirect ("admintit.asp")
else
'if textbox on a form is not empty and recordset is on the last position ... add new record
if rs.absoluteposition = rs.recordcount and Request.form(int(b)+1) <> "" then
rs.addnew
rs.fields("answer") = Request.form(int(b)+2)
rs.fields("id") = d
rs.fields("pic") = int(b)+1
rs.update
else
'just update record with data from textboxes
rs.fields("answer") = Request.form(int(b)+1)
rs.update
end if
end if
end if
rs.movenext
next
%>
<table width="200" border="1" cellspacing="0" align="center" style="border-collapse: collapse" cellpadding="10" bordercolor="#000000">
<tr>
<td bgcolor="#ADD8E6" align="center"><span class="nortxtv10">
<font color="red"><b>记录被提交!</b>
</font><p></p>
谢谢.<p></p><a href="admintit.asp">返回</a></span></td>
</tr>
</table>
</body>
</html>
<%
'close recordset and connection
rs.close
set rs = nothing
conn.Close
set conn = nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -