l106/H14/14.5.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <?php include ("../newdb.php"); setlocale (LC_ALL, 'nld_NLD'); $query = "select voornaam, geb_datum from leerlingen"; $result = mysqli_query($db, $query) or die ('Error: ' . $query); echo "<table>"; echo "<tr>"; echo "<td>Leerling<td/>"; echo "<td>Geboortedatum <td/>"; echo "<td>Leeftijd<td/>"; echo "<tr/>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>$row[voornaam] <td/>"; echo "<td>" . strftime("%d %B %Y",strtotime($row['geb_datum'])) . "<td/>"; echo "<td>" . round(((time() - strtotime($row['geb_datum'])))/ (60 * 60 * 24 * 365.25),1). "<tr/>"; echo "<tr/>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse