Click here to Skip to main content
15,074,394 members
Please Sign up or sign in to vote.
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.


1 solution

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.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900