l200/console3.php


<?php
    include('db1.php');
?>

<head>
<link rel="stylesheet" href="style.css">
</head>
<body>
<?php

$consoleid = $_GET['consoleid'];
$query = "select * from consoles
where consoleid = $consoleid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .":  $query");


$row = mysqli_fetch_array($result);
echo "<h1>Console: $row[naam_con] </h1>";
echo "<h3> producent: $row[producent], uitgavejaar: $row[jaar]</h3>";
$imageurl=$row['imageurl'];

$query = "select * from spelers
where consoleid = $consoleid
order by voornaam";
$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='speler.php?spelerid=$row[spelerid]'> $row[voornaam]</a></h2>";
}
echo "</div>";


$query = "select * from Consoleinfo
where consoleid = $consoleid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .":  $query");

echo "<div class=knoppen> ";
while($row = mysqli_fetch_array($result)){
    $Gameid= $row['Gameid'];
    
    $query = "select * from games where Gameid = $Gameid ";
    $result2 = mysqli_query($db1, $query) or die(mysqli_error($db1) .":  $query");
    $row2 = mysqli_fetch_array($result2);
    echo "<h2><a href='games.php?Gameid=$Gameid'> $row2[naam]</a></h2>";
}
echo "</div>";
echo "<h2 class=hoofdpagina><a href='index.php'> hoofdpagina</a></h2>";

echo "<img src='$imageurl' style='width:300px; display: block; margin-left: auto; margin-right: auto; margin-top: 20px; '>"/* Dit zorgt voor een plaatje per console waarbij de image gehaald word uit de databse */



?>
    
</body>
</html>
Resultaat

Made by Thijs Aarnoudse