育將電腦工作室 - 線上書籍

網站程式設計-PHP
==========

一、流程圖

![](https://docs.google.com/drawings/d/1V4tMEJF1L973rKhhiP5q6-8hN7COzuQ9h5Zzy_jCYIo/pub?w=961&h=334)

二、SQL 語法

1. 新增 ```
  <pre class="brush:as3;">
  
  #################################
  # 新增資料
  #
  #################################
  function op_insert() {
  	global $mysqli;
  
  	#資料過濾
  	#http://php.net/manual/en/mysqli.real-escape-string.php
  	$_POST['title'] = $mysqli->real_escape_string($_POST['title']);
  	$_POST['target'] = intval($_POST['target']);
  	$_POST['enable'] = intval($_POST['enable']);
  	$_POST['sort'] = intval($_POST['sort']);
  	$_POST['url'] = $mysqli->real_escape_string($_POST['url']);
  	$_POST['kind'] = $mysqli->real_escape_string($_POST['kind']);
  
  	$sql = "insert into `creative_nav`
            (`title`, `target`, `enable`, `sort`,`url`,`kind`)
            values
            ('{$_POST['title']}', '{$_POST['target']}', '{$_POST['enable']}', '{$_POST['sort']}', '{$_POST['url']}', '{$_POST['kind']}')";
  
  	$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
  
  	$sn = $mysqli->insert_id; //傳回insert 指令所產生之流水號
  
  	return $sn;
  }
  ```
2. 編輯 ```
  <pre class="brush:as3;">
  
  #################################
  # 更新資料
  #
  #################################
  function op_update($sn = "") {
  	global $mysqli;
  	if (!$sn) {
  		redirect_header("index.php", 3000, "更新記錄錯誤！！");
  	}
  
  	#資料過濾
  	$_POST['sn'] = intval($_POST['sn']);
  	$_POST['title'] = $mysqli->real_escape_string($_POST['title']);
  	$_POST['target'] = intval($_POST['target']);
  	$_POST['enable'] = intval($_POST['enable']);
  	$_POST['sort'] = intval($_POST['sort']);
  	$_POST['url'] = $mysqli->real_escape_string($_POST['url']);
  
  	$sql = "update `creative_nav` set
            `title`  = '{$_POST['title']}' ,
            `target` = '{$_POST['target']}',
            `enable` = '{$_POST['enable']}',
            `url` = '{$_POST['url']}',
            `sort` = '{$_POST['sort']}'
            where sn='{$_POST['sn']}'";
  
  	$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
  
  	return $sn;
  }
  ```
3. 刪除 ```
  <pre class="brush:as3;">
  
  #################################
  # 刪除資料
  #
  #################################
  function op_delete($sn = "") {
  	global $mysqli;
  	if (!$sn) {
  		redirect_header("index.php", 3000, "刪除記錄錯誤！！");
  	}
  	#
  	$sql = "delete
            from `creative_nav`
            where `sn`='{$sn}'"; //die($sql);
  	$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
  	return;
  }
  ```
4. 列表 ```
  <pre class="brush:as3;">
  
  #################################
  # 列表程式
  #
  #################################
  function op_list() {
  	global $mysqli, $smarty;
  
  	#取得所有記錄
  	$sql = "select *
            from `creative_nav`
            where `kind`='nav_home'
            order by `sort` "; //die($sql);
  
  	$result = $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
  
  	$rows = array();
  	while ($row = $result->fetch_assoc()) {
  		#過濾撈出資料
  		$row['sn'] = intval($row['sn']);
  		//http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
  		$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號
  		$row['url'] = htmlspecialchars($row['url'], ENT_QUOTES); // 轉換雙引號和單引號
  		$row['sort'] = intval($row['sort']);
  		$row['enable'] = intval($row['enable']);
  		$row['target'] = intval($row['target']);
  
  		$rows[] = $row;
  	}
  
  	$smarty->assign("rows", $rows);
  	return;
  }
  ```
5. 取得單筆記錄 ```
  <pre class="brush:as3;">
  
  ########################################
  #取得單筆記錄
  ########################################
  function get_creative_nav($sn = "") {
  	global $mysqli;
  	if (!$sn) {
  		redirect_header("index.php", 3000, "查詢選單資料錯誤！！");
  	}
  
  	$sql = "select *
            from `creative_nav`
            where `sn`='{$sn}' and `kind`= 'nav_home'";
  	$result = $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
  	$row = $result->fetch_assoc();
  
  	#過濾撈出資料
  	$row['sn'] = intval($row['sn']);
  	//http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
  	$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號
  	$row['url'] = htmlspecialchars($row['url'], ENT_QUOTES); // 轉換雙引號和單引號
  	$row['sort'] = intval($row['sort']);
  	$row['enable'] = intval($row['enable']);
  	$row['target'] = intval($row['target']);
  
  	return $row;
  }
  ```
 
三、樣板

1. theme.html ```
  <pre class="brush:as3;">
          <{if $WEB.file_name =="index.php"}>
            <{include file="tpl/admin_index.html"}>
          <{/if}>
  ```
2. tpl/admin\_index.html 列表 ```
  <pre class="brush:as3;">
  <{if $op == "op_list"}>
    <link rel="stylesheet" href="<{$smarty.const.WEB_URL}>/class/sweetalert/sweetalert.css" type="text/css">
    <script src="<{$smarty.const.WEB_URL}>/class/sweetalert/sweetalert.min.js" type="text/javascript"></script>
    <script type="text/javascript"> 
      function op_delete_js(sn){
        //警告視窗
        swal({
          title: '確定要刪除此資料？',
          text: '相關資料通通都將會被移除！',
          type: 'warning',
          showCancelButton: 1,
          confirmButtonColor: '#DD6B55',
          confirmButtonText: '確定刪除！',
          closeOnConfirm: false ,
          allowOutsideClick: true
        },
        function(){//確定
          location.href="?op=op_delete&sn="+sn;
        });
      }
    </script>
    <div class="panel panel-default">
      <div class="panel-heading">選單管理 - 列表</div>
      
      <div class="panel-body">
        <div class="table-responsive">
          <table class="table table-striped table-bordered table-hover">
            <thead>
              <tr class="active">   
                <th class="col-md-3 text-center">標題</th>
                <th class="col-md-3 text-center">網址</th>
                <th class="col-md-1 text-center">外連</th>
                <th class="col-md-1 text-center">狀態</th>
                <th class="col-md-1 text-center"><a href="?op=op_form" class="btn btn-xs btn-primary">新增</a></th>
              </tr>
            </thead>
            <tbody>
              <{foreach from=$rows item=row}>
                <tr>
                  <td class="text-center"><{$row.title}></td>
                  <td><{$row.url}></td>
                  <td class="text-center">
                    <{if $row.target == 1}>
                      <img src="<{$smarty.const.WEB_URL}>/images/yes.gif">
                    <{else}>
                      <img src="<{$smarty.const.WEB_URL}>/images/no.gif">
                    <{/if}>
                  </td>
                  <td class="text-center">
                    <{if $row.enable == 1}>
                      <img src="<{$smarty.const.WEB_URL}>/images/yes.gif">
                    <{else}>
                      <img src="<{$smarty.const.WEB_URL}>/images/no.gif">
                    <{/if}> 
                  </td>
                  <td class="text-center">                    
                    <a href="?op=op_form&sn=<{$row.sn}>" class="btn btn-xs btn-success">
                      編輯
                    </a>
                    <a href="javascript:op_delete_js(<{$row.sn}>);" class="btn btn-xs btn-danger">
                      刪除
                    </a>
                  </td>
                </tr> 
              <{/foreach}>
                                
            </tbody>
          </table>
        </div>
         
      </div>
      
    </div>
  <{/if}>
  ```
3. admin/admin\_index.html 表單 ```
  <pre class="brush:as3;">
  
  <{if $op == "op_form"}>
    <div class="panel panel-primary">
      <div class="panel-heading"><h3 class="panel-title">選單管理 - <{$row.form_title}></h3></div>
      <div class="panel-body">
        <form role="form" action="index.php" method="post" id="myForm">        
          <div class="row">
            <div class="col-md-6">
              <div class="form-group">
                <label>標題</label>
                <input type="text" name="title" id="title" class="form-control" value="<{$row.title}>" placeholder="標題" >
              </div>
            </div>
            <div class="col-md-6">
              <div class="form-group">
                <label>網址</label>
                <input type="text" name="url" id="url" class="form-control" value="<{$row.url}>" placeholder="網址">
              </div>
            </div>
            <div class="col-md-1">
              <div class="form-group">
                <label>排序</label>
                <input type="text" name="sort" id="sort" class="form-control" value="<{$row.sort}>">
              </div>
            </div>
            <div class="col-md-2">            
              <div class="form-group">
                <label style="display:block;">外連狀態</label>
                <input type="radio" name="target" id="target_1" value="1" <{if $row.target == 1}>checked<{/if}>>
                <label for="target_1">外連</label>  
                <input type="radio" name="target" id="target_0" value="0" <{if $row.target == 0}>checked<{/if}>>
                <label for="target_0">本站</label>
              </div>
            </div>
            <div class="col-md-2">            
              <div class="form-group">
                <label style="display:block;">啟用狀態</label>
                <input type="radio" name="enable" id="enable_1" value="1" <{if $row.enable == 1}>checked<{/if}>>
                <label for="enable_1">啟用</label>  
                <input type="radio" name="enable" id="enable_0" value="0" <{if $row.enable == 0}>checked<{/if}>>
                <label for="enable_0">停用</label>
              </div>
            </div>
          </div>
          <hr>
          <div class="text-center">
            <input type="hidden" name="op" value="<{$row.op}>">
            <input type="hidden" name="sn" value="<{$row.sn}>">
            <input type="hidden" name="kind" value="<{$row.kind}>">
  
            <button type="submit" class="btn btn-primary">送出</button>
            <button type="reset" class="btn btn-danger">重設</button>
            <button type="button" class="btn btn-warning" onclick="location.href='<{$smarty.session.op_list}>'">返回</button>
          </div>
        </form>
      </div>
    </div>
  <{/if}>
  ```
4.

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown