I am building a Hotel Booking App and i got stuck with filtering a hotel and rooms while inserting a checkin and check out dates
Here is my table structure
hotels
id name logo name
rooms
id
hotel_id
name price
no_of_rooms
Now i have build a booking table like this
booking
id hotel_id room_id check-in checkout
i want to select a hotel and filter all the available rooms in that hotel comparing the check in and checkout dates
AND i want to filter all the rooms available in all the hotels within that check-in and checkout dates
your help would be so much appreciated and please do help me with my database structure and do suggest me the logic to build this functionality.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community