l200/games.php
<?php
include('db1.php');
?>
<head>
<link rel="stylesheet" href="style.css">
</head>
<body>
<?php
$Gameid = $_GET['Gameid'];
$query = "select * from games where Gameid = $Gameid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
$row = mysqli_fetch_array($result);
echo "<h1>Game: $row[naam] </h1>";
echo "<h3> uitgave: $row[uitgave], genre: $row[genre], engine: $row[engine] </h3>";
$bedrijfid = $row['bedrijfid'];
$query = "select * from games g, Consoleinfo ci, consoles c
where ci.Gameid = $Gameid and ci.consoleid = c.consoleid and g.Gameid = $Gameid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
echo "<div class=knoppen> ";
while($row = mysqli_fetch_array($result)){
echo "<h2><a href='console3.php?consoleid=$row[consoleid]'> $row[naam_con]</a></h2>";
}
echo "</div>";
echo "<div class=knoppen> ";
$query = "select * from Gamemakers where bedrijfid = $bedrijfid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
$row = mysqli_fetch_array($result);
echo "<h2><a href='gamemakersdetails.php?bedrijfid=$bedrijfid'> $row[Naam_game]</a></h2>";
echo "</div>";
echo "<h2 class=hoofdpagina><a href='index.php'> hoofdpagina</a></h2>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse