l104/H16/ajax/reservering.php
<?php
include('../../db.php');
$llnr = $_GET['llnr']??null;
$boeknr = $_GET['boeknr']??null;
if ($boeknr == 'undefined') {
$boeknr = null;
};
if ($llnr) {
echo '<div id="reserveringen"></div>';
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";
}
$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));
if ($llnr){
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)){
$voornaam = $row['voornaam']??$row['voorletters'];
echo "<tr>";
echo "<td>$row[titel]</td>";
echo "<td>$voornaam $row[tussenvoegsel] $row[achternaam]</td>";
echo "<td>$row[datum_reservering]</td>";
echo "</tr>";
}
echo "</table>";
}
}
?>
Resultaat
Made by Thijs Aarnoudse