Note:

•   Include comments for your student ID, Name, and Practical Class Time at the top of each source file created.

•   All instructions given in this document must be followed in order to be eligible for full marks for the Web Application Assignment

•   This assignment is not a group assignment; collusion, plagiarism, cheating of any kind will not be    tolerated. Submitting your work to your TWA site signifies that the work uploaded is yours. If you   cannot honestly certify that the work is your own then do not upload it to your TWA site. Breaches of the Misconduct Rule will be dealt with according to the university policy (see the learning guide for more information)

•   All files must be uploaded to your TWA web site before submission due date

•   Ensure all HTML written is valid. Use http://validator.w3.org to confirm before submission

Assignment Overview:

For this assignment, you are going to be build a B&B Booking System for a property portfolio. To do this,     you are given a list of files that you will need to create. These will be a mix of HTML, CSS, Javascript and       PHP files. Within some of your PHP files, you will be required to connect to and execute SQL statements on a database. This database will be given to you and will only be associated with your TWA site.

The concepts or skills within this assignment has been presented in lecture or has been part of a practical  class exercises. You will be combining all these concepts and skills to build your basic B&B Booking System.

Design and Styling

For this major web assignment, you must design and style your own site. You can adopt what has been     given in your Practical Class exercises or you can start from scratch. Either way, you must design and style your B&B Booking System so it is professional looking. Your chosen design and styling will be assessed.

Javascript and PHP Validation

All forms or where a user can provide input needs to be validated with both Javascript and PHP. HTML validation will not be accepted as a valid form of validation.

Web Application Assignment Database

You have been provided with your own copy of the database called bnb_booking on your TWA site. To access this database, you must use a username and password.

The following is a generic representation of the connection information to be used when connecting to your bnb_booking database (you do this with PHP code):

Database Name:    bnb_booking###

Username:              twa###

Password:               twa###XX

Server:                     localhost

Where ### is your twa site number, and XX refers to the first two characters of your TWA site password.

For example, if your TWA site is twa999, and your password is abcd7890, then the following would be your connection information:

Database Name:    bnb_booking999

Username:              twa999

Password:               twa999ab

Server:                     localhost

Using this information, you will use similar code to that below to connect to your database:

$connection = new mysqli('localhost', 'twa999', 'twa999ab', 'bnb_booking999');

if($connection->connect_error) {

// Echo out if it failed to connect to the database

echo $connection->connect_error;

}

Once connected to your database, you will have access to the bnb_booking database and all its data. Figure 1 presents the Entity Relationship Diagram and the schema of your database.

You will can only access your database through your TWA site.

Figure 1

The bnb_booking Database Data Dictionary: