l208/studiodetails.php

<!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>Document</title> <link rel="stylesheet" href="style/style.css"> </head> <body> <div class="menubalk"> <a border="10" href="studio.php">studio's</a> <a href="film.php">films</a> <a href="characters.php">characters</a> <a href="personen.php">personen</a> </div> <?php include("db.php"); $stid = $_GET['studioid']; $query = "select * from studio where studioid = $stid"; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo "<h1>$row[naam]</h1>"; echo "<div><p> opgericht in het jaar: $row[oprichtjaar]</p> </div>"; echo "<div><p>aantal gemaakte films: $row[aantalflm]</p></div>"; echo "<p>film afdelingen die horen bij de studio: </p><div><p>$row[filmafdelingen]</p></div>"; $query = "select * from studio u, films f where f.studioid = u.studioid and f.studioid = $stid"; $result = mysqli_query($db, $query) ; echo"<p>films gemaakt door de studio:</p>"; while ($row = mysqli_fetch_array($result)){ echo"<div><a href='filmdetails.php?filmid=$row[filmid]'>$row[titel]</div>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse