PHP的bbs实现之四--创建调查-阿里云开发者社区

//createsurvey.sql

CREATE TABLE survey (
title varchar(60) NOT NULL,
totalfield int(1),
option1 varchar(60),
option2 varchar(60),
option3 varchar(60),
option4 varchar(60),
choice1 int(6),
choice2 int(6),
choice3 int(6),
choice4 int(6),
PRIMARY KEY (title),
UNIQUE title (title)
);

1.survey_admin.php

<?
include "common.inc.php";

if ($Ok)
{
   if ($choice=="addone")
      {
        if ($title=="")
          {
             header("Location: login_error.php?error=网上调查的标题为空/n");
          }
        if (($option1=="")||($option2==""))
          {
             header("Location: login_error.php?error=第一、二项不能为空/n");
          }

        $title_check = "select title from survey
          where title = '$title'";
        $check_result = mysql_query($title_check)
          or die("不能执行网上调查。");
        $check_num = mysql_num_rows($check_result);

        $n=2;
        if($option3!="")$n=3;
        if($option4!="")$n=4;

        if ($check_num == 0)
        {
             $sql = "insert into survey
                  values('$title','$n', '$option1','$option2',
                               '$option3','$option4',1,1,1,1)";

             @mysql_query($sql) or die ("无法添加网上调查");
             header("Location: on_ok.php?log_id=$log_id/n
                               &ok_info=网上调查添加成功");
         }
         else
         {
              header("Location: login_error.php?error=不能重复调查！/n");
         }
       }
    else
    if ($choice == "deleone")
        {
          $title_check = "select title from survey
              where title = '$title'";
          $check_result = mysql_query($title_check)
              or die("不能执行网上调查。");
          $check_num = mysql_num_rows($check_result);

          if ($check_num == 0)
            {
              header("Location: login_error.php?
                   error=你选择的网上调查不存在。/n");
             }
          else
            {
              $title_dele = "delete from survey
                  where title = '$title'";
              @mysql_query($title_dele) or die ("无法删除网上调查");
             header("Location: on_ok.php?log_id=$log_id/n");
             }
         }
     }
include "header.inc.php";
?>

<p align=center>
<font size=5 color=red >
      网上调查的管理
</font>
</p>

<hr color=red>

<BODY>
<FORM METHOD="POST" ACTION="<? echo $PHP_SELF; ?>">
<TABLE width=80% 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=center class=myRed>网上调查的标题：
        <INPUT type=text name=title size=60 maxlength=60>
      </TD>
    </TR>
    <TR >
      <TD height=50 align=center class=myRed>调查的第一项：
        <INPUT type=text name=option1 size=60 maxlength=60>
      </TD>
    </TR>
    <TR >
      <TD height=50 align=center class=myRed>调查的第二项：
        <INPUT type=text name=option2 size=60 maxlength=60>
      </TD>
    </TR>
    <TR >
      <TD height=50 align=center class=myRed>调查的第三项：
        <INPUT type=text name=option3 size=60 maxlength=60>
      </TD>
    </TR>
    <TR >
      <TD height=50 align=center class=myRed>调查的第四项：
        <INPUT type=text name=option4 size=60 maxlength=60>
      </TD>
    </TR>
    <TR>
      <td width="50%" align=center class=myRed>
        <input type="radio" name="choice" value="addone" checked>
        添&nbsp&nbsp加&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
        &nbsp&nbsp&nbsp&nbsp &nbsp&nbsp&nbsp&nbsp
        <input type="radio" name="choice" value="deleone" >
        删&nbsp&nbsp除&nbsp&nbsp </td>
    </TR>
    <TR>
      <TD height=20 align=center>
        <INPUT type=submit name=Ok value=" 提交 " class=myBlack>        　　　　　　　　　　　
        <INPUT type=reset name=Back value=" 还原 " class=myBlack>
      </TD>
    </TR>

</TABLE>
</FORM>
<DIV class=myGreen align=center>
    <? echo $COPYRIGHT; ?>
</DIV>
<BR>

</BODY>
</HTML>

2. survey_begin.php

<html>


<head>
   
   <title>
       网上调查
   </title>
   <meta http-equiv=content-type content="text/html; charset=gb2312">
</head>


<body background="images/st.jpg" >

<?
/********************************
*运行一个外部的程序             *
*其作用是定义一些常用的变量     *
*并进行和goldenwind数据库的连接 *
*********************************/
include "common.inc.php";

//查询数据库中是否有调查的项目
$survey_check = "select title from survey";
$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");
}
else
{
   //显示广告，可以是动态GIF格式
    include "ad.php";

/********************************
*显示本网页的大标题             *
*它随着日期中年月的变化而变化   *
*********************************/
    echo "<p align=center>";
    echo " <font size=5 color=red >";
    echo date(Y)."年".date(m)."月社区调查的内容是：";
    echo " </font>";
    echo "</p>";

    echo "<hr color=red>     ";
    echo "<p><p><p><p><p>";

    //变量$n用来记录每个调查的序号
    $n=1;
    $next="http://localhost/survey.php?title=";

    $result = mysql_query($survey_check)
        or die("不能进行网上调查。");
/********************************
*在WHILE循环中依次取出数据库表 *
*中的网上调查项，并把每一项做成 *
*一个超链接                     *
*********************************/
    while ($row=mysql_fetch_array($result))
    {
    //在网页中加入空白的符号，控制显示的位置
       for ($i=1;$i<15;$i++)
          echo "&nbsp";
    //显示生成的超链接
       echo "<A href=/"".$next.$row["title"]
            ."/">".$n.'.&nbsp&nbsp&nbsp&nbsp'
            . $row["title"]."</a><p><p><p>/n";
    //每次循环把序号加一
       $n++;
     }
   }
   //定义一些CSS的显示类
   include "header.inc.php"   ;
   ?>


<DIV class=myGreen align=center>
      <? echo $COPYRIGHT; ?>
</DIV>
</body>

</html>