l112/sql/serieoverzicht.php
<!DOCTYPE html>
<html lang="en">
<head>
<link href="stijlsheet/stylesheet.css?t=<?php echo time(); ?>" rel="stylesheet" type="text/css">
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Series</title>
</head>
<body>
<div class="body">
<ul>
<?php
$serieid = $_GET["serieid"];
include('db.php');
include('zoekbalk.php');
// Query om de serienaam op te halen
$query = "SELECT naam FROM series WHERE serieid=$serieid";
$resultaat = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
$row = mysqli_fetch_array($resultaat);
// Serienaam weergeven
if ($row) {
echo "<h1>Serie: {$row['naam']}</h1>";
}
// Query om alle afleveringen van de serie op te halen
$query = "SELECT titel, lengte, seiznr, aflnr FROM afleveringen WHERE serieid=$serieid GROUP BY titel, seiznr, aflnr";
$resultaat = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
while ($row = mysqli_fetch_array($resultaat)){
echo "<h2>{$row['titel']}</h2>";
echo "<div><h4>Duurt {$row['lengte']} minuten</h4></div>";
echo "<div><h4>Seizoen: {$row['seiznr']} - Aflevering: {$row['aflnr']}</h4></div>";
}
?>
</ul>
<?php include('serieedite.php'); ?>
</div>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse