12-1 index.php

<?php
//引入共同檔
require_once "header.php";

//變數初始化
$op=isset($_REQUEST['op'])?$_REQUEST['op']:"";
//$class_sn=isset($_REQUEST['class_sn'])?intval($_REQUEST['class_sn']):"";

//流程控制
switch($op){

  case "insert_article":
  insert_article();
  header("location:{$_SERVER['PHP_SELF']}");
  break;

  default:
  $main=article_form();
  break;
}


//套用樣板
theme("theme.html");

/*************** 功能函數區 **************/

//輸入學習收藏的表單
function article_form(){
  $now_seme=get_seme();

  $sql="select class_sn,class_name from tncomu_class where access='1' and seme='{$now_seme}' ";
  $result=mysql_query($sql);
  $opt="";
  while(list($class_sn,$class_name)=mysql_fetch_row($result)){
    $opt.="<option value='$class_sn'>$class_name</option>";
  }


  $main="<h3 style='color:#0066CC'>輸入學習收藏</h3>
  <form action='{$_SERVER['PHP_SELF']}' method='post'>
    <table>
      <tr>
        <th>您的姓名：</th>
        <td><input type='text' name='stud_name' size='10'></td>
        <th>{$now_seme}班級：</th>
        <td>
          <select name='class_sn'>
            <option value=''>請選擇{$now_seme}班級</option>
            $opt
          </select>
        </td>
      </tr>
      <tr>
        <th>學習收藏內容</th>
        <td colspan=3><textarea name='content' cols=50 rows=8></textarea></td>
      </tr>
      <tr>
        <th>設定密碼：</th>
        <td><input type='text' name='text_passwd' size='10'></td>
        <th>是否發布？</th>
        <td>
          <input type='radio' name='enable' value='1' id='enable'><label for='enable'>發布</label>
          <input type='radio' name='enable' value='0' id='unable'><label for='unable'>暫不發布</label>
          <input type='hidden' name='op' value='insert_article'>
          <input type='submit' value='儲存'>
        </td>
      </tr>
    </table>
  </form>
  ";
  return $main;
}


//執行儲存動作
function insert_article(){
  $sql="INSERT INTO `tncomu_article`(`stud_name`, `content`, `post_time`, `enable`, `class_sn`, `mode`, `text_passwd`) VALUES ('{$_POST['stud_name']}' , '{$_POST['content']}' , now(), '{$_POST['enable']}', '{$_POST['class_sn']}', '文字', '{$_POST['text_passwd']}')";
  mysql_query($sql) or die(mysql_error().$sql);
  return "儲存完畢";
}

//自動抓出目前學期
function get_seme(){
  $year=date("Y")-1911;
  $mon=date("n");
  if($mon<=2){
    $year=$year-1;
    $seme="{$year}2";
  }elseif($mon>=3 and $mon<=8){
    $seme="{$year}1";
  }else{
    $seme="{$year}2";
  }
  return $seme;
}

?>