[ad_1]
Project I 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 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 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. Your command to connect to Mysql Database would likemysql_connect( “localhost”, “johnsmith”, “johnsmithpass” ) — create user to query product database — GRANT SELECT, INSERT, DELETE, UPDATE ON johnsmithdatabase.* TO johnsmith@localhost IDENTIFIED BY ‘ johnsmithpass’; Once again, replace johnsmith with yourfirstnamelastname 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) Due11/3/2018before midnight •Zip all above to a folder and submit that folder to Canvas. Note 1 Make 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 2 You 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."
