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