Design an e$-$commerce website that sells physical copies of old and new video games and allows users to download games to their PC$.$ Use HTML$,$ CSS$,$ and PHP to construct the website.

Note that the website will have two separate login and logout php files one for the user and another for the user$-$admin. The user$-$admin login will be located at the bottom right of the home page when clicked it will take the user$-$admin to a different page where the admin is able to see pending orders, inventory of both games and consoles, add to inventory, view order number this being the product name, number, and quantity, then if admin clicks invoice it will show relevant information such as billing address, order number and total price, a table chart that displays what is being shipped this being product Name, Number, Quantity, and price, and the subtotal, shipping and handling charge, and total price again. After that the user$-$admin will update the order status, when user$-$admin clicks updae status to shipped it will say update successful and will update the order detail table in the data base from pending to shipped, and will decrement how many items were ordered from game and console quantity.

user the following database SQL to program the website:

$/*$Create the Database$*/$

CREATE DATABASE OldNewGenGamingCenter;

$/*$Use the Database$*/$

USE OldNewGenGamingCenter;

$/*$Create Table for users$*/$

CREATE TABLE Users $($

UserID INT AUTO$\_$INCREMENT PRIMARY KEY,

Name VARCHAR$(255)$ NOT NULL UNIQUE,

Gender ENUM$(\text{'}$m$\text{'},\text{'}$f$\text{'},\text{'}$o$\text{'})$

EmailAddress VARCHAR$(255),$

UserPassword VARCHAR$(255)$ NOT NULL,

Address VARCHAR$(255),$

PhoneNumber VARCHAR$(255),$

ShippingAddress VARCHAR $(255),$

CreditCardNumber VARCHAR$(255),$

CreditCardExpirationDate DATE

$)$;

CREATE TABLE Games $($

VideoGameID INT PRIMARY KEY,

VideoGameName VARCHAR$(255),$

PictureLink VARCHAR$(255)$;

Genre VARCHAR$(255),$

EsrbRating VARCHAR$(255),$

GameAge VARCHAR$(255),$

Price DECIMAL$(10,2)$

$)$;

CREATE TABLE consoles $($

ConsoleID INT PRIMARY KEY,

ConsoleName VARCHAR$(255),$

ConsoleAge VARCHAR$(255),$

ConsolePrice DECIMAL$(10,2)$

$)$;

CREATE TABLE QuantityonHand$($

VideoGameID INT,

Quantity INT,

PRIMARY KEY $($VideoGameID$),$

FOREIGN KEY $($VideoGameID$)$ REFERENCES Games$($VideoGameID$)$

$)$;

CREATE TABLE Orders $($

OrderID INT AUTO$\_$INCREMENT PRIMARY KEY,

CustomerID INT,

TotalWeight DECIMAL $(10,2),$

TotalPrice DECIMAL $(10,2),$

ShippingCharge DECIMAL $(10,2),$

Date DATE,

Status VARCHAR $(50),$

FOREIGN KEY $($CustomerID$)$ REFERENCES Users $($UserID$)$

$)$;

CREATE TABLE OrderDetails $($

OrderID INT, VideoGameID INT, Quantity INT,

Price DECIMAL $(10,2),$

PRIMARY KEY $($OrderID$,$ VideoGameID$),$

FOREIGN KEY $($OrderID$)$ REFERENCES Orders$($OrderID$),$

FOREIGN KEY $($VideoGameID$)$ REFERENCES Games$($VideoGameID$)$

$)$;

CREATE TABLE Inventory $($

VideoGameID INT PRIMARY KEY,

Name VARCHAR$(255),$

Description VARCHAR$(255),$

PartNumber INT,

QuantityOnHand INT,

FOREIGN KEY $($VideoGameID$)$ REFERENCES Games $($VideoGameID$)$

$)$;

CREATE TABLE ShippingHandlingCharges $($

WeightBracket INT PRIMARY KEY,

Charge DECIMAL $(10,2)$

$)$;

INSERT INTO $`$games$`(`$VideoGameID$`,`$VideoGameName$`,`$PictureLink$`,`$Genre$`,`$EsrbRating$`,`$GameAge$`,`$Price$`)$ VALUES

$(1001,$ 'Devil May Cry $5\text{'},$ 'DevilMayCry$5.$jpg$\text{'},$ 'hack & slash and action$-$adventure', $\text{'}$M Rating', $\text{'}5$y$\text{'},\text{'}39\mathrm{.}99\text{'}),$

$(1002,$ 'fate samurai remnant', 'FateSamuraiRemnant.jpeg', 'action RPG$\text{'},$ 'Teen Rating', $\text{'}1$y$\text{'},\text{'}59\mathrm{.}99\text{'}),$

$(1003,$ 'wii sports resort', 'WiiSportsResort.jpg$\text{'},$ 'sports simulation', $\text{'}$E$\text{'},\text{'}15$y$\text{'},\text{'}30\mathrm{.}99\text{'})$;

INSERT INTO $`$consoles$`(`$ConsoleID$`,`$ConsoleName$`,`$ConsoleAge$`,`$ConsolePrice$`)$ VALUES

$(2001,$ 'Play Station $5\text{'},\text{'}3$y$\text{'},\text{'}409\mathrm{.}00\text{'}),$

$(2002,$ 'xbox series x$\text{'},\text{'}3$y$\text{'},\text{'}499\mathrm{.}99\text{'}),$

$(2003,$ 'wii console', $\text{'}18$y$\text{'},\text{'}149\mathrm{.}99\text{'})$;

INSERT INTO $`$inventory$`(`$VideoGameID$`,`$Name$`,`$Description$`,`$PartNumber$`,`$QuantityOnHand$`)$ VALUES

$(1001,$ 'Devil May Cry $5\text{'},$ 'hack & slash and action$-$adventure', $1001,150),$

$(1002,$ 'fate samurai remnant', 'action RPG$\text{'},1002,60),$

$(1003,$ 'wii sports resort', 'sports simulation', $1003,25)$;

INSERT INTO $`$quantityonhand$`(`$VideoGameID$`,`$Quantity$`)$ VALUES

$(1001,150),$

$(1002,60),$

$(1003,25)$;

INSERT INTO $`$shippinghandlingcharges$`(`$WeightBracket$`,`$Charge$`)$ VALUES

$(1,\text{'}5\mathrm{.}00\text{'}),$

$(2,\text{'}5\mathrm{.}25\text{'}),$

$(3,\text{'}5\mathrm{.}45\text{'})$;