投票管理程序

投票管理程序

表结构
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 “

“;
         echo “

“;
       echo “

“;       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 “”;      echo “ “;    while($myrow=mysql_fetch_row($result))    {    echo “$myrow[0]”;      echo ” “;                                          }    echo “ “;  echo “ “;   echo “”;    echo “ “;   echo “”;      echo “

“;
   mysql_close();
    echo “
“;
    echo “

“;
   echo “管理”; echo “

“;     ?>
———————————————————————–
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 “

“;
             $result=mysql_query($sql);
             while($my=mysql_fetch_row($result))
            {

    echo “

“;echo “

“;
              echo “

“;
    echo “

“;
                 echo “

“;

                  }    echo “

“;echo $my[0];echo “

$my[1]

“;echo $my[2];echo “

“;
                   ?>

  <?

           if($submit2!=”添加”)
             { echo “

“;
             echo “”;

        echo “主题:“;
       echo “”;

      echo “”;
                    echo “

“;
           echo””;   }

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 “”;  }
           if($submit1!=”有效”&&$submit3!=”删除”)
           {  echo “

“;
           echo “”;
           echo “设置主题:“;
   echo “”;
         $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 “$myrow[0]”;}

   echo “”;
     echo “”;
        echo “”;
       echo “

“;
echo “”;

           }
           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 “”;      }
    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 “”;      }

}
?>
——————————————————————–
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 “

“;
             @$result=mysql_query($sql);
             while($my=mysql_fetch_row($result))
            {

    echo “

“;echo “

“;
              echo “

“;
    echo “

“;
         echo “

“;
                 echo “

“;

                  }    echo “

“;echo $my[0];echo “

$my[1]

“;echo $my[2];echo “

“;echo $my[3];echo “

“;
                   ?>

  <?

           if($submit2!=”添加”)
             {     echo “

“;
             echo “”;

        echo “选项:

“;
       echo “”;

      echo “”;
                    echo “

“;
           echo””;   }

else
      {$db =mysql_connect(“localhost”, “root”,”391450″);
m来源gaodaimacom搞#^代%!码网ysql_select_db(“class”,$db);

$sql=”insert into pollsele values(”,’$title’,”,’$id’,”)”;
mysql_query($sql);
mysql_close();
echo “”;  }
           if($submit1!=”有效”&&$submit3!=”无效”)
           {  echo “

“;
           echo “”;
            echo “设置选项:“;
   echo “”;
         $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 “$myrow[0]”;}

   echo “”;
     echo “”;
        echo “”;
      echo “

“;
echo “”;

           }
           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 “”;      }

?>
———————————————————————-
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 “

“;
      echo $title[0]; echo “

“;
      echo “
“;
       $sql=”select Pollsele_Name,pollsele_num from pollsele where pollsele_del=’0′ and pollsele_poll_id=’$poll_id'”;
@$result = mysql_query($sql);
      echo “

“;
  while($myrow=mysql_fetch_row($result))
  {   echo “

“; echo “

“;} echo “

“;   echo $myrow[0];echo “

“;echo $myrow[1]; echo “

“;  }
  else
  {echo “你不能投空票!!!“;}

    ?>  

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