connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit(); // you should redirect to some form of error page !!!!
}
//need info from Games just to display
$gamesResult = mysqli_query($dbconn, "SELECT GameID, GameName FROM games ORDER BY GameID" );
$gameArray = array();
$dropdown = "";
if (mysqli_num_rows($gamesResult) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($gamesResult)) {
$id = $row['GameID'];
$gameName = $row['GameName'];
$gameArray += array($id => $gameName );
}
} else {
echo "0 results";
}
foreach ($gameArray as $key => $value) {
//we are building the option thingy
$dropdown .= "";
}
?>
Media Rental 2021