l208/auteursdetails.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> </head> <body> <?php include ("db.php"); $auteurnr = $_GET['auteurnr']; $query = "select * from auteurs where auteurnr = $auteurnr order by achternaam"; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo"<h1>$row[auteurnr] $row[voornaam] $row[achternaam]</H1>"; echo "<h3>$row[geb_jaar]</h3>"; echo "<h2>boeken geschreven</h2>"; $query = "select * from auteurs a, boeken b where a.auteurnr = b.auteurnr and a.auteurnr = $auteurnr"; $result = mysqli_query($db, $query)or die (mysqli_error($db)); while($row = mysqli_fetch_array($result)){ echo "<div><a href=boekdetails.php?boeknr=$row[boeknr]>- $row[titel]</a></div>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse