📄 pollvalue.asp
字号:
<head>
<title>投票结果</title>
<link rel="stylesheet" type="text/css" href="poll.css">
<%
set conn=server.createobject("ADODB.CONNECTION")
conn.open "DBQ="+server.mappath("poll.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
set rs=server.createobject("adodb.recordset")
set rs_title=server.createobject("adodb.recordset")
sql="SELECT sum(pitemnum) from items where pid="&request("pid")
sql_title="select title from descrip where id="&request("pid")
set TOTAL=conn.execute(sql)
TOTAL=TOTAL(0)
sql="SELECT * from items where pid="&request("pid")
rs.open sql,conn,1,1
rs_title.open sql_title,conn,1,1
response.write "投票主题:"%><%=rs_title("title")%>
</head>
<br><br><br>
<input type=hidden name=pid VALUE=<%=request("pid")%>>
<input type=hidden name=title VALUE=<%=rs_title("title")%>><%rs_title.close%>
<table border=1 borderColorDark=#ffffec borderColorLight=#5e5e00 cellPadding=1 cellSpacing=0 width=100%>
<tr bgcolor=cccccc align=center><td width="111">选项</td><td width=109>图示</td><td width="44">投票数(总共<%=TOTAL%>)</td></tr>
<%
cc=1
if TOTAL=0 then TOTAL=1
while not rs.eof
if cc mod 2=1 then
Response.Write "<tr bgcolor=#E7E7E7>"
else
Response.Write "<tr BGCOLOR=#F4F4F4>"
end if
rate=cint(rs("pitemnum")/TOTAL*100)
%>
<td width="111"><%=rs("pitemtext")%></td><td width="109"><img src=yelbar.gif width=<%=rate%>% height=10></td><td width="44"><%=rs("pitemnum")%>(<%=rate%>%)</td>
<%
cc=cc+1
rs.movenext
wend
set TOTAL=nothing
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table><p align=center>
<br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -