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

PHP SMARTY 樣板引擎
===============

一、流程  
 [20171122](https://drive.google.com/a/ugm.com.tw/file/d/1DclwGiVbe3KeXbcIW7-S2qZsPVILd9ok/view?usp=sharing)

```
<pre class="brush:as3;">
  default:
    $op = "opList";
    $_SESSION['returnUrl'] = getCurrentUrl();
    opList();
    break;  
```

二、函數

1. 列表會有畫面，所以需global $smarty
2. 剛開始可以用「\*」撈所有欄位，後面再選擇要顯示的欄位即可
3. 排序預設為「小->大」，「desc」為 「大->小」，多欄位排序，只要用「,」隔開即可
4. $result 結果  
   ![](https://www.ugm.com.tw/uploads/tad_book3/image/10602/11/11-2.jpg)
5. 因為不知道有多少記錄，所以用「while」迴圈，取得單筆記錄  
   break：中斷迴圈，但一次只中斷一層(如果是巢狀迴圈)  
   continue：跳至下一個循環
6. 再把單筆記錄整理至 $rows」，然後送去樣板
7. $rows  
   ![](https://www.ugm.com.tw/uploads/tad_book3/image/10602/11/11-3.jpg)  
   ![](https://www.ugm.com.tw/uploads/tad_book3/image/10602/11/11-3-1.jpg)
8. 
 
 ```
<pre class="brush:as3;">
###############################
# 商品列表
###############################
function opList(){
  global $smarty,$db;
  #撈商品資料
  $sql = "select *
          from `ugm_p_prod`
          order by `sort` desc
  ";//die($sql);
  $result = $db->query($sql) or redirect_header("", 3000,  $db->error."\n".$sql,true);
  #查詢筆數
  $count = $result->num_rows;

$rows=[];
  while($row = $result->fetch_assoc()){
    #過濾資料
    $row['sn'] = intval($row['sn']);
    $row['kind'] = intval($row['kind']);
    $row['title'] = htmlspecialchars($row['title'], ENT_QUOTES);    
    $row['summary'] = htmlspecialchars($row['summary'], ENT_QUOTES);    
    //$row['content'] = htmlspecialchars($row['content'], ENT_QUOTES);    
    $row['price'] = intval($row['price']);
    $row['amount'] = intval($row['amount']);
    $row['enable'] = intval($row['enable']);
    $row['choice'] = intval($row['choice']);
    $row['date'] = intval($row['date']);
    $row['date'] = date("Y-m-d",$row['date']);//格式化
    $row['sort'] = intval($row['sort']);
    $row['counter'] = intval($row['counter']);
    $row['icon'] = htmlspecialchars($row['icon'], ENT_QUOTES);
    $row['img'] = getProdImgPath("prod",$row['sn']);

$rows[] = $row;
  }
  //print_r($rows);die();
  $smarty->assign("rows", $rows);//送至樣板
}

三、樣板

1. <img src="<{$row.img}>" style="width:80px;" class='img-responsive'>  
   src：圖片位置   
   style：css 語法  
   img-responsive：bootstrap 圖片響應
2. smrty foreach  
   from=<span style="color:#FF0000;">$rows</span> item=<span style="color:#FF0000;">row</span> key=<span style="color:#FF0000;">k </span>  
   $rows：從程式端送來的變數，一筆一筆解出  
   row：接收解出變數  
   k：索引值
3. 
 
 ```
<pre class="brush:as3;">
<{if $op == "opList"}>
	<div class="panel panel-primary">
	  <div class="panel-heading">商品管理 - 列表</div>
	  <div class="panel-body">
	    <table class="table table-condensed">
        <thead>
          <tr>
            <th>縮圖</th>
            <th>日期</th>
            <th>標題</th>
            <th>排序</th>
            <th>精選</th>
            <th>啟用</th>
            <th class="text-center">
              <a href="admin_prod.php?op=opForm" class="btn btn-primary btn-xs">新增</a>
            </th>
          </tr>
        </thead>
			  <tbody>
          <{foreach from=$rows item=row key=k}>
            <tr id="tr_<{$row.sn}>" sn="<{$row.sn}>">
              <td><img src="<{$row.img}>" style="width:80px;" class='img-responsive'></td>
              <td><{$row.date}></td>
              <td><{$row.title}></td>
              <td><{$row.sort}></td>
              <td><{$row.choice}></td>
              <td><{$row.enable}></td>
              <td class="text-center">            
              </td>
            </tr>
          <{/foreach}>
			  </tbody>
			</table>
	  </div>
	</div>
<{/if}>
```

四、圖解  
 ![](https://docs.google.com/drawings/d/e/2PACX-1vSiEk5BMCOvWfQo8Uw1gySNgn2JS9CW8PqExw19kT_8yQ99ttaXU6XZqctwrGEiyvcMbzYM3kTwTBdS/pub?w=770&h=820)

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown