MarkDown

網站程式設計-PHP ========== /admin/system.php ``` <pre class="brush:as3;"> <?php /*---- 必須引入----*/ require_once 'head.php'; $WEB['title'] = "系統變數管理"; #程式流程 #取得主要資料庫 $tbl = "creative_system"; #引入上傳物件 include_once WEB_PATH . "/class/ugmUpFiles.php"; #Foreign key $kind_arr = array( "meta" => array("title" => "meta"), "slider" => array("title" => "輪播圖"), ); #整理傳入變數 $op = isset($_REQUEST['op']) ? $_REQUEST['op'] : ""; $sn = isset($_REQUEST['sn']) ? intval($_REQUEST['sn']) : ""; $kind = isset($_REQUEST['kind']) ? $_REQUEST['kind'] : "meta"; $name = isset($_REQUEST['name']) ? $_REQUEST['name'] : ""; #程式流程 switch ($op) { #ajax拖曳排序 case "op_ajax_update_sort": echo op_ajax_update_sort(); exit; break; #新增(Create) case "op_insert": op_insert(); redirect_header($_SESSION['op_list'], 3000, '新增資料成功！！'); exit; break; #更新(Update) case "op_update": op_update($sn); redirect_header($_SESSION['op_list'], 3000, '編輯資料成功！！'); exit; break; #顯示單筆(Read) case "op_show": op_show($sn); break; #表單 case "op_form": op_form($sn); break; #讀取(Read) default: $op = "op_list"; $_SESSION['op_list'] = getCurrentUrl(); op_list($kind, $name); break; } /*---- 將變數送至樣版----*/ $smarty->assign("WEB", $WEB); $smarty->assign("op", $op); /*---- 程式結尾-----*/ $smarty->display('theme.html'); /*---- 函數區-----*/ ############################################################################### # 自動更新排序 ############################################################################### function op_ajax_update_sort() { global $mysqli; $tbl = $_POST['tbl']; $key = $_POST['key']; $name = $_POST['name']; $sort = 1; foreach ($_POST[$name] as $sn) { $sql = "update {$tbl} set `sort`='{$sort}' where `{$key}`='{$sn}'"; $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate)); $sort++; } return "Save Sort OK! (" . date("Y-m-d H:i:s") . ")"; } ################################# # 列表程式 ################################# function op_list($kind, $name) { global $mysqli, $smarty, $tbl, $kind_arr; # 預設Foreign key=> system #---- 防呆 if (!in_array($kind, array_keys($kind_arr))) { $kind = "meta"; } # ----得到Foreign key選單 ---------------------------- $kind_option = ""; foreach ($kind_arr as $key => $value) { $selected = ""; if ($kind == $key) { $selected = " selected"; } $kind_option .= "<option value='{$key}'{$selected}>{$value['title']}</option>"; } $kind_form = " <select name='kind' id='kind'class='form-control' onchange=\"location.href='?kind='+this.value\"> $kind_option </select> "; $smarty->assign('kind_form', $kind_form); $smarty->assign('kind', $kind); #------------------------------------------- $sql = "select * from `{$tbl}` where kind='{$kind}' and enable='1' order by sort"; //die($sql); $result = $mysqli->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $i = 1; $rows = array(); while ($row = $result->fetch_assoc()) { #sn name title value description formtype valuetype sort enable kind $row['sn'] = intval($row['sn']); $row['name'] = htmlspecialchars($row['name'], ENT_QUOTES); // 轉換雙引號和單引號 $row['kind'] = htmlspecialchars($row['kind'], ENT_QUOTES); // 轉換雙引號和單引號 /* formtype 「yesno」是否的單選框 「select」下拉選單 「textbox」文字框 「textarea」大量文字框 */ if ($row['formtype'] == "textbox") { #---- 文字框 $row['value'] = htmlspecialchars($row['value'], ENT_QUOTES); // 轉換雙引號和單引號 } elseif ($row['formtype'] == "textarea") { #---- 大量文字框 $row['value'] = nl2br(htmlspecialchars($row['value'], ENT_QUOTES)); // 轉換雙引號和單引號 } elseif ($row['formtype'] == "fck") { #---- fck編輯器 $html = 1; $br = 0; $row['value'] = htmlspecialchars($row['value']); } elseif ($row['formtype'] == "file") { $multiple = ($row['valuetype'] == "multiple_img") ? true : false; //圖檔數量 $dirName = "creative"; //專案名稱 $subdir = "/{$row['kind']}"; //子目錄 $ugmUpFiles = new ugmUpFiles($dirName, $subdir, "/file", "/image", "/image/thumbs", $multiple); $ugmUpFiles->set_col($row['name'], $row['sn']); //指定sn $row['value'] = $ugmUpFiles->list_show_file(); } elseif ($row['formtype'] == "yesno") { $row['value'] = ($row['value']) ? "是" : "<span class='text-danger'>否</span>"; } $row['title'] = htmlSpecialChars($row['title']); $row['description'] = htmlSpecialChars($row['description']); $row['sort'] = $i; $i++; $rows[] = $row; } # ------------------------------------------------------------ //print_r($rows);die(); $smarty->assign("rows", $rows); return; } ################################# # 更新資料 # ################################# function op_update($sn = "") { global $mysqli; if (!$sn) { redirect_header("index.php", 3000, "更新記錄錯誤！！"); } $row = get_creative_system($sn); //取得單筆記錄 if ($row) { if ($row['formtype'] == "file") { if ($row['valuetype'] == "single_img") { #單圖 $dirName = "creative"; $subdir = "/{$row['kind']}"; $multiple = false; $ugmUpFiles = new ugmUpFiles($dirName, $subdir, "/file", "/image", "/image/thumbs", $multiple); $ugmUpFiles->set_col($row['name'], $row['sn']); //上傳 //($upname = 'upfile', $main_width = "1280", $thumb_width = "120", $files_sn = "", $desc = NULL, $safe_name = false, $hash = false) $name = $row['name']; $main_width = "1280"; $thumb_width = "120"; $files_sn = ""; $desc = NULL; $safe_name = true; $hash = false; $ugmUpFiles->upload_file($name, $main_width, $thumb_width, $files_sn, $desc, $safe_name, $hash); } elseif ($row['valuetype'] == "multiple_img") { #單圖 $dirName = "creative"; $subdir = "/{$row['kind']}"; $multiple = true; $ugmUpFiles = new ugmUpFiles($dirName, $subdir, "/file", "/image", "/image/thumbs", $multiple); $ugmUpFiles->set_col($row['name'], $row['sn']); //上傳 //($upname = 'upfile', $main_width = "1280", $thumb_width = "120", $files_sn = "", $desc = NULL, $safe_name = false, $hash = false) $name = $row['name']; $main_width = "1920"; $thumb_width = "120"; $files_sn = ""; $desc = NULL; $safe_name = true; $hash = false; $ugmUpFiles->upload_file($name, $main_width, $thumb_width, $files_sn, $desc, $safe_name, $hash); } return; } } #資料過濾 $_POST['sn'] = intval($_POST['sn']); $_POST['value'] = $mysqli->real_escape_string($_POST['value']); $sql = "update `creative_system` set `value` = '{$_POST['value']}' where sn='{$_POST['sn']}'"; $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate)); return; } ################################# # 顯示單筆 # ################################# function op_show($sn = "") { } ################################# # 表單 # 新聞關鍵字 icon_home ################################# function op_form($sn = "") { global $mysqli, $smarty; if (!$sn) { redirect_header("index.php", 3000, "資料錯誤！！"); } #編輯 $row = get_creative_system($sn); //取得單筆記錄 $row['op'] = "op_update"; $row['form_title'] = "編輯系統變數"; if ($row['formtype'] == "file") { if ($row['valuetype'] == "single_img") { $dirName = "creative"; //專案名稱 $subdir = "/{$row['kind']}"; //子目錄 $multiple = false; $ugmUpFiles = new ugmUpFiles($dirName, $subdir, "/file", "/image", "/image/thumbs", $multiple); $ugmUpFiles->set_col($row['name'], $row['sn']); $name = $row['name']; //欄名 $accept = "image/*"; //可接受副檔名 $show = "show"; //顯示縮圖 $width = 3; //縮圖寬度 $row['form'] = $ugmUpFiles->upform($name, $accept, $show, $width); } elseif ($row['valuetype'] == "multiple_img") { $dirName = "creative"; //專案名稱 $subdir = "/{$row['kind']}"; //子目錄 $multiple = true; $ugmUpFiles = new ugmUpFiles($dirName, $subdir, "/file", "/image", "/image/thumbs", $multiple); $ugmUpFiles->set_col($row['name'], $row['sn']); $name = $row['name']; //欄名 $accept = "image/*"; //可接受副檔名 $show = "show"; //顯示縮圖 $width = 3; //縮圖寬度 $row['form'] = $ugmUpFiles->upform($name, $accept, $show, $width); } } elseif ($row['formtype'] == "textbox") { $row['form'] = "<input type='text' class='form-control' name='value' id='value' value='{$row['value']}'>"; } elseif ($row['formtype'] == "textarea") { $row['form'] = "<textarea class='form-control' rows='5' id='value' name='value'>{$row['value']}"; } elseif ($row['formtype'] == "fck") { $row['form'] = ""; } elseif ($row['formtype'] == "yesno") { $value_1 = $row['value'] ? " checked" : ""; $value_0 = $row['value'] ? "" : " checked"; $row['form'] = "\n 是  \n \n 否"; } #把變數送至樣板 $smarty->assign("row", $row); } ######################################## #取得單筆記錄 ######################################## function get_creative_system($sn = "") { global $mysqli; if (!$sn) { redirect_header("index.php", 3000, "查詢系統變數資料錯誤！！"); } $sql = "select * from `creative_system` where `sn`='{$sn}'"; $result = $mysqli->query($sql) or die(printf("Error: %s
" . $sql, $mysqli->sqlstate)); $row = $result->fetch_assoc(); #過濾撈出資料 $row['sn'] = intval($row['sn']); //http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp $row['name'] = htmlspecialchars($row['name'], ENT_QUOTES); // 轉換雙引號和單引號 $row['kind'] = htmlspecialchars($row['kind'], ENT_QUOTES); // 轉換雙引號和單引號 $row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號 $row['value'] = htmlspecialchars($row['value'], ENT_QUOTES); // 轉換雙引號和單引號 $row['description'] = htmlspecialchars($row['description'], ENT_QUOTES); // 轉換雙引號和單引號 $row['formtype'] = htmlspecialchars($row['formtype'], ENT_QUOTES); // 轉換雙引號和單引號 $row['valuetype'] = htmlspecialchars($row['valuetype'], ENT_QUOTES); // 轉換雙引號和單引號 $row['enable'] = intval($row['enable']); $row['sort'] = intval($row['sort']); return $row; } ```