l206/Artiesten.php

<?php
  include('db.php');
?>

<html>
<head>
    <title>Albums</title>
    <link rel="stylesheet" href="css/style.css">
</head>
<body>
    <div class="indexpagina"> 
        <div class="menu">
            <ul> 
            <li><a href="Index.php">Home</a></li>
                <li><a href="Albums.php">Albums</a></li>
                <li><a href="Artiesten.php">Artiesten en Bands</a></li>
                <li><a href="Nummers.php">Nummers</a></li>
                <li><a href="Uitgevers.php">Uitgevers</a></li>
            </ul>
        </div>
        <table><td> <h1>Artiesten:</h1> <?php
        

    $query = "select * from Artiest";
    $result = mysqli_query($db, $query);

    while($row = mysqli_fetch_array($result)){ 
        echo "<h1>-<a href='Artiestdetails.php?Artiestnr=$row[ArtiestID]'>$row[Artiestnaam]</a></h1>";
    }
    ?> <td><table>
<h1>Bands:</h1> <?php
        

        $query = "select * from Band";
        $result = mysqli_query($db, $query);
    
        while($row = mysqli_fetch_array($result)){ 
            echo "<h1>-<a href='Banddetails.php?Bandnr=$row[BandID]'>$row[Bandnaam]</a></h1>";
        } 
        ?> 
    

    </div>
    
</body>
</html>

Resultaat

Made by Thijs Aarnoudse