PHP的bbs实现之五--创建调查2

//survey.php

<?                                                                                                                                                             
include "common.inc.php";                                                                                                                                      
                                                                                                                                                               
if(!$Ok)                                                                                                                                                       
{                                                                                                                                                              
  global $PHP_SELF;                                                                                                                                            
                                                                                                                                                               
  $survey_check = "select * from survey where title='$title'";                                                                                                 
  $check_result = mysql_query($survey_check)                                                                                                                   
    or die("无法进行网上调查。");                                                                                                                              
                                                                                                                                                               
  $check_num = mysql_num_rows($check_result);                                                                                                                  
  if ($check_num == 0)                                                                                                                                         
    {                                                                                                                                                          
      header("Location: login_error.php?error=没有找到该调查项目！\n");                                                                                        
    }                                                                                                                                                          
                                                                                                                                                               
  $check_result = mysql_query($survey_check) ;                                                                                                                 
  $row=mysql_fetch_array($check_result);                                                                                                                       
                                                                                                                                                               
  $number=$row["totalfield"];                                                                                                                                  
  $option1=$row["option1"];                                                                                                                                    
  $option2=$row["option2"];                                                                                                                                    
  if ($number>2)                                                                                                                                               
   {                                                                                                                                                           
    $option3=$row["option3"];                                                                                                                                  
   }                                                                                                                                                           
  if ($number==4)                                                                                                                                              
   {                                                                                                                                                           
    $option4=$row["option4"];                                                                                                                                  
   }                                                                                                                                                           
                                                                                                                                                               
   $next_action=$PHP_SELF;                                                                                                                                     
   $next_action.='?title='.$title;                                                                                                                             
                                                                                                                                                               
   include "header.inc.php";                                                                                                                                   
   include "ad.php";                                                                                                                                           
}                                                                                                                                                              
else                                                                                                                                                           
{                                                                                                                                                              
  $survey_check = "select * from survey where title='$title'";                                                                                                 
  $check_result = mysql_query($survey_check)                                                                                                                   
    or die("无法进行网上调查。");                                                                                                                              
                                                                                                                                                               
  $choice_now="choice".$choice;                                                                                                                                
  $row=mysql_fetch_array($check_result);                                                                                                                       
  $new_value=$row[$choice_now] ;                                                                                                                               
  $new_value++;                                                                                                                                                
                                                                                                                                                               
  $SQL="UPDATE survey SET $choice_now='$new_value'                                                                                                             
    where title='$title'";                                                                                                                                     
  mysql_query($SQL) or die(mysql_error());                                                                                                                     
  header("Location: survey_view.php?title=$title");                                                                                                            
}                                                                                                                                                              
?>                                                                                                                                                             
                                                                                                                                                               
<body  background="images/st.jpg" >                                                                                                                            
                                                                                                                                                               
<FORM METHOD="POST" ACTION="<? echo $next_action;?>">                                                                                                          
  <TABLE width=60% border=0 align=center bgcolor=yellow>                                                                                                       
    <TR  bgcolor=green>                                                                                                                                        
      <TD height=20 align=center>                                                                                                                              
           <FONT  class=myYellow>                                                                                                                              
             欢迎来到网上调查！                                                                                                                                
          </FONT>                                                                                                                                              
      </TD>                                                                                                                                                    
    </TR>                                                                                                                                                      
    <TR >                                                                                                                                                      
      <TD height=50 align=left>                                                                                                                                
        <font size=3 color=blue >                                                                                                                              
          <?                                                                                                                                                   
               for ($i=1;$i<10;$i++)                                                                                                                           
                  echo "&nbsp";                                                                                                                                
               echo $title;?>                                                                                                                                  
        </font>                                                                                                                                                
      </TD>                                                                                                                                                    
    </TR>                                                                                                                                                      
<?                                                                                                                                                             
$n=1;                                                                                                                                                          
while ($n<=$number)                                                                                                                                            
{                                                                                                                                                              
  $option_now="option".$n;                                                                                                                                     
                                                                                                                                                               
  echo  "<TR>";                                                                                                                                                
  echo  "<td width=\"50%\" align=left class=myRed>";                                                                                                           
  for ($i=1;$i<15;$i++)                                                                                                                                        
      echo "&nbsp";                                                                                                                                            
  echo  "<input type=\"radio\" name=\"choice\" value=".$n;                                                                                                     
  if ($n==1)                                                                                                                                                   
    {                                                                                                                                                          
     echo " checked";                                                                                                                                          
    }                                                                                                                                                          
  echo ">";                                                                                                                                                    
  echo  $$option_now;                                                                                                                                          
  echo  " </td>";                                                                                                                                              
  echo  "  </TR>";                                                                                                                                             
  $n++;                                                                                                                                                        
}                                                                                                                                                              
?>                                                                                                                                                             
    <TR>                                                                                                                                                       
      <TD height=20 align=center>                                                                                                                              
        <INPUT type=submit name=Ok value=" 提交 " class=myBlack>        　　　　　　　　　　　                                                                 
      </TD>                                                                                                                                                    
    </TR>                                                                                                                                                      
                                                                                                                                                               
  </TABLE>                                                                                                                                                     
</FORM>                                                                                                                                                        
                                                                                                                                                               
<DIV class=myGreen align=center>                                                                                                                               
    <? echo $COPYRIGHT; ?>                                                                                                                                     
</DIV>                                                                                                                                                         
                                                                                                                                                               
</BODY>