投票管理程序
表结构
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 $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 ;
       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 $my[0];echo ;
              echo $my[1] ;
    echo ;echo $my[2];echo ;
                 echo
;
                  }    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 ;
           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 ;
             @$result=mysql_query($sql);
             while($my=mysql_fetch_row($result))
            {
    echo ;echo ;echo $my[0];echo ;
              echo $my[1] ;
    echo ;echo $my[2];echo ;
         echo ;echo $my[3];echo ;
                 echo
;
                  }    echo ;
                   ?>
if($submit2!=添加)
             {     echo ;
             echo
;
        echo 选项:;
       echo ;
      echo ;
                    echo ;
           echo;   }
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 ;
            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 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 $myrow[0];echo ;echo $myrow[1]; echo
;} echo
;  }
  else
  {echo 你不能投空票!!!;}
    ?>  
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】    
以上就介绍了linux服务器配置与管理 投票管理程序，包括了linux服务器配置与管理方面的内容，希望对php教程有兴趣的朋友有所帮助。