Design a hotel reservation system using PHP and Mysql

[ad_1]
Design a hotel reservation system using PHP and Mysql The
home page of your web site gives introduction of your hotel (note the
hotel shall be named after your name) which includes the address, email,
phone numbers, and direction to your hotel. This page also contains
entries for check-in and check-out dates. Select number of rooms drop
down list, Number of adults and children dropdown lists. A submit button
to send user to the second page. All fields are required. Other
checking and validation shall and may be included. The second page
contains the list of available rooms on that booking period. The second
page shows images for different type of rooms available. It will list
price per night and the total cost for the stay period. A user can
choose the room type they want. The information of the available rooms
shall be retrieve from your MySql database. There is a submit button to
go to the confirmation page which contains fields for user to enter
his/her name and correspondence information such as address, street
name, city, state, phone number, email address. The room, stay period
and cost of the stay will be summarized and shown on this page. When
user clicks on submit button on this page, your system will output
appropriate message. Add at least three other pages. For example, local
attraction, Hotel dining, Shopping, Salon, Computer services, etc.Requirements Use XAMPP Use PHP as server side script Use MySql. Design your own database and table(s).. Name your web site yourNamePHP
When you connect to MySql database. Make sure that you use
yourFirstNameLastName as the user name in mysql connect command. For
example, if your name is called John Smith then Your command to connect
to Mysql Database would like mysql_connect( “localhost”, “johnsmith”,
“johnsmithpass” ) Export your MySql database as johnsmith.sql so
that I can regenerate your database on instructor’s computer. (replace
johnsmith with your name) Make sure that you name your database johnsmithdatabase . (replace johnsmith with your name)
Remember to add these lines to johnsmith.sql in order to create user
which is used in mysql connect command (once again, replace johnsmith
with your name)– create user to query product database –GRANT SELECT, INSERT, DELETE, UPDATEON johnsmithdatabase.*TO johnsmith@localhostIDENTIFIED BY ‘ johnsmithpass’; Once again, replace johnsmith with yourfirstnamelastname
Create a write up report (in word or pdf format) which include a cover
page with your name, this class information, such as course name,
section, instructor, etc. Second page is table of content. First chapter
is the description of your hotel system. Second chapter is your system
design. You can use diagram to illustrate your design if you want to.
Third chapter is your implementation. It should include the sql file
content that you submitted, the source code of all pages. Fourth chapter
includes your test run results which shall include test run screen
shots. As detailed as possible. Fifth chapter is discussion and
conclusions. Mention about the cool features of your web site. Things
for future improve. The limitation of your web site, etc… You can
include a Reference chapter at the end or as Appendix.Submission Zip your website which includes all your application files. The sql file which can regenerate your database and create a user to connect to your database The report in word or pdf format. A video file to demonstrate how you design your web site, features of your web site, and how to use it.(or a link to internet) Zip all above to a folder and submit that folder to Canvas.Note 1Make
sure your web site can run independently after one download from
Canvas. I.e., it shall be portable to others’ system that run XAMPP and
there is no local dependence on your machine.Note 2You can submit a demo video or post your demo on the web and give me the link.
[ad_2]Source link
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"