Create a PHP web application using the following instructions and with the given properties.

Instructions$/$Overview:

You will create a web application that connects to a database and displays the information contained in the database, and allows the user to add additional records to the database. To begin, use phpMyAdmin to create the database in the cis$367\_$wk$3$midterm.sql Download cis$367\_$wk$3$midterm.sql file. Once you've created the database, you will create a web application using Object$-$Oriented PHP programming techniques and the MVC architecture. Note that for connecting to the database, you will find the correct User ID and Password in the provided SQL file. Detailed requirements for the application are listed below.

Specific Requirements:

Project$/$folder name is YourLastName$\_$midterm

Web application is written using the MVC $($Model$,$ View, Controller$)$ architecture

Web application is written using object$-$oriented PHP programming, including classes for:

Database Connection & Information

Provides connection to the database

Provides error handling for database connection issues

Provides methods to get database connection information

Included in the namespace "Models"

Contacts table model

Model of the Contacts table

Included in namespace "Controllers"

Contacts table DB

Provides methods for querying the database as follows:

Get contact by ContactNo

Get all contacts

Add contact

Update contact

Delete contact

Included in the namespace "Models"

Contacts table controller

Provides methods to control the flow of information between the user interface and the database

Included in the namespace "Controllers"

Web application includes a "landing page"

Filename: index.php

Title: "Your Name Midterm Practical"

Page Header: Your Name Midterm Practical

Header: Main Menu

Includes a link to the display contacts page

Web application includes user interface page$($s$)$ to display, add, update, and delete contact information:

Filename display$\_$contacts.php

Title: "Your Name Midterm Practical"

Page Header: My Contacts

Table displaying contact information from the database

ID column

Header: User ID

Display: ContactNo from the database

Name column

Header: Name

Display: ContactFirstName and ContactLastName name from the database formatted as Last, First

Address column

Header: Street Address

Display: ContactAddressLine$1$ from the database

Address column

Header: Apt$/$Office$/$Bldg

Display: ContactAddressLine$2$ from the database

City column

Header: City

Display: ContactCity from the database

State column

Header: State

Display: ContactState from the database

Zip column

Header: Zip Code

Display: ContactZip from the database

Date of Birth

Header: DOB

Display: ContactBirthdate from the database

E$-$Mail

Header: E$-$Mail Address

Display: ContactEMail from the database

Phone

Header: Phone Number

Display: ContactPhone from the database

Notes

Header: Additional Information

Display: ContactNotes from the database

Displays all rows contained in the database

Ability to Delete a contact from the database

Ability to Add or Update a contact in the database, with the following validation:

First Name

Required

Must contain at least $2$ characters

Last Name

Required

Must contain at least $2$ characters

Street Address

Required

No specific format required

Apt$/$Office$/$Bldg

Optional

No specific format required

City

Required

Must contain at least $2$ characters

State

Required

$2$ upper$-$case letters only

Zip

Required

$5$ numbers only

Date of Birth

Required

Uses a Date Picker

E$-$Mail

Required

Must be a validly formatted e$-$mail address

Phone

Required

Format $($XXX$)$XXX$-$XXXX

Notes

Optional

Up to $50$ characters allowed

If there are validation errors:

An error message should be displayed next to the field with the error describing the expected input

The information should be retained in the entry fields

The information should not be saved to the database