<!DOCTYPE html>
<html lang="en">
<head>
<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>Films</title>
<link href="stijlsheet/stylesheet.css?t=<?php echo time(); ?>" rel="stylesheet" type="text/css">
</head>
<body>
<div class="body">
<ul>
<?php
$filmserieid = $_GET['filmserieid'];
$filmid = $_GET['filmid'];
include('db.php');
include('zoekbalk.php');
//deze query laat alles zien van films
$query = "SELECT * FROM films WHERE filmid=$filmid";
$resultaat = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
$row = mysqli_fetch_array($resultaat);
//deze echo toont alleen de naam en de lengte van de film
echo "<h2> $row[titel] </h2><div> <h4>Duurt: $row[lengte] minuten</h4></div>";
//deze query kijkt naar de filmid en selecteert alle streamingsdiensten die deze film streamen
$query = "SELECT * FROM filmstream fm, streamingdiensten s WHERE fm.strid=s.strid AND filmid=$filmid";
$result = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
echo "<h2>Deze film is te bekijken op:</h2>";
while($row = mysqli_fetch_array($result)){
echo "<div><h3><a href='streamingsdienstendetails.php?strid=$row[strid]'>$row[naam]</a></h3></div>";
}
// deze query kijkt naar de filmserieid welke films bij deze id behoort
$query = "SELECT * FROM films WHERE filmid=$filmid";
$resultaat = mysqli_query($db, $query) or die(mysqli_error($db) . ": $query");
$row = mysqli_fetch_array($resultaat);
if ($filmserieid > 0){
echo "<h2><a href='seriedetails.php?filmserieid=$row[filmserieid]&filmid=$row[filmid]'>Andere films in deze reeks</a></h2>";
}
?>
</ul>
<?php include('filmsedite.php'); ?>
</div>
</body>
</html>