Jill 筆記 - 線上書籍

:::

PHP從入門到放棄實戰班
============

### 二、 顯示單筆資料

1. 流程加入編號判斷 
  ```php
  //index.php
  /********************流程判斷*********************/
  // 變數過濾
  /****省略******/
  $sn = isset($_REQUEST['sn']) ? (int) $_REQUEST['sn'] : "";
  switch ($op) {
      /****省略******/
  
      default:
          if (empty($sn)) {
              //列出所有事項
              list_all();
          } else {
              $content = find_one($sn);
              $op      = 'show_one';
          }
          break;
  }
  ```
2. 改寫 `find_one();` 
  ```php
  //以流水號取得某筆資料
  function find_one($sn = "")
  {
      global $db;
  
      if (empty($sn)) {
          die(redirect_page($db->error));
      }
  
      $sql = "select * from list where `sn` = '{$sn}'";
  
      if (!$result = $db->query($sql)) {
          die(redirect_page($db->error));
      }
  
      $data = $result->fetch_assoc();
      if (empty($data)) {
          redirect_page('無此編號', 'index.php');
  
      } else {
          // 複選框$data['assign']
          $data['assign_arr'] = explode(';', $data['assign']);
          // die(var_dump($data));
          return $data;
      }
  
  }
  ```
3. template/show\_one.tpl 
  ```markup
  <div class="container">
    <div class="jumbotron">
      <h2 class="text-center"><a href="{$action}"><i class="fa fa-reply"></i> {$content.title}</a></h2>
  
      <div class="alert alert-warning text-right">
        是否完成：
        {if $content.done}
            <span class="badge badge-success text-center"><i class="fas fa-check"></i></span>
        {else}
            <span class="badge badge-danger text-center"><i class="fas fa-times-circle"></i></span>
        {/if}
      </div>
  
      <div class="row">
          <label class="col-sm-3 text-right">
              描述
          </label>
          <div class="col-sm-9">
              {$content.directions|nl2br}
          </div>
      </div>
  
      <div class="row">
        <label class="col-sm-3 text-right">
          到期日
        </label>
        <div class="col-sm-9">
            {$content.end}
        </div>
      </div>
  
      <div class="row">
        <label class="col-sm-3 text-right">
          優先順序
        </label>
        <div class="col-sm-9">
            {$content.priority}
        </div>
      </div>
  
      <div class="row">
        <label class="col-sm-3 text-right">
          指派對象
        </label>
        <div class="col-sm-9">
            {$content.assign}
        </div>
      </div>
  
      <div class="row">
        <label class="col-sm-3 text-right">
          建立時間
        </label>
        <div class="col-sm-9">
            {$content.create_time}
        </div>
      </div>
  
      <div class="row">
        <label class="col-sm-3 text-right">
          最後更新時間
        </label>
        <div class="col-sm-9">
            {$content.update_time}
        </div>
      </div>
  
      <div class="text-right">
        <a href="{$action}?op=post_form&sn={$content.sn}" class="btn btn-warning">編輯</a>
        <a href="{$action}" class="btn btn-success">回首頁</a>
    </div>
    </div>
  </div>
  
  ```

MarkDown