l104/H16/leerlingenza.php
<?php
$llnr = $_GET['llnr'] ? $_GET['llnr'] : null;
$boeknr = $_GET['boeknr'] ? $_GET['boeknr'] : null;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<style>
.label {
display: inline-block;
padding: 5px;
width: 100px;
text-align: right;
}
table tr th, table tr td {
padding: 5px;
}
</style>
<script>
onload = setEvents
function setEvents(){
document.getElementById('llnr').onchange = llnrChange
}
function llnrChange(){
var auteurnr =this.options[this.selectedIndex].value;
document.location='?llnr=' + auteurnr;
}
</script>
</head>
<body>
<?php
include('../db.php');
$queryll = 'select * from leerlingen';
$resultll = mysqli_query($db, $queryll) or die(mysqli_error($db));
$querybk = 'select * from boeken b, auteurs a where a.auteurnr=b.auteurnr';
$resultbk = mysqli_query($db, $querybk) or die(mysqli_error($db));
if ($llnr){
$queryrs = "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 r.datum_reservering desc";
$resultrs = mysqli_query($db, $queryrs) or die(mysqli_error($db));
}
echo '<form action="" method ="get">';
echo '<div><span class="label">Leerlingen:</span><select name="llnr" id="llnr">';
echo "<option></option>";
while($row = mysqli_fetch_array($resultll)){
$select = ($row['llnr'] == $llnr) ? 'selected' : '';
echo "\n<option value=$row[llnr] $select>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>";
}
echo '</select>';
echo '<div><span class="label">Boeken:</span><select name="boeknr" id="llnr">';
echo "<option></option>";
while($row = mysqli_fetch_array($resultbk)){
$select = ($row['boeknr'] == $boeknr) ? 'selected' : '';
echo "<option value=$row[boeknr] $select>$row[titel] - $row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>";
}
echo '</select>';
echo '<div><span class="label"><input type="submit" value="Reserveer"></div>';
echo '</form>';
if ($llnr &&!$boeknr){
echo "<table>";
echo "<tr>";
echo "<th>Titel</th>";
echo "<th>Auteur</th>";
echo "<th>Datum reservering</th>";
echo "</tr>";
while($row = mysqli_fetch_array($resultrs)){
echo "<tr>";
echo "<td>$row[titel]</td>";
echo "<td>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</td>";
echo "<td>$row[datum_reservering]</td>";
echo "</tr>";
}
echo "</table>";
}
if ($llnr && $boeknr){
$query = "insert into reserveringen (llnr, boeknr, datum_reservering) values ($llnr, $boeknr, now())";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "Boek is gereserveerd";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse