PHP Hotel booking with allotments per day -
searched here similar questions finding stuff more need.
what trying create simple "hotel booking" allotments per day. so, basically: user chooses checkin , checkout date , hotel or hotel b.
now, each day between checkin , checkout there allotments, i.e. have following possible dates respective allotments (rooms available):
hotel a: 17.10.2014 - 25 rooms 18.10.2014 - 40 rooms 19.10.2014 - 20 rooms hotel b: 17.10.2014 - 35 rooms 18.10.2014 - 50 rooms 19.10.2014 - 40 rooms
when booking user first chooses checkin , checkout, hotel , script should check if of days in between booked particular hotel , particular date range , return message there no free allotments selected date range - maybe show days "problematic" (i.e. booked) user can choose day before or after.
what best approach achieve this? have checked several db schemas , table structures, said finding other solutions, not fit problem.
Comments
Post a Comment