select_hotel.php

<?php    
	include "db_conn.php";
	
	$hotelName = $_GET['HotelName'];
	$query = ("select * from hotel where HotelName = ?");
	$stmt =  $db->prepare($query);
	$error= $stmt->execute(array($hotelName));
	$result = $stmt->fetchAll();
	//以上寫法是為了防止「sql injection」

    
    // $HotelArray = array();
	if(count($result)==0){   
        echo "no Hotel";   
    }
    else{
        for($i=0; $i<count($result); $i++){
           
            $HotelObject =  array( 'HotelName'  =>  $result[$i]['HotelName'], 'Description'  =>  $result[$i]['Description'],
                                     'Address'  =>  $result[$i]['Address'], 'Zone'  =>  $result[$i]['Zone'],
                                     'StarNum'  =>  $result[$i]['StarNum'], 'Count'  =>  $result[$i]['Count'], 'PhotoURL'  =>  $result[$i]['PhotoURL']);
            $HotelArray[] = $HotelObject;
        }
    }
    header('Content-Type: application/json; charset=utf-8');
    echo json_encode($HotelArray, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
?>