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

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -