l211/phpserver/boekendetails.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <?php include('db2.php'); $boeknr = $_GET['boeknr']; $query = "select * from boeken where boeknr = $boeknr"; $result = mysqli_query($db2, $query); $row = mysqli_fetch_array($result); echo "<h1>$row[boeknr] $row[titel] ($row[pub_jaar])</h1>"; $query = "select * from auteurs a, boeken b where a.auteurnr = b.auteurnr and boeknr = $boeknr"; $result = mysqli_query($db2, $query); $row = mysqli_fetch_array($result); echo "auteur:<a href='auteurdetails.php?auteurnr=$row[auteurnr]'> $row[voornaam] $row[tussenvoegsel] $row[achternaam]</a>"; echo "<div>genre: $row[genre]</div> rubriek: $row[rubriek]"; echo "<h1>geleend door</h1>"; $query = "select * from uitleningen u, leerlingen l where u.llnr = l.llnr and boeknr = $boeknr order by achternaam"; $result = mysqli_query($db2, $query); while($row = mysqli_fetch_array($result)){ if($row['llnr'] != $vorigellnr){ echo "<div><div><a href='leerlingendetails.php?llnr=$row[llnr]'>$row[llnr] $row[voornaam] $row[tussenv] $row[achternaam]</div>"; } $vorigellnr = $row['llnr'] ; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse