l104/H14/14.5.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <?php include ('../db.php'); $query = "SELECT voornaam, tussenvoegsel, achternaam, geb_datum FROM leerlingen"; $result = mysqli_query($db, $query) or die ('Error: ' . $query); echo '<table>'; echo '<tr>'; echo '<th>Leerling</th>'; echo '<th>Geboortedatum</th>'; echo '<th>Leeftijd</th>'; echo '</tr>'; while ($row = mysqli_fetch_assoc($result)){ echo '<tr>'; echo "<td>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</td>"; echo "<td>" . strftime('%e %B %Y',strtotime($row['geb_datum'])) . "</td>"; echo "<td>" . (new DateTime($row['geb_datum']))->diff(new DateTime())->y . "</td>"; echo '</tr>'; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse