hip2/gamedetails.php


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    
<?php
include('db.php');

$game_id = $_GET['game_id'];
    
    $query = "select * from games where game_id = $game_id";
$result = mysqli_query($db, $query) or die(mysqli_error($db). ": $query");

$row  = mysqli_fetch_array($result);
    echo "<h1>$row[naam]</h1>\n";
    $timestamp = strtotime($row['datum']);
    $datum = strftime("%e %B %Y", $timestamp);
    echo "<div>$datum</div> <div>Aantal verkocht: $row[verkocht]</div> <div>Leeftijdscategorie: $row[leeftijd]</div> <div>Over: $row[inhoud]</div>\n";
    


$query = "select genres.naam, genres.genre_id
            from games, gamegenres, genres
            where games.game_id = gamegenres.game_id 
            and gamegenres.genre_id = genres.genre_id 
            and games.game_id = $game_id";

            #, platformgames, platformen, gamebezit, leden, reviews 
            #and games.game_id = platformgames.game_id and platformgames.platform_id = platformen.platform_id and games.game_id = gamebezit.game_id and gamebezit.lid_id = leden.lid_id and leden.lid_id = reviews.lid_id and game_id = $game_id";

    echo "<p>Genres: ";

    $result = mysqli_query($db, $query) or die(mysqli_error($db). ": $query");
    $genres = [];
    while($row  = mysqli_fetch_array($result)){
        $genres[]= "<a href='games.php?genre_id=$row[genre_id]'>$row[naam]</a>";
    }

    echo implode(", ", $genres);

    echo "</p>";

$query = "select platformen.naam
            from games, platformgames, platformen
            where games.game_id = platformgames.game_id 
            and platformgames.platform_id = platformen.platform_id
            and games.game_id = $game_id";
    
    echo "<p>Platforms: ";

                $result = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
                $platforms = [];
                while ($row = mysqli_fetch_array($result)) {
                    $platforms[]= $row['naam'];
                }
            
        echo implode(", ", $platforms);
            
    echo "</p>";


$query = "select studios.naam
            from games, studiogames, studios
            where games.game_id = studiogames.game_id 
            and studiogames.studio_id = studios.studio_id
            and games.game_id = $game_id";

    echo "<p>Studio: ";

                $result = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
                while ($row = mysqli_fetch_array($result)) {
                    echo "$row[naam] ";
                }
            
    echo "</p>";


$query = "select count(leden.voornaam) as aantal_spelers
            from games, gamebezit, leden
            where games.game_id = gamebezit.game_id 
            and gamebezit.lid_id = leden.lid_id
            and games.game_id = $game_id";

    echo "<p>Aantal spelers: ";

            $result = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
            while ($row = mysqli_fetch_array($result)) {
                echo "$row[aantal_spelers] ";
            }
        
    echo "</p>";



$query = "select round(avg(rating), 1) as rating
            from games, gamebezit, leden, reviews 
            where games.game_id = gamebezit.game_id 
            and gamebezit.lid_id = leden.lid_id
            and leden.lid_id = reviews.lid_id
            and games.game_id = $game_id";
        
    echo "<p>Gemmidelde rating: ";

            $result = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
            while ($row = mysqli_fetch_array($result)) {
                echo "$row[rating] ";
            }
        
    echo "</p>";
#alle gegevens van een game uit de game tabel en de bijbehorende studio  
#alle genres ophalen van die game en laten zien
#consoles waarop game is
#hoeveel spelers hebben die game (kan met query schrijven met iets van count erin)
#reviews per game

?>
</body>
</html>
Resultaat

Made by Thijs Aarnoudse