Task 2

Now that we have a database we have to understand the tables inside it. Each of your databases contain a single table named: persons

The ‘persons’ table has the following columns.

•	PersionId, INT, Primary Key, NOT NULL, AUTO INCREMENT
•	FirstName, VARCHAR(50), NULL
•	LastName, VARCHAR(50), NULL
•	EmailAddress, VARCHAR(255), NULL
•	TelephoneNumber, VARCHAR(20), NULL
•	SocialInsuranceNumber, VARCHAR(11), NULL
•	Password, VARCHAR(50), NULL

NOTE: you can use the SQL command ‘DESCRIBE persons’ for more information about your table.
Task 3

Use techniques learned in ‘Common Look and Feel’ to develop the following web site. Your web site MUST use ‘Design Pattern 4’. Your web site will include the following PHP scripts:

•	Header.php
•	Footer.php
•	Menu.php
•	CreateAccount.php
•	Login.php
•	ViewAllAccounts.php

NOTE: CreateAccount.php, Login.php and ViewAllAccounts.php, all must include the Common look and feel implemented in Header.php, Footer.php and Menu.php.

Header.php

Header.php must contain a script to display a Common Header that will appear on every page. The header must contain: Name, Student Number, Lab Number and Lab Title


Footer.php

Footer.php must contain a script to display a Common Footer that will appear on every page. The footer must contain the Lab Number and Lab Title


Menu.php

Menu.php must contain a script to display a Common Menu to be show on every page. The menu must contain links to CreateAccount.php, Login.php and ViewAllAccounts.php


CreateAccount.php

Create a PHP form that will create user accounts in the Persons table of your database.

Details:
1.	Use ‘input’ tags to accept the information listed in Task 2. Your form must populate all the columns of the ‘persons’ table.
2.	After the information has been submitted to the database save each of the values from the form in the Session State.
3.	Once the user data is stored in the Session, automatically redirect the user to ‘ViewAllAccounts.php’

NOTE: PersonId is listed as ‘AUTO INCREMENT’ meaning that the database will automatically populate this field.

NOTE: Session_StoreValues.php has an example of programmatically sending a user to another page in your website.


Login.php

The form Login.php allows the user to log into your application.

Details:
1.	Create a form to accept the users EmailAddress and Password as credentials to your site. Use an SQL Query to determine if the person has an account.
2.	If the user has an account, store ALL of their personal information in the Session State and then redirect the user to ‘ViewAllAccounts.php’. Display an error if the user cannot log into the system.
3.	The page must also contain a link to ‘CreateAccount.php’ so that a client can create an account if they do not have one.


ViewAllAccounts.php

This page pulls information from both the Session and Database and displays the information to the user.

Details:

1.	If the user tries navigate to this page without having logged in – the user should be redirected to the login page.
2.	If the user has successfully logged into the application and is directed to the page display the following information
a.	Divide the content of page into 2 sections (One on top of the other)
b.	The top section of the page will display all the user details stored in the Session State
c.	The bottom section of the page will display a HTML table containing of the person rows in the persons table of your database. Each column in the HTML table must a column in the table. The HTML table must also contain a header row that identifies the column name of the database table.
d.	Provide H1 HTML headers so that both sections (instructions B and C) are clearly marked

NOTE: To verify is a user has successfully logged into check for valid information in the Session State. If the Session State does not contain valid information redirect to the login page, otherwise, the user has logged in successfully.

NOTE: The Blackboard file ‘PHP, MySQL CRUD Example.zip’ contains a detailed example of the things you are expected to do in this lab.