Coursework Brief:
Activity
Your task is to develop one or more scripted web pages that are meant to be part of a web application for a travel and tour company that offers packaged holidays. The aim of the business is to enable people use their website to book packaged holidays. The business currently offers three types of packaged holidays, namely
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: _0206girl
Gold , Silver, and Diamond . The Gold package is a 3-week holiday, costing £10,000 per person, while the Silver is a 2-week package costing £5000 per person. The Diamond package on the other hand is a week holiday costing £3,000 per person. At the moment, the business does not have a name, logo, and brand colours so it is your job to decide on these. Your web page(s) should be appealing, easy to use, and provide a package quote calculator. Specifically, your solution should contain:
• HTML pages – an effective home page, or collection of navigable pages, with corresponding
(example) content, that effectively showcases information about the business, holiday order page, contact form that allows customers to make enquiries. The contact form should request customers’ full name, email address, phone number, and message as well as have a dummy “Send” button.
• Functionality/scripting – a script that calculates the total cost by fetching the type of holiday package selected and corresponding cost from a pre-specified MySQL database table (see database specifications below) and multiply with the number of people going on the holiday and successfully displays this content on a respective page. Note that children get an automatic 25% discount on the package so this should be coded in the design . In addition, a standard VAT of 20% of the total cost must be included in the final amount. For instance, if the customer selects the Gold package for 2 adults and 1 child, the system should accurately calculate the total cost including the 25% child discount, and the standard 20% VAT.
• Styling (usability and visual aesthetics) – a user-friendly and visually appealing styling that are suitable for and well applied to the problem setting, and with appropriate positioning of all elements.
Importantly, to avoid any possible confusion, every page you include in your solution must clearly include the following disclaimer: “Note that this is a fictitious website that was developed by a student as part of a programming assignment. None of the content on this page is meant to be genuine nor should it be taken as such” . Also, please do not make any attempt to submit your pages to a search index or to provide any external link to them.
To develop your solution, you will need to use HTML, JavaScript, and PHP server-side scripting. Use of CSS for styling is strongly encouraged; some may wish to use Bootstrap for this purpose. Importantly, your server-side script(s) must be designed to run under the existing Web server configuration used to host your personal web file store ( www.southampton.ac.uk/~username/ ) 1 . Solutions that require different PHP
versions, customised server configurations, etc. will attract low marks; you may wish to verify compatibility at the beginning stages of your work.
Database specifications
For the purpose of this assignment, a MySQL database named “mgmt_webapp_msc” was created and stored on a University server ( srv02958.soton.ac.uk ). This database contains a table named “holiday”, which was defined as follows:
CREATE TABLE holiday (
holidayid INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
package VARCHAR(100),
packagedetails VARCHAR(255),
cost decimal (8,2),
duration VARCHAR (100)
);
You have been granted the necessary rights to select records from this table under the username:
MANG6531_student, password: tintin6531. You may assume the contents of this table will be maintained by the business; you are not given any user rights to insert, delete or update records in the table.
Important note on academic integrity
This is an individual assignment so your markup code and scripts must be your own work: you are not allowed to copy from other students.
You are of course encouraged to look for useful information sources to support your design choices and reference them in your code. Also, you are allowed to make use of existing templates or frameworks and development environments to speed up development, or you may look for scripting code examples on the Web, in books, etc., and adapt and incorporate individual chunks of scripting code provided you acknowledge their use and the sources in code comments.