建站专提News

投票管理程序

一佰互联网站开发设计(www.yinxi.net) 发布日期 2019-05-01 19:07:15 浏览数: 63

投票管理程序 表结构 CREATE TABLE poll(Poll_Id INT (11) not null AUTO_INCREMENT,Poll_Name char(50) ,Poll_Del INT (10) DEFAULT "0" , PRIMARY KEY (Poll_Id))   CREATE TABLE pollsele(Pollsele_Id INT (11) not null AUTO_INCREMENT,Pollsele_Name char(50) ,Poll_Del INT (10) DEFAULT "0" , Pollsele_poll_Id INT (10) ,pollsele_num int (10), PRIMARY KEY (Pollsele_Id))   ------------------------------------------------------------------------------------------------- poll.php   //主程序 <?     $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select poll_id,Poll_Name from poll where poll_del="1""; @$result = mysql_query($sql);       $myrow=mysql_fetch_row($result);      echo "<table align=center bgcolor=aabbcc width=250 hight=450 border=0 style="border:1px solid rgb(0,0,0)">";          echo "<td align=center bgcolor=99aabb style="border:1px solid rgb(255,255,255)">";       echo "$myrow[1]";        $sql="select Pollsele_Name,pollsele_poll_id from pollsele where pollsele_del="0" and pollsele_poll_id="$myrow[0]""; @$result = mysql_query($sql);   echo "<FORM ACTION="pollsee.php?poll_id=$myrow[0]" METHOD="post" target=_blank>";      echo "<p align=center>";    while($myrow=mysql_fetch_row($result))    {    echo "<input type="radio" name=toupiao value="$myrow[0]">$myrow[0]";      echo " ";                                          }    echo "<br>";  echo "<br>";   echo "<input type=submit name=submit value="投票" >";    echo "</p>";   echo "</form>";      echo "</td>";        echo "</table>";    mysql_close();     echo "<br>";     echo "<p align=right>";    echo "<a href=poll_input>管理</a>"; echo "</p>";     ?> ----------------------------------------------------------------------- poll_input.php  //添加主题 <?        $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db);        $sql="select poll_id,poll_name,poll_del from poll";               echo "<table width=300 hight=560 bgcolor=aabbcc align=center style="border:1px solid rgb(0,0,0)">";              $result=mysql_query($sql);              while($my=mysql_fetch_row($result))             {     echo "<tr>";echo "<td align=center width=50 bgcolor=99aabb style="border: 1px solid rgb(255,255,255)">";echo $my[0];echo "</td>";               echo "<td align=center width=200 bgcolor=99aabb style="border: 1px solid rgb(255,255,255)"><a href=pollsele.php?id=$my[0]>$my[1]</a></td>";     echo "<td align=center width=50 bgcolor=99aabb style="border: 1px solid rgb(255,255,255)">";echo $my[2];echo "</td>";                  echo "</tr>";                   }    echo "</table>";                    ?> <html> <head>   <?            if($submit2!="添加")              { echo "<p align=center>";              echo "<FORM ACTION="poll_input.php" METHOD="post">";         echo "<font color=004080>主题:</font>";        echo "<input type=text name=title size=30 value="">";       echo "<input type=submit name=submit2 value="添加">";                     echo "</p>";            echo"</form>";   } else       {$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db);        $sql="select poll_name from poll where poll_name="$title"";              mysql_query($sql); $sql="insert into poll values("","$title","")"; mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT="1; URL=poll_input.php">";  }            if($submit1!="有效"&&$submit3!="删除")            {  echo "<p align=center>";            echo "<FORM ACTION="poll_input.php" METHOD="post">";            echo "<font color=004080>设置主题:</font>";    echo "<select name="sele" size=1>";          $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select Poll_Id from poll"; $result = mysql_query($sql); mysql_close(); while($myrow=mysql_fetch_row($result)) { echo "<option value="$myrow[0]">$myrow[0]";}    echo "</select>";      echo "<input type=submit name=submit1 value="有效">";         echo "<input type=submit name=submit3 value="删除">";        echo "</p>"; echo "</FORM>";            }            else            {               if($submit1=="有效")               {            $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="update poll set Poll_Del="0""; $result = mysql_query($sql);   $sql="update poll set Poll_Del="1" where poll_id="$sele""; $result = mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT="1; URL=poll_input.php">";      }     else     {   $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="delete from poll where poll_id="$sele""; $result = mysql_query($sql); $sql="delete from pollsele where pollsele_poll_id="$sele""; mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT="1; URL=poll_input.php">";      } } ?> -------------------------------------------------------------------- pollsele.php  //添加选项 <?        $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db);        $sql="select pollsele_id,pollsele_name,pollsele_del,pollsele_num from pollsele where pollsele_poll_id="$id"";               echo "<table width=300 hight=560 align=center bgcolor=aabbcc style="border:1px solid rgb(0,0,0)" >";              @$result=mysql_query($sql);              while($my=mysql_fetch_row($result))             {     echo "<tr>";echo "<td align=center width=50 bgcolor=99aabb  style="border: 1px solid rgb(255,255,255)">";echo $my[0];echo "</td>";               echo "<td align=center width=200 bgcolor=99aabb  style="border: 1px solid rgb(255,255,255)">$my[1]</td>";     echo "<td align=center width=50 bgcolor=99aabb  style="border: 1px solid rgb(255,255,255)">";echo $my[2];echo "</td>";          echo "<td align=center width=50 bgcolor=99aabb  style="border: 1px solid rgb(255,255,255)">";echo $my[3];echo "</td>";                  echo "</tr>";                   }    echo "</table>";                    ?> <html> <head>   <?            if($submit2!="添加")              {     echo "<p align=center>";              echo "<FORM ACTION="pollsele.php?id=$id" METHOD="post">";         echo "<font color=004080>选项:</font></td>";        echo "<input type=text name=title size=30 value="">";       echo "<input type=submit name=submit2 value="添加">";                     echo "</p>";            echo"</form>";   } else       {$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="insert into pollsele values("","$title","","$id","")"; mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT="1; URL=pollsele.php?id=$id">";  }            if($submit1!="有效"&&$submit3!="无效")            {  echo "<p align=center>";            echo "<FORM ACTION="pollsele.php?id=$id" METHOD="post">";             echo "<font color=004080>设置选项:</font>";    echo "<select name="sele" size=1>";          $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select Pollsele_Id from pollsele where pollsele_poll_id="$id""; $result = mysql_query($sql); mysql_close(); while($myrow=mysql_fetch_row($result)) { echo "<option value="$myrow[0]">$myrow[0]";}    echo "</select>";      echo "<input type=submit name=submit1 value="有效">";         echo "<input type=submit name=submit3 value="无效">";       echo "</p>"; echo "</FORM>";            }            else            { $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db);       if ($submit1=="有效")       {     $sql="update pollsele set Pollsele_Del="0" where pollsele_id="$sele""; $result = mysql_query($sql);} else { $sql="update pollsele set Pollsele_Del="1" where pollsele_id="$sele""; $result = mysql_query($sql);   } mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT="1; URL=pollsele.php?id=$id">";      } ?> ---------------------------------------------------------------------- pollsee.php  //投票结果 <?       if ($toupiao!=""){ $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db);   $sql="select Pollsele_Name,pollsele_num from pollsele where pollsele_name="$toupiao""; @$result = mysql_query($sql);   $myrow=mysql_fetch_row($result);   $poll_num=$myrow[1];   $poll_num=$poll_num+1; $sql="update pollsele set Pollsele_num="$poll_num" where pollsele_name="$toupiao""; mysql_query($sql);     $sql="select Poll_Name from poll where poll_id="$poll_id""; @$result = mysql_query($sql);      $title=mysql_fetch_row($result);        echo "<p align=center>";       echo $title[0]; echo "</p>";       echo "<br>";        $sql="select Pollsele_Name,pollsele_num from pollsele where pollsele_del="0" and pollsele_poll_id="$poll_id""; @$result = mysql_query($sql);       echo "<table align=center bgcolor=aabbcc style="border:1px solid rgb(0,0,0)">";   while($myrow=mysql_fetch_row($result))   {   echo "<tr>"; echo "<td width=150 bgcolor=99aabb style="border:1px solid rgb(255,255,255)">";   echo $myrow[0];echo "</td><td width=50 bgcolor=99aabb style="border:1px solid rgb(255,255,255)">";echo $myrow[1]; echo "</td></tr>";} echo "</table>";  }   else   {echo "<font color=red>你不能投空票!!!</font>";}     ?>  【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】    
TAG标签: 投票管理程序  
一佰互联是全国知名建站品牌服务商,我们有九年网站建设、网站制作、网页设计、php开发和域名注册及虚拟主机服务经验,提供的自助建站服务更是全国有名。近年来还整合团队优势自主开发了可视化多用户”巅云建站系统“3.0平台版,拖拽排版网站制作设计,轻松实现pc站、手机微网站、小程序、APP一体化全网营销网站建设 ,已成功的为全国上百家网络公司提供自助建站平台搭建服务。

相关新闻more

30
03月
腾讯半年报前瞻:有了小程序之后,微信正在变成

简介:股王腾讯本周放榜,市场都在等待关键时刻的这份半年度业绩。正餐之前先来份点心,谈一谈腾讯生态系统外围公司在港股的IPO。目前能够查到的关... >>详情

24
04月
css中间自适应布局的5种解法详解

前言在做页面时,我们往往会碰到页面布局相关的内容,面试时也经常会被问到,那么今天我就来总结一下关于页面布局的内容。问题:如何实现三栏布局(高... >>详情

26
04月
PHP获取当前日期及本周一是几月几号的方法

本文实例讲述了PHP获取当前日期及本周一是几月几号的方法。分享给大家供大家参考,具体如下:<?php header("con... >>详情

13
03月
VPS主机在未来会取代虚拟主机空间吗?

前段时间想要租用独立服务器,就在网上搜了一遍,不经意却发现一个新的主机名字——VPS主机。业内有关人士称:“VPS在未来几年将会取代虚拟主机... >>详情

高端网站建设

美工兼顾SEO,为企业电子商务营销助力!

电话:

023-85725751

产品

域名注册 虚拟主机 云服务器 企业邮局
智能建站 APP打包 微站/小程序 创业平台
网站推广 媒体营销 智能采集 AI机器人
400电话 短信营销 店销机器人
私人定制 门户网站