繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > 创建一个Web投票系统
- ASP
- ASP技巧：让Len,Left,Right函数识别中文
- Flash和ASP实现的用户登录/注册程序
- ASP随机显示不重复记录解决方案
- ASP动态网页制作常用错误处理
- ASP对网页进行限制性的访问
- 初学:ASP内建对象Response
- ASP Server object error的解决办法
- ASP教程,ASP实现防盗链的方法
- 更改windows XP 的IIS连接数
- xmldom在服务器端生成静态html页面
- asp技巧:防止被杀毒软件误删的代码
- ASP教程:初步接触ASP缓存技术
- ASP教程:rs.getrows的使用方法介绍
- ASP技巧:Utf-8和Gb2312乱码问题的终结
- ASP教程:applicaton对象的使用集合
- ASP环境:启动停止IIS不重启电脑的技巧
- 利用FLV组件制作的播放器，动态获取变量，控制FLV文件
- ASP教程:ASP错误ASP 0201的解决方法
- ASP技巧教程:认识学习codepage的属性
- Codepage参数和其对应的语言
ASP 中的 创建一个Web投票系统
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 187 ::
收藏到网摘: n/a
During this article you will learn how to construct your own web poll using ASP. The article presumes you
already understand basic database interaction.
The following samples of code allow a user to select one of four options to a question. The user's vote is
then recorded in a database and the user is taken to a page where the results for each option can be
viewed in statistical, numerical and graphical form. Not bad, huh?
The whole application is based on the database itself, so when the values within the database are altered,
the application automatically changes. The database design itself, is not included within this article so
make sure to download a copy of the entire application, including the database before running the code.
The code for the first page is shown as follows: -
Page: default.asp
<%
'Connects to database using recordset method
Function dataConn(database,connection,recordset)
Set connection = Server.CreateObject("ADODB.Connection")
Set recordset = Server.CreateObject("ADODB.Recordset")
connection.Open "DBQ=" & Server.Mappath(database) & ";Driver={Microsoft Access Driver (*.mdb)};"
End Function
%>
<HTML>
<HEAD>
<TITLE>Poll Example</TITLE>
</HEAD>
<BODY>
<FORM name="languages" method=post action="pollResults.asp">
<P>What is your favoutrite language?</P>
<%
'Calls dataConn function to open dbPoll.mdb
dataConn "files/dbPoll.mdb",POdc,LArs
'Selects all fields within tblLanguages
LArs.Open "SELECT * FROM tblLanguages", POdc
'Loop through and display each record within the database as a radio button
Do While Not LArs.EOF
Response.Write LArs("Language") & ": <INPUT type=radio name='language' value='" & LArs("Language")
& "'><BR>"
LArs.MoveNext
Loop
'Close database connection
LArs.Close
POdc.Close
Set POdc = Nothing
%>
<A href="pollResults.asp">View Poll</A>
<INPUT type=submit value="Vote">
</FORM>
</BODY>
</HTML>
Once connected to the database the script loops through each record, and displays that option as a radio
button. When the 'Vote' button is pressed, the individual value of the selected radio button is submitted
to the next page.
The code for the next page is shown below: -
Page: pollResults.asp
<%
'Define all variables that will be used
Dim I, Percent
'Connects to database using recordset method
Function dataConn(database,connection,recordset)
Set connection = Server.CreateObject("ADODB.Connection")
Set recordset = Server.CreateObject("ADODB.Recordset")
connection.Open "DBQ=" & Server.Mappath(database) & ";Driver={Microsoft Access Driver (*.mdb)};"
End Function
%>
<HTML>
<HEAD>
<TITLE>Polling Sample</TITLE>
</HEAD>
<BODY>
<%
'Calls dataConn function to open dbPoll.mdb
dataConn "files/dbPoll.mdb",POdc,LArs
'Selects all fields within tblLanguages
LArs.Open "SELECT * FROM tblLanguages", POdc,1,2
'Loop through and total up number of votes for all records
Do While Not LArs.EOF
'If record contains voted language then increment votes
If
评论 (0) All
