How to implement check availability in hotel reservation system

Reply

•
•
Join Date: Sep 2008
Posts: 33
Reputation: jyotiu is an unknown quantity at this point 
Solved Threads: 0
jyotiu jyotiu is offline Offline
Light Poster

How to implement check availability in hotel reservation system

 
0
  #1
Apr 1st, 2009
Hi ppl

I am developing website for my friend's very small resort, please see www.shivgangaresorts.com/dev

this resort have 8 rooms in total and all rooms are of same type so every room is equally priced.

I just need code or logic to check availability of given no. of rooms on given check in and check out dates.

when somebody makes a reservation, details that go in reservation table is:
booking_id
customer name
email
check-in date
check-out date
no. of rooms

Please help this is very critical as i will be integrating paypal also, so there should be no confusions...

thanks in advance
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 175
Reputation: urtrivedi is an unknown quantity at this point 
Solved Threads: 30
urtrivedi urtrivedi is offline Offline
Junior Poster

Re: How to implement check availability in hotel reservation system

 
0
  #2
Apr 1st, 2009
You can execute following query to determine whether new reservation for any room is confilicting with existing reservation for that room.
PHP Syntax (Toggle Plain Text) 
  1.  select * from reservtable where '{$fromdate}' <= check_out_date and '{$todate}'>= check_out_date and room='{$roomno}'
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 4
Reputation: sakisl is an unknown quantity at this point 
Solved Threads: 0
sakisl sakisl is offline Offline
Newbie Poster

Re: How to implement check availability in hotel reservation system

 
0
  #3
May 24th, 2009
if you find a solution please let me know
i am looking for the same thing
[removed email]
Last edited by Narue; May 24th, 2009 at 9:54 pm. Reason: snipped email
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2006
Posts: 1,502
Reputation: ardav will become famous soon enough ardav will become famous soon enough 
Solved Threads: 194
Sponsor
ardav's Avatar
ardav ardav is offline Offline
Anthrax Poster

Re: How to implement check availability in hotel reservation system

 
0
  #4
May 24th, 2009
Sorry to sound grouchy, but have you got anything yourself or do you expect some free work from scratch? If you post what you have, e.g. mysql queries/table structure/php code, I'd be happy to help.
Twpsyn cythraul. Cawr y dom tarw. Gwybod dim, gofyn dim.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the PHP Forum


Views: 1469 | Replies: 3
Thread Tools Search this Thread



Tag cloud for PHP
ajax apache archive array box broken buttons cakephp cart check checkbox class classes cms code combobox cookies curl database date delete directory display download dropdown dropdownlist drupal dynamic echo email error file files folder form forms function functions header href htaccess html image include insert ip java javascript joomla limit link list login loop mail menu methods mlm mod_rewrite multiple mysql order parse password paypal php problem query radio random recursion regex remote rows script search select server session sessions sort source sql string syntax table unicode update updates upload url user validation variable video web website wordpress xml zend
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2010 DaniWeb® LLC