l104/H14/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;
border-collapse: collapse;
}
</style>
</head>
<body>
<?php
include ('../db.php');
$query = "SELECT * FROM auteurs order by auteurnr";
$result = mysqli_query($db, $query) or die ('Error: ' . mysqli_error($db));
echo "<table>";
echo "<tr>";
$numfields = mysqli_field_count($db);
for ($i=0;$i<$numfields;$i++){
$finfo = mysqli_fetch_field_direct($result, $i);
$veldnaam = $finfo -> name;
$veldnaam = strtolower($veldnaam);
$veldnaam = ucfirst($veldnaam);
echo "<th>$veldnaam</th>";
}
echo "</tr>";
while($row = mysqli_fetch_assoc($result)){
echo "<tr>";
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>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse