For this assignment you will create at a login series of php$/$html pages; I want the following:

$1.$ Create a database with a customer table having fields for first name, last name, telephone, email, user name, and password. Make the username be the primary key for this table.

$2.$ A Login page $[$see fig $1].$ Once the user clicks the submit button, check if the user name and the password are in the db$.$

$2\mathrm{.}1$ If yes, display a new welcome page that displays at a minimum, a welcome message with the first and last name of the username.

$2\mathrm{.}2$ If username and password are not in the database then display an error message $[$see fig $2]$

$3.$ If the user does not have an account, no user name and password, then they click on the link at bottom of login page, and you will display a new screen to create an account $.$ User will need to enter: first name, last name, telephone, email, user name, and password twice. $[$see Fig $3]$ Once the submit button is clicked,

a$.$ Verify both passwords entered match. If not display an error message

b$.$ password needs to be greater than $8$ characters. If not display an error message

c$.$ email needs to be a valid type, not necessarily an active account. If not display an error message

d$.$ All fields need values. If not display an error message

$3\mathrm{.}1$ if the user name is not in the database, then create a new record in the database with the given data entered, then display a new welcome page that displays at a minimum, a welcome message with the first and last name of the username.

$3\mathrm{.}2$ if the user name is in the database, then display an error message the user name is already taken.

$4.$ Add css to each of your pages to make each page appealing with some color, images and various fonts and sizes.