l208/leerlingendetails.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');
$llnr = $_GET['llnr'];
$query = "select * from leerlingen
where llnr = $llnr
order by achternaam ";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<h2>$row[llnr] $row[voornaam] $row[tussenv] $row[achternaam]</h2>";
echo "is $row[geslacht] en is geboren op $row[geb_datum]. woont in de straat $row[straat] in $row[plaats]. telefoonnumer is: $row[telefoon] en zit in de klas $row[klas]";
echo "<h1> boeken geleend</h1>";
$query = "select * from boeken b, uitleningen u
where b.boeknr = u.boeknr and llnr = $llnr";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
while($row = mysqli_fetch_array($result)){
echo "<div><a href=boekdetails.php?boeknr=$row[boeknr]>- $row[titel]</a> uitgeleend op $row[datum_uit]</div>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse