<?php
//資料庫設定
$dbServer = "localhost";
$dbUser = "root";
$dbPass = "root";
$dbName = "ch09";

//連線資料庫伺服器
$conn = @mysqli_connect($dbServer, $dbUser, $dbPass, $dbName);

if (mysqli_connect_errno($conn))
  die("無法連線資料庫伺服器");

//設定連線的字元集為 UTF8 編碼
mysqli_set_charset($conn, "utf8");

//關鍵字查詢資料表的的資料
if(isset($_GET['name']))
$result=mysqli_query($conn, "SELECT * FROM employee where 姓名 like '%".$_GET['name']."%'");
else
$result=mysqli_query($conn, "SELECT * FROM employee");


//給定$row[][]二維陣列-文字欄位//////////////////////////////////
$rowall = mysqli_fetch_all($result,MYSQLI_ASSOC);

echo json_encode($rowall);

////釋放記憶體////////////////////////////
mysqli_free_result($result); // 釋放result物件佔用的記憶體
mysqli_close($conn); //關閉資料庫連接

?>