<?php
$id = $_GET['leagueID'];
//dit stukje code pakt de leagueID van de vorige link, en weet hierdoor welke teams hij moet laten zien omdat die gelinked zijn via leagueID
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link rel="stylesheet" href="style.css?t=<?php echo time() ?>">
<?php include ('functions.php');
include ('db.php');
include ('menu.php');?>
</head>
<?php
$query = "SELECT * FROM leagues WHERE leagueID = $id";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$row = mysqli_fetch_array($result);
echo "<h1>League: $row[leagueNaam] | $row[locatie]<h1>";
echo '<h3>Teams</h3>';
echo "<table><tr><th>Naam</th><th>Stad</th><th>Clubwaarde</th><th>Oprichtdatum</tr>";
$query = "SELECT * FROM teams WHERE leagueID = $id";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
while ($row = mysqli_fetch_array($result)) {
echo "<tr><td><a href='teamsDetail.php?id=$row[teamID]'>$row[team_naam]</a></td><td>$row[stad]</td><td>$row[clubwaarde]</td><td>$row[oprichtdatum]</tr>";
}
echo "</table><br><br>";
//er wordt hier info over de teams in die league laten zien, zoals het teamnaam, de stad van het team, de clubwaarde en de oprichtdatum. ook kan je via de href=teamsDetail naar de pagina van 1 team gaan, oftewel teamsDetail.php
?>
</body>
</html>