l206/Nummerdetails.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
$Nummernr = $_GET['Nummernr'];
$query = "select * from Nummer
where NummerID = $Nummernr";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<h1>$row[Nummernaam]</a></h1> <div>Band: <a href='Banddetails.php?Bandnr=$row[BandID]'>$row[Bandnaam]</a></div><div>
Artiest: <a href='Artiestdetails.php?Artiestnr=$row[ArtiestID]'>$row[Artiestnaam]</a>
$row[Achternaam]</div><div>Genre:
$row[genre]</div> <div>Lengte: $row[lengte]</div>";
?> <td><table>
</div>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse