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

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

一、op\_form()

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

$DirName = "icon";
	mk_dir(WEB_PATH . "/uploads/{$DirName}");
	mk_dir(WEB_PATH . "/uploads/{$DirName}/image");
	mk_dir(WEB_PATH . "/uploads/{$DirName}/flash");
	include_once WEB_PATH . "/class/ck.php";
	$fck = new CKEditor($DirName, "content", $row['content']);
	$fck->setHeight(350);
	$row['content'] = $fck->render();
```

二、op\_form樣板

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

<div class="row"> 
          <div class="col-md-12">
            <div class="form-group">
              <label>內容</label>
              <{$row.content}>
            </div>
          </div>          
        </div>
```

三、多欄存成一欄的過濾方法

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

// $content['icon'] = $mysqli->real_escape_string($_POST['icon']);
  // $content['summary'] = $mysqli->real_escape_string($_POST['summary']);
  // $content['content'] = $mysqli->real_escape_string($_POST['content']);
  //$_POST['content'] = json_encode($content, JSON_NUMERIC_CHECK | JSON_UNESCAPED_UNICODE);
  $content['icon'] = $_POST['icon'];
  $content['summary'] = $_POST['summary'];
  $content['content'] = $_POST['content'];

$content = json_encode($content, JSON_NUMERIC_CHECK | JSON_UNESCAPED_UNICODE);

$_POST['content'] = $mysqli->real_escape_string($content);
```

四、單筆撈出

這筆不要過濾  
 <span style="color:#FF0000;">$row\['content'\] = $content\['content'\]; // 轉換雙引號和單引號</span>

```
<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`= 'icon_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']);

$content = json_decode($row['content'], true); //(PHP 5 >= 5.2.0 true=>array

$row['icon'] = htmlspecialchars($content['icon'], ENT_QUOTES); // 轉換雙引號和單引號
	$row['summary'] = htmlspecialchars($content['summary'], ENT_QUOTES); // 轉換雙引號和單引號
	$row['content'] = $content['content']; // 轉換雙引號和單引號

return $row;
}
```

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown