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

Instructions$/$Overview:

You will create a web application that supports HTTPS communication, provides login authority levels for administrators and technicians, provides functionality based on the type of login$,$ displays information contained in a database, and allows users to add additional records to the database. To begin, use phpMyAdmin to create the database in the cis$367\_$wk$5$final.sql Download cis$367\_$wk$5$final.sql file. I HAVE PROVIDED THE TEXT OF THE SQL FILE FOR REFERENCE Note that for connecting to the database, you will find the correct User ID and word in the provided SQL file. Detailed requirements for the application are listed below.

Specific Requirements:

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

Web application is written using the MVC $($Model$,$ View, Controller$)$ architecture $($or MVC$+...$MVC $+$ utilities$)$

Web application is written using object$-$oriented PHP programming, including $($at a minimum$)$ classes for:

Database

Connection & Information

Table object$($s$)($i$.$e$.,$ classes to represent the tables in the database$)$

Table controller$($s$)$

Table interaction $($queries$)$

Utilities

Validation controls

Text file controls

Image file controls

All classes and functions $($if you have functions in a file but not in a class$)$ are encapsulated using appropriate namespaces

Web application includes user interface pages as follows:

All pages titled "Your Name Final Practical"

All pages use descriptive title headers

All pages include a logout button

All pages include an ability to navigate to that user type's home page

Pages include:

Login

Administrator functions $($page$($s$)$ to support the following$)$:

Only available if the user is logged in with admin privileges $($LevelNo is $1)$

User Management

Display all users $($all fields displayed except password$)$

Add user $($validate all fields appropriately$)$

Update user $($validate all fields appropriately$)$

Delete User

Image file management

List available images

Upload image file

Files stored in application working directory$/$images

Resize uploaded images to be displayable with max size of $200$x$200$ pixels

Files stored in application working directory$/$images$/200$

Display an uploaded image $-$ original and resized

Delete an image $($the upload and the resized version$)$

Technician functions $($page$($s$)$ to support the following$)$:

Only available if the user is logged in with tech privileges $($LevelNo is $2)$

Incident Management

Display a list of available incident text files

Files stored in application working directory$/$incidents

Add incident text file

Update incident text file

Display incident text file contents $($non$-$editable$)$

Database Connection Status

View all connection information for the database

View a summary status of connection success or failure

Web application provides validation for user account input $($add$/$update$)$ fields

Determine appropriate rules$/$formats for the fields

Validate according to your rules

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

Final layout is at your discretion$/$creative imagination, as long as it meets all the requirements above.

$=============================$

SQL FILE: $--$ Database: 'cis$367\_$wk$3$final'

DROP DATABASE IF EXISTS cis$367\_$wk$3$final;

CREATE DATABASE cis$367\_$wk$3$final DEFAULT CHARACTER SET utf$8$mb$4$ COLLATE utf$8$mb$4\_$general$\_$ci;

USE cis$367\_$wk$3$final;

$--$ Table structure for table 'users'

DROP TABLE IF EXISTS users;

CREATE TABLE users $($

UserNo int$(11)$ AUTO$\_$INCREMENT PRIMARY KEY,

UserId varchar$(12)$ NOT NULL,

Password varchar$(20)$ NOT NULL,

FirstName varchar$(50)$ NOT NULL,

LastName varchar$(50)$ NOT NULL,

HireDate date NOT NULL,

EMail varchar$(50)$ NOT NULL,

Extension int$(5)$ NOT NULL,

UserLevelNo int$(1)$

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$;

$--$ Data for table 'users'

INSERT INTO users $($UserId$,$ Password, FirstName, LastName, HireDate, EMail, Extension, UserLevelNo$)$ VALUES

$(\text{'}$LS$11775\text{'},\text{'}$Pw$1$$$\text{'},$ 'Sybil', 'Ludington', $\text{'}1761-04-05\text{'},$ 'rode$2$@revere.com', $\text{'}11775\text{'},2),$

$(\text{'}$LR$01010\text{'},\text{'}$Pw$1$$$\text{'},$ 'Rasmus', 'Lerdorf', $\text{'}1968-11-22\text{'},$ 'creator@php$.$com', $\text{'}01010\text{'},1),$

$(\text{'}$JP$28426\text{'},\text{'}$Pw$1$$$\text{'},$ 'Percy', 'Julian', $\text{'}1899-04-11\text{'},\text{'}$pj@nas.org', $\text{'}28426\text{'},2),$

$(\text{'}$BR$21212\text{'},\text{'}$Pw$1$$$\text{'},$ 'Roy G$.\text{'},$ 'Biv', $\text{'}1899-04-11\text{'},$ 'rainbow@colors.org', $\text{'}21212\text{'},2),$

$(\text{'}$WE$11919\text{'},\text{'}$Pw$1$$$\text{'},$ 'Edith', 'Wilson', $\text{'}1872-10-15\text{'},$ 'temp$\_$pres@whitehouse.gov', $\text{'}11919\text{'},1)$;

$--$ Table structure for table 'user$\_$levels'

DROP TABLE IF EXISTS user$\_$levels;

CREATE TABLE user$\_$levels $($

UserLevelNo int$(1)$ AUTO$\_$INCREMENT PRIMARY KEY,

LevelName varchar$(20)$ NOT NULL

$)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$;

Example of how the UI may appear $-$ you may choose a different layout$/$structure: