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
•	Password, VARCHAR(50), NULL
•	SocialInsuranceNumber, VARCHAR(11), NULL
•	TelephoneNumber, VARCHAR(20), NULL

The ‘transactions’ table has the following columns.

•	TransactionId, INT, Primary Key, NOT NULL, AUTO INCREMENT
•	PersonId, INT, NULL
•	AmountTransferred, DECIMAL(9,3), NULL

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


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 ‘Home.php’

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

Login.php
Divide this page into two sections to be viewed Side by Side.

On the Right Side
Create a form 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 ‘Home.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.

On the Left Side
Use the code found in XMLCodeExample.zip (Module 4, Part 3) to show the Bank News items. Remove the section that displays the Channels Title, Description and Link but leave the code that displays the Items.


Home.php
This page will display the following information:

•	The amount currently in the users account
o	Read all of the users Transactions from the transactions table. Add up all of the values of ‘AmountTransferred’ and display the result
o	If there are no transactions be sure to display 0
•	A record of the last 3 transactions the user has completed
o	The table must include a Header
o	Each transaction row must contain
	The type of transaction (if the amount is positive ‘DEPOSIT’, if the amount is negative ‘WITHDRAW’)
	The amount deposited or withdrawn
o	If the user does not have transactions associated with their account inform the user that ‘You have not completed a transaction.”

If the user has not logged into this application, the user is to be redirected to the login screen.

Deposit.php
Create a PHP form that will allow the user to deposit money into the application. A simple text box will suffice. Be sure to display error and success messages depending on the forms result.

If the user has not logged into this application, the user is to be redirected to the login screen.

NOTE: When depositing an amount into the transactions table be sure that the amount is a positive number.

Withdraw.php
Create a PHP form that will allow the user to withdraw money from the application. A simple text box will suffice. Be sure to display error and success messages depending on the forms result.

If the user has not logged into this application, the user is to be redirected to the login screen.

NOTE: When withdrawing an amount from the transactions table, be sure to convert the amount into a negative number.

Report.php
This page will display the following information:

•	The amount currently in the users account
o	Read all of the users Transactions from the transactions table. Add up all of the values of ‘AmountTransferred’ and display the result
o	If there are no transactions be sure to display 0
•	A record of all of the transactions the user has completed
o	The table must include a Header
o	Each transaction row must contain
	The type of transaction (if the amount is positive ‘DEPOSIT’, if the amount is negative ‘WITHDRAW’)
	The amount deposited or withdrawn
o	If the user does not have transactions associated with their account inform the user that ‘You have not completed a transaction.”

If the user has not logged into this application, the user is to be redirected to the login screen.

CloseAccount.php
Create a form that allows the user to close their account.

Details:

1.	Create a form to accept the users EmailAddress and Password as credentials to close their account. Compare the values from the form to the information stored in the session state.
2.	If the user has entered the correct credentials delete all of the content related to their account in the database (all transactions and the record in the person table)
3.	Once the user information has been removed from the application go ahead and redirect the user to Login.php

If the user has not logged into this application, the user is to be redirected to the login screen.