当前位置:编程学习 > asp >>

如何使用ASP在自己的网站建立投票机制(二)

答案:Batman 翻译整理

4、文件default.asp
<%
ID = Request("ID")
If ID = "" Then
ID = 30
End If
Title = "Polls (Create your own poll)"
%>

<html>

<head><link rel="STYLESHEET" type="text/css" href=> <title>ASP Polls</title>

<script language="javascript">

function gatherForm(form){
if(form.Mode[0].checked){
form.submit();
}else{
form.action="collect.asp";
form.submit();
}
}

</script>
</head>


<body>
<div align="left"><img src=http://old.zzzyk.com/article/Article/"asp_poll.gif" width="231" height="90"><br>Another joint product from <a href=><br><br>
</div>
<table width="100%" cellspacing="0" cellpadding="2">
<tr>
<td align="left" width="25%" valign="top" class="bold">
<form action="default.asp">
<table width="100" border="1" bordercolor=#ccccff>
<tr>
<td>
<table border=0 cellspacing=0 cellpadding=5 bgcolor=#4f4f4f><tr>
<td colspan=3 bgcolor=#000000 align=center class="bold2">Select A Poll</td>
</tr><tr>
<td colspan=3 bgcolor=#000000 align=center>
<select name="ID" onChange="gatherForm(this.form)" class="input">
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("ASPPollDSN")
sql = "select * from Poll"
Set rs = conn.Execute(sql)
Do While Not rs.EOF
%>


<option value="<%=rs("ID")%>"><%=rs("PollName")%>

<%
rs.MoveNext
Loop
%>

</select>
</tr>

<tr>
<td colspan=3 align=right bgcolor=#FFFFFF class="bold">
Vote In Poll:<input type="radio" name="Mode" value="Vote" CHECKED><br>
View Results:<input type="radio" name="Mode" value="View">
</td></tr>

<tr>
<td colspan=3 align=right bgcolor=#000000 align=center>
<input type="button" value=" Go " onClick="gatherForm(this.form)" class="inline">
</td></tr>

</table>
</td>
</tr>
</table></form><br>
<div align="left" class="bold">
<a href=><a href=></div>
</td>

<td align="center" width="75%" valign="top">
<table width="100" border=1 cellspacing=2 cellpadding=0 bordercolor=#ccccff><tr><td>
<form method="post" action="collect.asp">
<input type="hidden" name="id" value="<%=id%>">

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("ASPPollDSN")
sql = "select * from Poll where ID = " & ID
Set rs = conn.Execute(sql)
If rs.EOF = False Then
%>

<table border=0 cellspacing=0 cellpadding=10 bgcolor=#4f4f4f><tr>
<!-- <td colspan=3 bgcolor=#2f2f4f align=center><font face="verdana" color=#f5fcdc>
Poll: <%=rs("PollName")%>
</td> -->
</tr><tr>
<td colspan=3 bgcolor=#000000 align=left class="bold2"><%=rs("PollQuestion")%>
</tr>
<%
For I=1 To 5
choice = rs("Choice" & I)
If choice <> "" Then
%>
<tr> <!-- <td width=50 colspan=1 bgcolor=#4f4f4f>&nbsp;</td> -->
<td colspan=2 bgcolor=#FFFFFF class="bold" align="left">
<%=choice%></td><td bgcolor=#FFFFFF align="left"><input type="radio" name="choice" value="<%=I%>">
</td></tr>
<%
End If
Next
%>

</tr>
<% If rs("GetName") = "1" Then %>
<tr><td colspan=1 align=right bgcolor=#FFFFFF class="bold">
Your Name:</td>
<td colspan=2 align=right bgcolor=#FFFFFF>
<input type="text" name="Name">
</td></tr>
<% End If %>
<tr>
<td colspan=3 align=right bgcolor=#000000 align=center>
<input type="submit" value="Submit Vote" class="inline">
</td></tr>
</table>

<%
Else
Response.Write "Invalid Poll Id Request!"
End If
%>
</td></tr></form></table>

</td>
</tr>
</table>
</body>
</html>

5、文件global.asa
<SCRIPT LANGUAGE="VBScript" RUNAT="SERVER">

Sub Application_OnStart
Application("ASP_Poll") = "ASP_Poll"
cnString = "DRIVER={Microsoft Access Driver (*.mdb)}; "
cnString = cnString & "DBQ=" & Server.MapPath("Events.mdb")
Application("ASPPollDSN") = cnString
End Sub
</SCRIPT>

6、文件pool.inc
<%
DBPath = Server.MapPath("/poll/Events.mdb")
ID = 28
If Request.Cookies("PollID") = CStr(ID) Then
ShowDisplay
Else
ShowVote
End If

Function ConvertToPercent(total, sz)
If sz = 0 Then
ConvertToPercent = "0%"
Else
ConvertToPercent = FormatPercent(sz/total, 2)
End If
End Function

Sub ShowVote

%>

<div align=right>
<table width=125 border=1 cellspacing=0 cellpadding=0><tr><td>
<form method="post" action="/poll/collect.asp">
<input type="hidden" name="id" value="<%=id%>">
<input type="hidden" name="return_page" value="<%=Request.ServerVariables("PATH_INFO")%>">
<%
Set conn = Server.CreateObject("ADODB.Connection")
dsnpath = "DRIVER={MICROSOFT ACCESS DRIVER (*.mdb)}; "
dsnpath = dsnpath & "DBQ=" & DBPath
conn.open dsnpath
sql = "select * from Poll where ID = " & ID
Set rs = conn.Execute(sql)
If rs.EOF = False Then
%>

<table width=125 border=0 cellspacing=0 cellpadding=2 bgcolor=#4f4f4f>
<tr>
<td colspan=3 bgcolor=#2f2f4f align=center>
<%=rs("PollQuestion")%>
</td>
</tr>
<%
For I=1 To 5
choice = rs("Choice" & I)
If choice <> "" Then
%&

上一个:ASP技术在论坛中的运用(一)(吐血推荐!!!!)
下一个:如何使用ASP在自己的网站建立投票机制(一)

CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,