投票管理程序

投票管理程序

表结构
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>";}

    ？>

【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】