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