l107/H16/boekinfoza.php
<?php
if($boeknr || $leerlingnr){
$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=$leerlingnr
order by datum_reservering desc";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "<table>";
echo "<tr><th></th><th></th><th></th></tr>";
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td><span class='info'>$row[titel] - </span></td>";
echo "<td>$row[achternaam] - </td>";
$datum = strftime("%d %B %Y" , strtotime($row['datum_reservering']));
echo "<td>$datum</td>";
echo "</tr>";
}
echo "</table>";
echo "<p><span class='label'> </span><span class='info'><input type='submit' value='Reserveren'></span></p>";
}
else{
//echo "Kies eerst een boek\n";
}
/*if($boeknr){
$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=$leerlingnr
order by datum_reservering desc";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "<table>";
echo "<tr><th></th><th></th><th></th></tr>";
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td><span class='info'>$row[titel]</span></td>";
echo "<td>-</td>";
echo "<td>$row[achternaam]</td>";
echo "<td>-</td>";
$datum = strftime("%d %B %Y" , strtotime($row['datum_reservering']));
echo "<td>$datum</td>";
echo "</tr>";
}
echo "</table>";
echo "<p><span class='label'> </span><span class='info'><input type='submit' value='Reserveren'></span></p>";
}
else{
//echo "Kies eerst een boek\n";
}*/
Resultaat
Made by Thijs Aarnoudse