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>