l114/h14/14.1/14.1.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> <style> table, th, td { border: 1px solid black; } </style> </head> <body> <?php include("../../db.php"); $query = "select * from auteurs"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); ?> <table> <tr> <th>Auteurnr</th> <th>voornaam</th> <th>voorletters</th> <th>tussenvoegsel</th> <th>achternaam</th> <th>geb_jaar</th> <th>sterfjaar</th> </tr> <tr> <?php while ($row = mysqli_fetch_array($result)) { echo "<tr>"; for ($i = 0; $i < 7; $i++) { echo "<td>"; echo "$row[$i] <br>"; echo "</td>"; } echo "</tr>"; } ?> </tr> </table> </body> </html>

Resultaat

Made by Thijs Aarnoudse