l109/sacha map po/streamingsdienstdetails.php
<?php
include('menubalk.php');
include('db.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="stylesheet" href="css/style.css">
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<?php
$dienstnr = $_GET['dienst_id'];
$query ="select *
from streamingsdienst
where dienst_id = $dienstnr
order by dienst_id";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
//ophalen uit het resultaat
$row = mysqli_fetch_array($result);
echo "<h2>$row[dienstnaam]</h2>";
echo "<div><p>Prijs: $row[kosten_permaand]</p></div>";
echo "<h3>Films te zien op deze streamingsdienst:</h3>";
$query = "select *
from streamingsdienst s, films f
where s.dienst_id = f.dienst_id and s.dienst_id = $dienstnr";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
//ophalen uit het resultaat
while($row = mysqli_fetch_array($result)){
echo "<div><a href='filmdetails.php?film_id=$row[film_id]'>$row[titel]</a></div>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse