投票管理程序

投票管理程序

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

";
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 "<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>";   
               ?>   

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 ""; }
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 "<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>";   
               ?>   

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 ""; }
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 "你不能投空票!!!";}

?>    

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