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

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

一、觀察前台樣板

1. templates/default/tpl/creative\_nav.html
2. 樣板 ```
  <pre class="brush:as3;">
  
                  <li>
                      <a class="page-scroll" href="#about">About</a>
                  </li>
                  <li>
                      <a class="page-scroll" href="#services">Services</a>
                  </li>
                  <li>
                      <a class="page-scroll" href="#portfolio">Portfolio</a>
                  </li>
                  <li>
                      <a class="page-scroll" href="#contact">Contact</a>
                  </li>
  ```
3. 在後台建立資料  
   ![](https://www.ugm.com.tw/uploads/tad_book3/image/10502/tncomu/14/nav.jpg)
 
二、撈出資料

1. head.php ```
  <pre class="brush:as3;">
  
  #撈出選單
  nav_home();
  
  #################################
  # 撈出選單
  #
  #################################
  function nav_home() {
  	global $mysqli, $smarty;
  
  	#取得所有記錄
  	$sql = "select *
            from `creative_nav`
            where `kind`='nav_home' and `enable`='1'
            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("nav_home", $rows);
  	return;
  }
  ```
 
三、樣板處理

1. templates/default/tpl/creative\_nav.html  
   程式端：$smarty->assign("nav\_home", $rows); ```
  <pre class="brush:as3;">
  <nav id="mainNav" class="navbar navbar-default navbar-fixed-top">
    <div class="container">
      
      <div class="navbar-header">
        <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
            <span class="sr-only">Toggle navigation</span> Menu <i class="fa fa-bars"></i>
        </button>
        <a class="navbar-brand page-scroll" href="#page-top"><{$WEB.title}></a>
      </div>
  
      
      <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
        <ul class="nav navbar-nav navbar-right">
          <{foreach from=$nav_home item=row key=k}>
            <li><a class="page-scroll" href="<{$row.url}>" <{if $row.target==1}>target="_blank"<{/if}>><{$row.title}></a></li>
          <{/foreach}>
        </ul>
      </div>
      
      </div>
      
  </nav>
  ```

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown