l103/Leerlingdetails.php
<?php
include('db.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Leerling</title>
</head>
<body>
<?php
$llnr = $_GET['llnr']; //ophalen uit het adres ?llnr= ....
$query = "select * from leerlingen
where llnr = $llnr
order by achternaam ";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<h2>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</h2>";
$row['geb_datum'] = strftime("%d %B %Y", strtotime($row['geb_datum']));
echo "<p>Klas $row[klas], $row[plaats] $row[postcode] $row[geb_datum]</p>";
$query = "select * from auteurs a, boeken b, uitleningen u
where a.auteurnr = b.auteurnr and b.boeknr = u.boeknr and u.llnr = $llnr";
$result = mysqli_query($db, $query);
while($row = mysqli_fetch_array($result)){
$row['datum_uit'] = strftime("%d %B %Y", strtotime($row['datum_uit']));
echo "<div><a href='boekdetails.php?boeknr=$row[boeknr]'>$row[titel]</a>, <a href='auteurdetails.php?auteurnr=$row[auteurnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</a>($row[datum_uit])</div>\n";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse