home / study / engineering / computer science / computer science questions and answers / i need help making this in php? thank you. please let me know i can provide front end code.

Question: I need help making this in PHP? thank you.

(1 bookmark)

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

?>

Here is the front end code as requested. I need help making this in PHP? thank you.

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. 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