index.php

12-1 index.php
01<?php
02//引入共同檔
03require_once "header.php";
04 
05//變數初始化
06$op=isset($_REQUEST['op'])?$_REQUEST['op']:"";
07//$class_sn=isset($_REQUEST['class_sn'])?intval($_REQUEST['class_sn']):"";
08 
09//流程控制
10switch($op){
11 
12  case "insert_article":
13  insert_article();
14  header("location:{$_SERVER['PHP_SELF']}");
15  break;
16 
17  default:
18  $main=article_form();
19  break;
20}
21 
22 
23//套用樣板
24theme("theme.html");
25 
26/*************** 功能函數區 **************/
27 
28//輸入學習收藏的表單
29function article_form(){
30  $now_seme=get_seme();
31 
32  $sql="select class_sn,class_name from tncomu_class where access='1' and seme='{$now_seme}' ";
33  $result=mysql_query($sql);
34  $opt="";
35  while(list($class_sn,$class_name)=mysql_fetch_row($result)){
36    $opt.="<option value='$class_sn'>$class_name</option>";
37  }
38 
39 
40  $main="<h3 style='color:#0066CC'>輸入學習收藏</h3>
41  <form action='{$_SERVER['PHP_SELF']}' method='post'>
42    <table>
43      <tr>
44        <th>您的姓名：</th>
45        <td><input type='text' name='stud_name' size='10'></td>
46        <th>{$now_seme}班級：</th>
47        <td>
48          <select name='class_sn'>
49            <option value=''>請選擇{$now_seme}班級</option>
50            $opt
51          </select>
52        </td>
53      </tr>
54      <tr>
55        <th>學習收藏內容</th>
56        <td colspan=3><textarea name='content' cols=50 rows=8></textarea></td>
57      </tr>
58      <tr>
59        <th>設定密碼：</th>
60        <td><input type='text' name='text_passwd' size='10'></td>
61        <th>是否發布？</th>
62        <td>
63          <input type='radio' name='enable' value='1' id='enable'><label for='enable'>發布</label>
64          <input type='radio' name='enable' value='0' id='unable'><label for='unable'>暫不發布</label>
65          <input type='hidden' name='op' value='insert_article'>
66          <input type='submit' value='儲存'>
67        </td>
68      </tr>
69    </table>
70  </form>
71  ";
72  return $main;
73}
74 
75 
76//執行儲存動作
77function insert_article(){
78  $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']}')";
79  mysql_query($sql) or die(mysql_error().$sql);
80  return "儲存完畢";
81}
82 
83//自動抓出目前學期
84function get_seme(){
85  $year=date("Y")-1911;
86  $mon=date("n");
87  if($mon<=2){
88    $year=$year-1;
89    $seme="{$year}2";
90  }elseif($mon>=3 and $mon<=8){
91    $seme="{$year}1";
92  }else{
93    $seme="{$year}2";
94  }
95  return $seme;
96}
97 
98?>
12-1 index.php

搜尋

QR Code 區塊

快速登入

書籍目錄

線上使用者
