l106/H14/H14.1.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> <style> table, th, td { border: 1px solid black; border-collapse: collapse; } </style> </head> <body> <?php include('../newdb.php'); $query = "Select * From auteurs"; $result = mysqli_query($db, $query) or die (mysqli_error($db)); echo "<table>"; echo "<td>Auteurnummer</td>"; echo "<td>Voornaam</td>"; echo "<td>Voorletter</td>"; echo "<td>Tussenvoegsel</td>"; echo "<td>Achternaam</td>"; echo "<td>Geb_jaar</td>"; echo "<td>Sterfjaar</td>"; echo"</tr>"; while($row = mysqli_fetch_array($result)){ echo "<td>$row[auteurnr]</td>"; echo "<td>$row[voornaam]</td>"; echo "<td>$row[voorletters]</td>"; echo "<td>$row[tussenvoegsel]</td>"; echo "<td>$row[achternaam]</td>"; echo "<td>$row[geb_jaar]</td>"; echo "<td>$row[sterfjaar]</td>"; echo "</tr>"; } echo "</table>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse