$room_data['id'], "name" => $room_data['name'], "price" => $room_data['price'], "payment" => null, "available" => false, ]; $user_res = select("SELECT * FROM `user_creds` WHERE `id`=? LIMIT 1", [$_SESSION['uerID']], "i"); $user_data = mysqli_fetch_assoc($user_res); //get accommodation & additional accommodation $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]

"; } ?>

Booking confirmation

Booking Detail
Loading...

Please provide check-in and check-out date

$room_data[name] ($room_data[area] sq.ft.)

$$room_data[price]/night

Room Detail

$room_data[detail]

Accommodation

$accommodation_data

Additional Accommodation

$additionalAccom_data
data; ?>