Information regarding Booking of rooms in a Hotel

Question

1.00/5 (1 vote)

See more:

Hello friends
I am Sarfaraz. I am developing a website for a hotel where the requirement is that they should be able to collect the Booking details and should be able to get the information about the booking details.
Previously they were having a site (like a blog) in Joomla where a user can fill the details and submit the booking button but the hotel manger was only able to get the details as an email from that page but were not able to save the booking details in a database.

Now, I have created a PHP form where I am able to email the details of the visitor to the mangers email id and also save the details in MYSQL table.

But. now i need some suggestions/ help in the following queries:

1. What is the best way to let the manager of the hotel to get the details for the booking.
2. Should the manager needs to open the MYSQL to get the details of booking or needs a page to display all the bookings on that page.
3. If the Tariffs of the rooms gets changed where should these be edited in MYSQL or need a page for that.
4. if i need to design pages for these activities, should these pages be visible to visitors or not.

Sorry for a very lengthy question.

Regards

Posted 5-May-13 2:47am

sarfarazbhat

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-05-05T02:56:00

The best way will be to send a mail and send a sms message (if you can integrate some third party sms sending tool).

And yes we are programmers, so we can refer the DatatBase, but the end-users should always see interactive designed pages where they can manage the things easily.

So, design some pages as per their requirements and show those saved booking data in Grids or Lists.

If visitors are going to see their booking details, they will need some kind of authentication.
I mean you can create logins or login them with some booking reference ids and show only the relevant records.

So, on the pages, you need to check the role of user who is accessing the app.
For manager, you will show different things and for visitors it will hide some data and show only their booking data.