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

以前搜集的一些资料---如何使用asp在自己的网站建立投票机制(1)

答案:一个很不错的建立自己的投票系统的ASP程序
大家仔细读读,只要能够理解中间的关键技术
就能够在自己的网站上建立自己的投票站了。
文件整理得很仓促,希望大家谅解。
版权所有:
ASP Polls
version 1.0
Tipped Cow Development and Adrenalin Labs
结构简单介绍:
ACCESS数据库设计结构:
poll表主要字段名称:PollName,PollCreator,PollQuestion,Password,Choice1,Choice2
Choice3,Choice4,Choice5,ID(自动编号),GetName
pollresults表字段:PollID,PollAnswer,Name
1.文件db.inc
<%
   Application("ASP_Poll") = "ASP_Poll"
      cnString = "DRIVER={Microsoft Access Driver (*.mdb)}; "
      cnString = cnString & "DBQ=" & Server.MapPath("Events.mdb")
      Application("ASPPollDSN") = cnString
%>
1.文件creat_poll1.asp
<% Title="Poll Generator" %>
<head> <link rel="STYLESHEET" type="text/css" href=><title><%=Title%></title>
</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>
<center>

<%
   Response.Write "<font face='arial'>"
   If Request("errormessage") <> "" Then
      Response.Write "<b>Error! </b>" & Request("errormessage")
   Else
      Response.Write "Please complete the form below to begin creating your own poll."
   End If
%>

<br><br>
<table border=2 cellspacing=0 cellpadding=0><tr><td>
<form method="post" action="create_poll2.asp">


<table border=0 cellspacing=0 cellpadding=10 width=500><tr>
  <td colspan=2 bgcolor=#000000 align=center class="bold2">
   Enter Your Name as the Poll Creator
  </td>
</tr><tr>
  <td bgcolor=#ffffff width=25% class="bold">Poll Creator:</td>
  <td bgcolor=#ffffff>
   <input type="text" name="creator" value="<%=Request("creator")%>" size=20 class="input">
  </td>
</tr>
</table>

</td></tr>
<tr><td>

<table border=0 cellspacing=0 cellpadding=10 width=500><tr>
  <td colspan=2 bgcolor=#000000 align=center class="bold2">
   Create a Password For Your Poll So That You Can Modify It At A
   Later Time
  </td>
</tr><tr>
  <td bgcolor=#ffffff width=25% class="bold">Poll Admin Password:</td>
  <td bgcolor=#ffffff>
   <input type="password" name="password" value="<%=Request("password")%>" size=10 maxlength=10 maxsize=10 class=input>
  </td>
</tr>
</table>

</td></tr>
<tr><td>

<table border=0 cellspacing=0 cellpadding=10 width=500><tr>
  <td colspan=2 bgcolor=#000000 align=center class="bold2">
   Give Your Poll a Unique Name
  </td>
</tr><tr>
  <td  bgcolor=#ffffff width=25% class="bold">Poll Name:</td>
  <td bgcolor=#ffffff>
   <input type="text" name="name" value="<%=Request("name")%>" size=20 class=input>
  </td>
</tr>
</table>

<table border=0 cellspacing=0 cellpadding=10 width=500><tr>
  <td colspan=2 bgcolor=#000000 align=center class="bold2">
   Do you want to have the user enter their name?
  </td>
</tr><tr>
  <td  bgcolor=#ffffff width=25% class="bold">Require user to enter their name:</td>
  <td bgcolor=#ffffff class="bold">
   Yes<input type="radio" name="GetName" value="1"><br>
   No <input type="radio" name="GetName" value="0" CHECKED>
  </td>
</tr>
</table>

</td></tr>
<tr><td>

<table border=0 cellspacing=0 cellpadding=10 width=500><tr>
  <td colspan=3 bgcolor=#000000 align=center class="bold2">
   Select Poll Type
  </td>
</tr><tr>


  <td colspan=2 bgcolor=#ffffff class="bold">What type of poll question
  do you wish to create?</td>
  <td bgcolor=#ffffff class="bold">
   <input type="radio" name="polltype" value="yes_no">Yes/No<br>
   <input type="radio" name="polltype" value="multiple_choice">Multiple Choice<br>
  </td>
</tr>
</table>
</td></tr></table>
<table width=500><tr>
  <td colspan=3 align=right>
    <input type="submit" value=" Next " class="inline">
  </td></tr>
</table>

</center>
</body>
</html>
3.文件connect.asp
<%
    id = Request("id")
    If id = "" Then
       id = 0
    End If
    num = Request("choice")
    
    If num <> "" Then

        Set conn = Server.CreateObject("ADODB.Connection")
      dsnpath = "DRIVER={MICROSOFT ACCESS DRIVER (*.mdb)}; "
      dsnpath = dsnpath & "DBQ=" & Server.MapPath("Events.mdb")
      conn.open dsnpath
        Set rs = Server.CreateObject("ADODB.RecordSet")
        rs.Open "PollResults", conn, 3, 3
        rs.AddNew
        rs("PollID") = CInt(id)
        rs("Name") = Request("Name")
        rs("PollAnswer") = CInt(num)
        rs.Update
        rs.Close
        set rs = Nothing
        conn.Close
        set conn =

上一个:以前搜集的一些资料---如何使用asp在自己的网站建立投票机制(2)
下一个:以前收集的一些资料---如何使用ASP实现网站的“目录树”管理

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