$room_data[name]
Accommodation
Heating and air conditioning Mini-fridge Coffee & tea Desk Television toiletries Wi-Fi ...Additional Accommodation
$additionalAccom_data$$room_data[price]/night
$bookingNo options matching your search, please check your check-out date
"; exit;; } else if($checkin_date < $today_date){ echo "No options matching your search, please check your check-in date
"; exit; } } //check guest filter $guest_filter = json_decode($_GET['guest_filter'], true); $adult = ($guest_filter['adult']!='') ? $guest_filter['adult'] : 0; $children = ($guest_filter['children']!='') ? $guest_filter['children'] : 0; //output available room $count_room = 0; $setting_query = "SELECT *FROM `settings` WHERE `sr_no` = 1"; $settings_result = mysqli_fetch_assoc(mysqli_query($con, $setting_query)); $output = ""; $room_res = select("SELECT * FROM `rooms` WHERE `adult` >=? AND `children` >=? AND `status`=? AND `removed`=?", [$adult, $children, 1, 0], 'iiii'); while($room_data = mysqli_fetch_assoc($room_res)){ //fetch room availability if($check_filter['checkin'] != '' && $check_filter['check-out'] != ''){ $data_query = "SELECT COUNT(*) AS `total_booking` FROM `booking_order` WHERE booking_status=? AND room_id=? AND check_out > ? AND check_in < ?"; $values = ['pending', $room_data['id'], $check_filter['checkin'], $check_filter['checkout']]; $data_fetch = mysqli_fetch_assoc(select($data_query, $values, 'siss')); if(($room_data['quantity'] - $data_fetch['total_booking']) == 0){ continue; } } //get accommodation data from database $accom_q = mysqli_query($con, "SELECT a.name FROM `accommodation` a INNER JOIN `room_accommodation` raccom ON a.id = raccom.accommodation_id WHERE raccom.room_id = '$room_data[id]'"); $accommodation_data = ""; while($accom_row = mysqli_fetch_assoc($accom_q)){ $accommodation_data .="$accom_row[name]"; } //get additional accommodation data from database $addi_q = mysqli_query($con, "SELECT a.name FROM `additional_accomm` a INNER JOIN `room_additionalAccom` raddi ON a.id = raddi.additionalAccom_id WHERE raddi.room_id = '$room_data[id]'"); $additionalAccom_data = ""; while($addi_row = mysqli_fetch_assoc($addi_q)){ $additionalAccom_data .="$addi_row[name]"; } //get cover image $room_cover = ROOM_IMG_PATH."logo.png"; $cover_q = mysqli_query($con, "SELECT * FROM `room_images` WHERE `room_id`='$room_data[id]' AND `upload`='1'"); if(mysqli_num_rows($cover_q) > 0){ $cover_res = mysqli_fetch_assoc($cover_q); $room_cover = ROOM_IMG_PATH.$cover_res['image']; } //booking & shutdown booking process $booking = ""; if(!$settings_r['shutdown']){ $login = 0; if(isset($_SESSION['login']) && $_SESSION['login'] == true){ $login=1; } $booking = ""; } //display room (---**accommodation section did not use from database**---) $output .= "$room_data[name]
Accommodation
Heating and air conditioning Mini-fridge Coffee & tea Desk Television toiletries Wi-Fi ...Additional Accommodation
$additionalAccom_data$$room_data[price]/night
$booking