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