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