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'>&nbsp;</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'>&nbsp;</span><span class='info'><input type='submit' value='Reserveren'></span></p>"; } else{ //echo "Kies eerst een boek\n"; }*/

Resultaat

Made by Thijs Aarnoudse