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

本文涉及的产品
云数据库 RDS MySQL Serverless,0.5-2RCU 50GB
简介: //survey.php

//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>                                                                                                                                                         

相关实践学习
基于CentOS快速搭建LAMP环境
本教程介绍如何搭建LAMP环境,其中LAMP分别代表Linux、Apache、MySQL和PHP。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心,利用清洁计算为万物互联的新世界提供源源不断的能源动力,目前开服的区域包括中国(华北、华东、华南、香港)、新加坡、美国(美东、美西)、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程,来了解阿里云能够为你的业务带来哪些帮助 &nbsp; &nbsp; 相关的阿里云产品:云服务器ECS 云服务器 ECS(Elastic Compute Service)是一种弹性可伸缩的计算服务,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
相关文章
|
SQL PHP 数据安全/隐私保护
|
SQL PHP 数据库
|
SQL PHP 数据库
PHP的bbs实现之一
0.sql CREATE TABLE user_log (  log_id int(10) NOT NULL auto_increment,  nicker        varchar(20...
687 0
|
SQL 前端开发 PHP
PHP的bbs实现之三
 邮件发送功能实现: sql语句: CREATE TABLE ourmail2 (  email_addr  varchar(40) NOT NULL,  create_time  var...
957 0
|
PHP 数据库 SQL
PHP的bbs实现之四--创建调查
//createsurvey.sql CREATE TABLE survey (  title  varchar(60) NOT NULL,  totalfield    int(1),  o...
904 0
|
7月前
|
关系型数据库 MySQL PHP
PHP 原生操作 Mysql
PHP 原生操作 Mysql
81 0
|
7月前
|
关系型数据库 MySQL 数据库连接
PHP 原生连接 Mysql
PHP 原生连接 Mysql
107 0
|
7月前
|
关系型数据库 MySQL Unix
PHP MySql 安装与连接
PHP MySql 安装与连接
127 0