SitePoint Sponsor

User Tag List

Results 1 to 10 of 10

Threaded View

  1. #1
    SitePoint Member unknown_022's Avatar
    Join Date
    Sep 2007
    Location
    Philippines
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Compute Vacant Rooms for Hotel Booking System

    Hi! I'm not a PHP guru. I'm developing a Hotel Booking System and I'm having problem computing the available rooms per hotel. On my website I have search engine for searching available rooms based on check -in and check-out date. The result rooms that should be displayed are the rooms that are not booked for that span of time. I have no idea how to do it but I'll give you how I built my table on DB for rooms, hotel, booking, and room booked. Each room has corresponding quantity, lets say for one hotel there are 10 types of rooms. Example, there is 10 Single Bed (room type) rooms.

    Attached files are the screenshots of the tables used in my application:

    Anyone who encounter also this issue. Any suggestion would be very much appreciated. Thank you very much in advance.

    Paul
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •