123456/ajax/opdracht/reserveren.php

<?php include('../includes/db.php'); $llnr= $_GET['llnr']; $boeknr= $_GET['boeknr']; if($llnr && $boeknr){ $datum = strftime("%Y-%m-%d",time()); $query = "insert into reserveringen values($boeknr, $llnr, '$datum',null,'N','open');"; $result = mysqli_query($db_link, $query) or die(mysqli_error($db_link)); } if($llnr){ $query = "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"; $result = mysqli_query($db_link, $query) or die(mysqli_error($db_link)); echo "<table>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; $datum = strftime("%d %B %Y",strtotime($row[datum_reservering])); echo "<td>$row[titel] - $row[achternaam] - $datum</span></td>\n"; echo "</tr>"; } echo "</table>"; } ?>

Resultaat

Made by Thijs Aarnoudse