l206/Artiestdetails.php

<?php include('db.php'); ?> <html> <head> <title>Albumdetails</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> <?php $Artiestnr = $_GET['Artiestnr']; $query = "select * from Artiest where ArtiestID = $Artiestnr "; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo "<h1>$row[Artiestnaam]</h1> <div>Geboortejaar: $row[Geboortejaar]</div> <div>Aantal albums: $row[Aantalalbums]</div> <div>Aantal singles:$row[Aantalsingles]</div> <div>Band: <a href='Banddetails.php?Bandnr'>$row[Bandnaam]</a></div>"; ?> <td><table> </div> </body> </html>

Resultaat

Made by Thijs Aarnoudse