打印本文 打印本文  关闭窗口 关闭窗口
投票管理程序
作者:采集员 文章来源:来源于网络 点击数: 更新时间:2005/9/10 14:35:55
           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>";}

    ?>  

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

上一页  [1] [2] 



打印本文 打印本文  关闭窗口 关闭窗口