Here is the front end code

body {

background-image: url("http:/ewton.ncc.edu/gansonj/ite254/img/vgbkg.png");

font-family: arial;

color: #454F8C;

}

#contentwrap {

background: #FFFFFF;

background-image: url("http:/ewton.ncc.edu/gansonj/ite254/img/spyro.jpg");

background-repeat: no-repeat;

background-position: right 150;

border: 8px #FF9E01 solid;

padding: 20px;

width: 650px;

margin: 20px auto 0px auto;

border-radius: 25px;

min-height: 400px;

}

#heading {

font-size: 2.2em;

border-bottom: 6px #484452 double;

padding: 10px 0px 10px 0px;

text-align: center;

margin-bottom: 20px;

}

.bottomdiv {

margin-bottom: 15px;

}

.spacer {

margin-bottom: 10px;

}

Display All Video Games in Inventory

$db = mysqli_connect("stargate.ncc.edu", "sha2165","sha2165", "sha2165");

$query = "select * from inventory";

$results = mysqli_query( $db, $query)

or die (" Could not connect to DB ".mysqli_error( $db ));

//for loop

for ( $i = 0; $i

$gamearray = mysqli_fetch_array ($results);

echo "

Game name is ". $gamearray['name'] ."

";

echo "

Game price is ". $gamearray['price'] ."

";

} //ends loop

?>

I really need help figuring this out using PHP? My orofessor wil test us on something similar to this. Please asap!

Create a webpage using our video game CSS/HTML framework that does the ollowing Please note that there is NO form on this page, the page just displays the necessary data from the database at load time, similar to the show games.php that we created in class. Query your inventory database and pull out all games that have more than 10 in stock Print the video game name of each found game Print the quantity of each found game If the rating is greater than 7 print the text shown in the example in RED color If it is not greater than 7, print the displayed text in GEEN color ITE 254: Web Programming 2 Fall 2018 Search Video Games in Inventory Number of gimes found wth quantity 10is6 Tie of game is Ha Qian Sty in stock $12 Tite of game is BioShock Quansity in stock is $23 With a ontic soore of 4 S This gnme is a NOT HOT Tite cf garne per Smash Bros Melee Quanity in stock is $23 With a cre soore of 49 This ame is a hot pick TISo of gan Super Maro Sunshine Tite of game is Grand Theft Auto: Vice City Stories Quantity in stock is $19 With a oiic soore of 50 This game is a hot pick ite of game is Space Invaders Quansity in stock is 525 With a orisc soore of 5 D This game is a hot pick