A4.php
I1_1.php
I1_2.php
I2_1.php
J2_1.php
J2_2.php
K3_1.php
L2_1.php
L2_2.php
M1_1.php
M1_2.php
MaxBoesBoxem_V5b.txt
ajax.js
db.php
index.php

I2_1.php


<?php
    include "db.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>
        td{
            border: 1px solid black;
        }
    </style>
</head>
<body>
    <table>
    <?php
        $result = mysqli_query($db, "SELECT DISTINCT achternaam, titel, genre, pub_jaar FROM auteurs, boeken WHERE auteurs.auteurnr = boeken.auteurnr ORDER BY achternaam");
        while($row = mysqli_fetch_array($result)){
            echo "<tr>";
            for($i = 0; $i < count($row)/2; $i++){
                echo "<td>$row[$i]</td>";
            }
            echo "</tr>";
        }
    ?>
    </table>
</body>
</html>

Resultaat

Made by Thijs Aarnoudse