📄 vote.asp
字号:
<!--#include file="session.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css.css" rel=STYLESHEET type=text/css>
</head>
<body>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="mainmiddle">
<tr>
<td width="29" height="32"> <div align="left">
<p class="maindaohang"> </p>
</div></td>
<td width="709"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<b><font color="#000000"><b> <span class="bigNavi">投票管理</span> </b></font></b></td>
<td width="8" class="mainrights"></td>
</tr>
</table>
<br>
<table width="95%" height="22" border="0" align="center" cellpadding="3" cellspacing="1" class="tabbgcolor">
<tr class="tabbgcolorli">
<td colspan="4"><table width=100% height="0" border=0 cellpadding=0 cellspacing=2 class=border
style="WORD-BREAK: break-all">
<tbody>
<tr bgcolor=#c0c0c0 class=title>
<td height=215 colspan="5" align=middle valign="top" bgcolor="#F8f8f8"><table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><p>投票标题<br>
<% set rs1=server.CreateObject("adodb.recordset")
sql1="select top 1 * from votetopic"
rs1.open sql1,conn,1,1
topic=rs1("topic")%>
<form name="topic" action="votetopic.asp" method="post">
<input type="text" size="30" class="border" name="topic" value="<%=topic%>"> <input type="submit" name="sub1" class="border" value="修改"></form>
<% rs1.close
set rs1=nothing %> <br>
</p>
</td>
</tr>
</table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>投票选项</td>
</tr>
<tr>
<td><form name="form4" method="post" action="sql.asp?action=voteadd">
<input name="name" type="text" id="name2" size="25" class="border">
<input type="submit" name="Submit4" value="增加" class="border">
</form></td>
</tr>
<tr>
<td>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from vote order by id"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
Response.Write"请增加投票选项"
end if
do while not rs.eof
%>
<form name="form3" method="post" action="sql.asp?action=votemotify">
<input name="newname" type="text" value="<%= rs("name") %>" class="border" size="25">
<input type="submit" name="submit" class="border" value="修改">
<input type="submit" name="submit" class="border" value="删除">
<input type="submit" name="submit" class="border" value="计数置0">
<input name="oldname" type="hidden" class="border" value="<%= rs("name") %>">
</form>
<%
rs.movenext
loop
rs.close
%>
</td>
</tr>
</table>
<br> <table width="80%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td>
<%
dim rs
dim sql
dim total
set rs=server.createobject("adodb.recordset")
sql="select * from vote order by id"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "目前还没有投票项目,请与管理员联系增加项目!"
else
do while not rs.eof
total=total+rs("votenum")
rs.movenext
loop
if total=0 then
response.write "目前还没有人投票,欢迎您选择投票!"
else
%>
<p><font size="2">[目前共有<%=total%>人参与本站调查]<br>
<%
rs.movefirst
do while not rs.eof
%>
<br>
<%=rs("name") %>:<img src=../redbar.gif width=<%=int(rs("votenum")*2)%> height=10> <%=rs("votenum")%>人
占：<%=round((rs("votenum")/total)*100,2)%>%
<%
rs.movenext
loop
end if
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</font></td>
</tr>
</table></td>
</tr>
</tbody>
</table></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -