📄 复件 pollitem.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")%>
<FORM name=form1 ACTION=poll.asp method=post>
<input type=hidden name=pid VALUE=<%=request("pid")%>>
<input type=hidden name=title VALUE=<%=rs_title("title")%>><%rs_title.close%>
</head>
<table border=1 borderColorDark=#ffffec borderColorLight=#5e5e00 cellPadding=1 cellSpacing=0 width=100%>
<tr bgcolor=cccccc align=center><td>标题序号</td><td>选项</td><td>已投票数(总共<%=TOTAL%>)</td><td width=100>图示</td><td>选择</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><%=rs("pitem")%></td><td><%=rs("pitemtext")%></td><td><%=rs("pitemnum")%>(<%=rate%>%)</td><td><img src=yelbar.gif width=<%=rate%>% height=10></td><td><input type="radio" value=<%=rs("pitem")%> name="pitem"></td></tr>
<%
cc=cc+1
rs.movenext
wend
set TOTAL=nothing
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table><p align=center>
<INPUT TYPE="submit" NAME="submit" VALUE="投 票"></FORM>
<script language="JavaScript">
document.form1.elements[2].checked=true;
</script><br><A HREF=.>返回</A>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -