⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 adminactive.asp

📁 ASP+SQL Server动态网站开发从基础到实践教程
💻 ASP
字号:
<%@ Language=VBScript %>
<% 
'wrong login ...?
if session("login") <> "yes" then
	Response.Redirect ("adminlog.asp")
end if
%>
<html>
<head>
<title>Set active poll</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<link rel="stylesheet" href="stili.css" type="text/css">
</head>
<%  
	'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"
	set rs = server.CreateObject ("ADODB.Recordset")
	rs.Open sql, conn, 3, 3	
%>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form" action="adminactiveupd.asp" method="post">
<table width="400" border="1" cellspacing="0" cellpadding="5" style="border-collapse: collapse" bordercolor="#000000" align="center">
<tr>
<td bgcolor="#ADD8E6"> 
<p align="center"><span class="nortxtv10">
<b>
<br>&#35774;&#32622;&#24403;&#21069;&#25237;&#31080;&#20027;&#39064;
</b>
</span>
</p>
<p></p>

<% 'create radio buttons
for a = 1 to rs.recordcount
%>

<span class="nortxtv10"><font color="#FFFFFF">
<b>

<% if rs.fields("active") = "y" then %>

<input type="radio" name="active" value="<%=rs.fields("title")%>" checked>
<span class="nortxtv10"><%=rs.fields("title")%></span>

<%else%>

<input type="radio" name="active" value="<%=rs.fields("title")%>">
<span class="nortxtv10"><%=rs.fields("title")%></span>

<%end if%>

</b>
<br />
<% 
      rs.movenext
      if rs.eof then
      	rs.movelast
      end if
      next
%>
<p></p>
<p align="center"><input type="image" name="sql" src="images/upd.gif" align="absmiddle" width="50" height="17">
<a href="admintit.asp"><img border="0" src="images/canc.gif" align="absmiddle" width="50" height="17"></a> 
</p>
</font>
</span>
<p></p>
</td>
</tr>
</table>
</form>
</body>
<%	'close connection and recordset...
	rs.Close
	set rs = nothing
	conn.Close
	set conn = nothing
%>
</html>

⌨️ 快捷键说明

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