x102/H4.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'); $query0 = "select distinct voornaam, llnr from leerlingen "; $result0 = mysqli_query($db, $query0) or die(mysqli_error($db)); while ($row0 = mysqli_fetch_array($result0)){ echo"<div></div>"; echo "<h1>$row0[voornaam]</h1>"; echo"<div>Geleende boeken</div>"; $Nodigllnr = $row0['llnr']; $query1="select titel, datum_uit from boeken, uitleningen where uitleningen.llnr = '$Nodigllnr' and uitleningen.boeknr = boeken.boeknr"; $result1 = mysqli_query($db, $query1) or die(mysqli_error($db)); while ($row1 = mysqli_fetch_array($result1)){ $date = $row1['datum_uit']; $date = strtotime($date); $date = strftime("%A %B %Y", $date); //echo"<h1>Geleende boeken</h1>"; echo"<div>Het boek $row1[titel] is op $date uitgeleend door $row0[voornaam] "; } } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse