<?php
    //echo "good luck";
    //1.conect to database
    $conn = new mysqli("localhost","root","","ch09");
    $conn->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 "<br>";
    //$row = $result->fetch_row();
    //echo $row[1];
    
    //get 3rd row;
    //echo "<br>";
    //$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();


?>