123456/V5 PO PHP/Twan, Wout en Syb/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