:::
11-1 流動網格系統21-1 index.php
001 | <?php |
002 | //連線資料庫 |
003 | link_db("localhost" , "root" , "12345" , "tad"); |
004 | |
005 | //針對 op 變數進行整理 |
006 | $op = isset($_REQUEST['op'])?$_REQUEST['op']:""; |
007 | $sn = isset($_REQUEST['sn'])?intval($_REQUEST['sn']):""; //intval() 強制轉成數字 |
008 | |
009 | //流程控制 |
010 | switch($op){ |
011 | |
012 | //儲存榮譽榜資料 |
013 | case "insert": |
014 | insert(); |
015 | header("location:index.php"); |
016 | break; |
017 | |
018 | //發布表單 |
019 | case "post_form": |
020 | $main = post_form($sn); |
021 | break; |
022 | |
023 | //刪除 |
024 | case "delete": |
025 | delete($sn); |
026 | header("location:index.php"); |
027 | break; |
028 | |
029 | //更新榮譽榜資料 |
030 | case "update": |
031 | update($sn); |
032 | header("location:index.php"); |
033 | break; |
034 | |
035 | //列出所有榮譽榜 |
036 | default: |
037 | $main = list_all(); |
038 | break; |
039 | } |
040 | |
041 | ?> |
042 |
043 | <!DOCTYPE html> |
044 | <html> |
045 | <head> |
046 | <title>榮譽榜發布</title> |
047 | <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
048 | <meta http-equiv="content-type" content="text/html; charset=utf-8"> |
049 | <!-- Bootstrap --> |
050 | <link href="css/bootstrap.min.css" rel="stylesheet" media="screen"> |
051 | </head> |
052 | |
053 | <body> |
054 | <div class="row-fluid"> |
055 | |
056 | <div class="span3"></div> |
057 | |
058 | <div class="span6"> |
059 | <?php echo $main;?> |
060 | </div> |
061 | |
062 | <div class="span3"></div> |
063 | |
064 | </div> |
065 | |
066 | |
067 |
068 | <script src="http://code.jquery.com/jquery.js"></script> |
069 | <script src="js/bootstrap.min.js"></script> |
070 | </body> |
071 | </html> |
072 |
073 | <?php |
074 | //連線資料庫 |
075 | function link_db($location="localhost" , $id="" ,$passwd="" , $db=""){ |
076 | $link = mysql_connect($location , $id , $passwd); |
077 | if($link){ |
078 | mysql_query("SET NAMES 'utf8'"); |
079 | mysql_select_db($db); |
080 | return $link; |
081 | }else{ |
082 | die("連線失敗！"); |
083 | } |
084 | } |
085 |
086 | //新增到資料庫 |
087 | function insert(){ |
088 | |
089 | $award_winner = addslashes($_POST['award_winner']); |
090 | $award_date = addslashes($_POST['award_date']); |
091 | $award_kind = addslashes($_POST['award_kind']); |
092 | $award_content = addslashes($_POST['award_content']); |
093 | $award_enable = addslashes($_POST['award_enable']); |
094 | |
095 | $sql = "INSERT INTO `honor`(`award_winner`, `award_date`, `award_kind`, `award_content`, `award_enable`, `post_date`) VALUES ('{$award_winner}' , '{$award_date}' , '{$award_kind}' , '{$award_content}' , '{$award_enable}' , now())"; |
096 | |
097 | mysql_query($sql) or die(mysql_error()); |
098 | |
099 | } |
100 | |
101 | //更新到資料庫 |
102 | function update($sn=""){ |
103 | |
104 | $award_winner = addslashes($_POST['award_winner']); |
105 | $award_date = addslashes($_POST['award_date']); |
106 | $award_kind = addslashes($_POST['award_kind']); |
107 | $award_content = addslashes($_POST['award_content']); |
108 | $award_enable = addslashes($_POST['award_enable']); |
109 | |
110 |
111 | $sql = "UPDATE `honor` SET |
112 | `award_winner` = '{$award_winner}', |
113 | `award_date` = '{$award_date}', |
114 | `award_kind` = '{$award_kind}', |
115 | `award_content` = '{$award_content}', |
116 | `award_enable` = '{$award_enable}', |
117 | `post_date`= now() |
118 | WHERE `sn`= '{$sn}'"; |
119 | |
120 | mysql_query($sql) or die(mysql_error()); |
121 | |
122 | } |
123 | |
124 | //列出所有內容 |
125 | function list_all(){ |
126 | |
127 | $sql = "SELECT * FROM `honor` where `award_enable` = '1' order by `award_date` desc "; |
128 | $result = mysql_query($sql) or die(mysql_error()); |
129 | |
130 | |
131 | $table_content = ""; |
132 | while($data = mysql_fetch_assoc($result)){ |
133 | |
134 | //將換行轉為<br> |
135 | $award_content=nl2br($data['award_content']); |
136 | |
137 | $table_content .= " |
138 | <tr> |
139 | <td>{$data['award_winner']}</td> |
140 | <td>{$data['award_date']}</td> |
141 | <td>{$award_content}</td> |
142 | <td nowrap> |
143 | <a href='index.php?op=delete&sn={$data['sn']}' class='btn btn-danger btn-mini'>刪除</a> |
144 | <a href='index.php?op=post_form&sn={$data['sn']}' class='btn btn-warning btn-mini'>修改</a> |
145 | </td> |
146 | </tr> |
147 | "; |
148 | } |
149 | |
150 | $main=" |
151 | <h1> |
152 | <img src='img/gold.png'>榮譽榜 |
153 | <a href='index.php?op=post_form' class='btn btn-info'>發布</a> |
154 | </h1> |
155 | |
156 | <table class='table table-striped table-bordered'> |
157 | <tr> |
158 | <th>獲獎者</th> |
159 | <th>得獎日期</th> |
160 | <th>事由</th> |
161 | <th nowrap>功能</th> |
162 | </tr> |
163 | $table_content |
164 | </table> |
165 | |
166 | "; |
167 | |
168 | return $main; |
169 | } |
170 | |
171 | |
172 | //發布表單 |
173 | function post_form($sn=""){ |
174 | |
175 | $sql = "SELECT * FROM `honor` where `sn` = '{$sn}'"; |
176 | $result = mysql_query($sql) or die(mysql_error()); |
177 | $data = mysql_fetch_assoc($result); |
178 | |
179 | $date=empty($sn)?date("Y-m-d"):$data['award_date']; |
180 | |
181 | //還原下拉選單預設值 |
182 | $selected_0 = ($data['award_kind']== "校內") ? "selected" : ""; |
183 | $selected_1 = ($data['award_kind']== "校外") ? "selected" : ""; |
184 | |
185 | //還原單選鈕預設值 |
186 | $award_enable0 = ($data['award_enable']!= "1") ? "checked" : ""; |
187 | $award_enable1 = ($data['award_enable']== "1") ? "checked" : ""; |
188 | |
189 | $op = empty($sn)? "insert" : "update"; |
190 | |
191 | $form=" |
192 | <h1 class='text-center'>榮譽榜發布</h1> |
193 | |
194 | <form action='index.php' method='post' class='form-horizontal'> |
195 | <div class='well'> |
196 | <div class='control-group'> |
197 | <label class='control-label' for='award_winner'>得獎者名稱：</label> |
198 | <div class='controls'> |
199 | <input type='text' id='award_winner' name='award_winner' value='{$data['award_winner']}' class='span12' placeholder='請輸入得獎者名稱'> |
200 | </div> |
201 | </div> |
202 |
203 | <div class='control-group'> |
204 | <label class='control-label' for='award_date'>得獎日期：</label> |
205 | <div class='controls'> |
206 | <input type='text' id='award_date' name='award_date' value='{$date}' class='span12' placeholder='得獎日期格式：2013-07-09'> |
207 | </div> |
208 | </div> |
209 |
210 | <div class='control-group'> |
211 | <label class='control-label' for='award_kind'>類別：</label> |
212 | <div class='controls'> |
213 | <select name='award_kind' id='award_kind' class='span12'> |
214 | <option value='校內' $selected_0>校內</option> |
215 | <option value='校外' $selected_1>校外</option> |
216 | </select> |
217 | </div> |
218 | </div> |
219 |
220 | <div class='control-group'> |
221 | <label class='control-label' for='award_content'>得獎事由：</label> |
222 | <div class='controls'> |
223 | <textarea name='award_content' id='award_content' rows='4' class='span12'>{$data['award_content']}</textarea> |
224 | </div> |
225 | </div> |
226 |
227 | <div class='control-group'> |
228 | <label class='control-label' for='award_enable'>是否發布：</label> |
229 | <div class='controls'> |
230 |
231 | <label class='radio'> |
232 | <input type='radio' name='award_enable' id='award_enable1' value='1' {$award_enable1}>是，立即發布 |
233 | </label> |
234 |
235 | <label class='radio'> |
236 | <input type='radio' name='award_enable' id='award_enable0' value='0' {$award_enable0}>否，暫時隱藏 |
237 | </label> |
238 |
239 |
240 | <input type='hidden' name='op' value='{$op}'> |
241 | <input type='hidden' name='sn' value='{$sn}'> |
242 | <a href='index.php' class='btn'>回上頁</a> |
243 | <input type='submit' value='送出' class='btn btn-primary'> |
244 | </div> |
245 | </div> |
246 | </div> |
247 | </form> |
248 | "; |
249 | |
250 | return $form; |
251 | } |
252 | |
253 | |
254 | //刪除 |
255 | function delete($sn=""){ |
256 | |
257 | $sql = "DELETE FROM `honor` WHERE `sn` = '{$sn}'"; |
258 | |
259 | mysql_query($sql) or die(mysql_error()); |
260 | |
261 | } |
262 | ?> |
:::
搜尋
QR Code 區塊
快速登入
