member-Read-api.php

<?php
// 和member-control_panel.html有關
// 功能 : 將商品資料抓出來給html用

// {"state" : true, "data": "所有會員資料", "message" : "讀取成功!"}
// {"state" : false, "message" : "讀取失敗!"}

// 本機的
// $servername = "localhost";
// $username = "owner01";
// $password = "123456";
// $dbname = "testdb";

// 網路的
// 指定網址才能使用此php檔案
header("Access-Control-Allow-Origin: *");
$servername = "localhost";
$username = "id22011870_hsd325";
$password = "Hsd325hsd325.";
$dbname = "id22011870_hsd325";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
    die("連線失敗" . mysqli_connect_error());
}

$sql = "SELECT * FROM member ORDER BY ID DESC";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
    $mydata = array();
    while ($row = mysqli_fetch_assoc($result)) {
        $mydata[] = $row;
    }
    echo '{"state" : true, "data": ' . json_encode($mydata) . ', "message" : "讀取成功!"}';
} else {
    echo '{"state" : false, "message" : "讀取失敗!"}';
}

mysqli_close($conn);