20240222-hoteldata_api.php

<?php
// 跟20240220-fileupload.html有關連的php

// 本機的
// $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 hoteldata";
$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);