set_charset('utf8');
//2.search the data table(books)
$result = $conn->query("select * from books");
//3.get the 1st row
//there are 4 method to get data
//(1)fetch_row(), only number index like $row[1]: $row = $result->fetch_row(); echo $row[1] = 'php程式教學';
//(2)fetch_assoc(), only column nmae like $row["書籍名稱"]: $row = $result->fetch_assoc(); echo $row["書籍名稱"] = 'php程式教學';
//(3)fetch_array(), both index & column nmae like $row[1],$row["書籍名稱"]: $row = $result->fetch_array(); echo $row["書籍名稱"] = 'php程式教學';
//(4)fetch_all();
//$row = $result->fetch_assoc();
//echo $row['書籍名稱'];
//get 2nd row;
//echo "
";
//$row = $result->fetch_row();
//echo $row[1];
//get 3rd row;
//echo "
";
//$row = $result->fetch_array();
//echo $row[0].", ".$row["書籍名稱"];
//get all data
$rowall = $result->fetch_all(MYSQLI_ASSOC);
//fetch_all(參數),有三種參數:
//(1)MYSQLI_ASSOC:會輸出 the 欄位名稱index
//(2)MYSQLI_NUM:會輸出 the 欄位編號num index
//(3)MYSQLI_BOTH:兩個都會輸出(欄位名稱,編號)
//若輸出資料有中文會產生亂碼,解決方法:echo json_encode($rows,JSON_UNESCAPED_UNICODE);
echo json_encode($rowall,JSON_UNESCAPED_UNICODE);
//4.close connect
$conn->close();
?>