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

11-5 新增記錄

12. 選單管理(下) next

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

一、流程

```
<pre class="brush:as3;">

#顯示單筆
  case "op_show":
    op_show($sn);
  break;
```

當新增、編輯記錄完成後，則顯示單筆記錄。

因此在新增的流程修改為：

```
<pre class="brush:as3;highlight:[4];">

#新增記錄
  case "op_insert":
    $sn=op_insert();
    redirect_header("nav_m.php?op=op_show&sn={$sn}",3000,"新增資料成功！！");
  break;
```

二、函數

```
<pre class="brush:as3;">

########################################
# 顯示單筆
########################################
function op_show($sn="")
{
  global $mysqli,$smarty;
  if(!$sn)redirect_header("index.php",3000,"查詢選單資料錯誤！！");

#取得單筆記錄，可以寫成函數
  $sql = "select *
          from `show_kind`
          where `sn`='{$sn}' and `kind`='nav_home'";
  $result =  $mysqli->query($sql) or die(printf("Error: %s <br>".$sql, $mysqli->sqlstate));
  $DBV = $result->fetch_assoc();

#過濾撈出資料
  $DBV['sn'] = intval($DBV['sn']);
  //http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
  $DBV['title'] = htmlspecialchars($DBV['title'], ENT_QUOTES); // 轉換雙引號和單引號
  $DBV['url'] = htmlspecialchars($DBV['url'], ENT_QUOTES); // 轉換雙引號和單引號
  $DBV['sort'] = intval($DBV['sort']);
  $DBV['enable'] = $DBV['enable'] ? "是":"<span style='color:red;'>否</span>";
  $DBV['target'] = $DBV['target'] ? "是":"<span style='color:red;'>否</span>";

$smarty->assign("DBV", $DBV);
  return;
}
```

三、樣板

```
<pre class="brush:as3;">

{* 選單管理 顯示單筆 *}
    {if $WEB.file_name == "nav_m.php" and $op == "op_show"}
      <div class="container" style="margin-top:20px;">
        <div class="panel panel-primary">
          <div class="panel-heading">
            <h3 class="panel-title">顯示單筆</h3>
          </div>
          <div class="panel-body">

<div class="row">
                <div class="col-md-6">
                  <div class="form-group">
                    <label>標題</label>
                    <div class="form-control">{$DBV.title}</div>
                  </div>
                </div>
                <div class="col-md-2">
                  <div class="form-group">
                    <label style="display:block;">外連狀態</label>
                    <div class="form-control">{$DBV.target}</div>
                  </div>
                </div>
                <div class="col-md-2">
                  <div class="form-group">
                    <label style="display:block;">啟用狀態</label>
                    <div class="form-control">{$DBV.enable}</div>
                  </div>
                </div>
                <div class="col-md-2">
                  <div class="form-group">
                    <label>排序</label>
                    <div class="form-control">{$DBV.sort}</div>
                  </div>
                </div>
              </div>

</div>
        </div>
      </div>
    {/if}
```

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown