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>