📄 votes.asp
字号:
<!--#include file="conn/Conn.asp"-->
<!--#include file="inc/safe.asp" -->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看投票结果</title>
</head>
<body>
<table border="1" width="100%" id="table1" cellpadding="4" bordercolor="#E3E3E3" style="border-collapse: collapse">
<tr>
<td bgcolor="#E3E3E3" style="border-bottom: 2px solid #F2F2F2"><b><span style="font-size: 12px">投票结果</span></b></td>
</tr>
<%
vflag=my_request("vflag",0)
if vflag="add" then
idnums=my_request("idnums",1)
if Request.ServerVariables("REMOTE_ADDR")=request.cookies("IPAddress") then
response.write"<SCRIPT language=JavaScript>alert('感谢您的支持,您已经投过票了,请勿重复投票,谢谢!');"
response.write"javascript:window.close();</script>"
response.End()
end if
if idnums="" or isnull(idnums) then
response.write"<SCRIPT language=JavaScript>alert('对不起,请选择投票类别!');"
response.write"javascript:window.close();</script>"
else
sql="update JOB_vote set JOB_nums=JOB_nums+1 where JOB_id="&idnums
conn.execute (sql)
response.cookies("IPAddress")=Request.ServerVariables("REMOTE_ADDR")
end if
response.write "<tr><td>感谢您的参与</td></tr>"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
sql2="select * from JOB_vote where JOB_flag=0"
rs.open sql2,conn,1,1
'求出数
Amount=0
if rs.eof then
Amount=0
else
For I = 1 To rs.RecordCount
Amount = Amount + rs("job_nums")
rs.MoveNext
Next
'将数据移到第一条
rs.MoveFirst
%>
<tr>
<td>
<table border="0" width="100%" cellpadding="4" style="border-collapse: collapse">
<tr>
<td><span style="font-size: 9pt">到目前为止结果如下(一共投票数<%=Amount%>)</span></td>
</tr>
<tr>
<td><hr color="#ACA793" size="1"></td>
</tr>
<%
do while not rs.eof
Percent = Round((rs("job_nums")/Amount)*100,2)
%>
<tr>
<td><span style="font-size: 9pt"><%=rs("job_vote")%>:<img src="images/poll.gif" width="<%= Percent * 3 %>" height="10"> <%=Percent%>% 得票数:<%=rs("job_nums")%></span></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table>
</td>
</tr>
<%end if%>
</table>
<p align="center">
<a href="javascript:self.close();">关闭窗口</a>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -