16.1/leerlingreserveringza.php
<?php
include "../db.php";
include "../functions.php";
$llnr = $_POST["llnr"];
$boeknr = $_POST["boeknr"];
if(isset($llnr) && isset($boeknr)){
$time = strftime("%Y-%m-%d", time());
$result = mysqli_query($db, "SELECT datum_terug FROM uitleningen WHERE boeknr = $boeknr");
while($row = mysqli_fetch_row($result)){
}
mysqli_query($db, "INSERT INTO reserveringen VALUES ()");
}
?>
<!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
?>
<form method="post">
<span>Leerlingen: </span>
<select name="llnr">
<?php
$result = mysqli_query($db, "SELECT voornaam, tussenvoegsel, achternaam, llnr FROM leerlingen");
while($row = mysqli_fetch_row($result)){
echo "<option value=$row[3]>$row[1] $row[2], $row[0]</option>";
}
?>
</select>
<br><br>
<span>Auteurs: </span>
<select name="llnr">
<?php
$result = mysqli_query($db, "SELECT voornaam, tussenvoegsel, achternaam, auteurs.auteurnr, titel FROM auteurs, boeken
WHERE auteurs.auteurnr = boeken.auteurnr");
while($row = mysqli_fetch_row($result)){
echo "<option value=$row[3]>$row[1] $row[2], $row[0] - $row[4]</option>";
}
?>
</select>
<input type="submit">
</form>
<br>
<?php
if(isset($llnr)){
$result = mysqli_query($db, "select b.titel, a.achternaam, r.datum_reservering
from auteurs a, boeken b, reserveringen r, leerlingen l
where a.auteurnr = b.auteurnr and b.boeknr = r.boeknr
and r.llnr = l.llnr and l.llnr=$llnr
order by datum_reservering desc
");
echo formattable($result, "border");
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse