123456/Simon/auteurdetails.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('db.php');
$auteurnr= $_GET['auteurnr'];
$queryA = "select *
from auteurs a
where auteurnr='$auteurnr'";
$resultA = mysqli_query($db, $queryA);
while($rowA = mysqli_fetch_array($resultA)){
echo "<h2>$rowA[voornaam] $rowA[achternaam], $rowA[geb_jaar] </h2>";
}
$queryA = "select * from boeken where auteurnr=$auteurnr order by pub_jaar";
$resultA = mysqli_query($db, $queryA);
while($rowA = mysqli_fetch_array($resultA)){
echo "<div>$rowA[titel], $rowA[aantalpags] blz. ($rowA[pub_jaar])</a>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse