l106/PO database/spelers.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>
<link rel = "stylesheet" type = "text/css" href = "style.css?t=<?php echo time(); ?>">
</head>
<body>
<?php
include('menubalk.php');
include('../db.php');
// include('spelersfilter.php');
$zoek = $_GET['zoek'];
$query0 = "SELECT * FROM Teams";
$result0 = mysqli_query($db, $query0) or die(mysqli_error($db));
while ($row0 = mysqli_fetch_array($result0)){
echo"<div></div>";
echo "<h1><a class = 'link' href='TeamDetail.php?Teamid=$row0[teamid]'>$row0[naam]</a></h1>";
echo"<h3 class = 'groet' >Teamspelers</h3>";
// echo $row0['teamid'];
$query1="SELECT *
FROM Spelers
WHERE teamid = $row0[teamid] AND (voornaam LIKE '$zoek%' OR achternaam LIKE '$zoek%')";
$result1 = mysqli_query($db, $query1) or die(mysqli_error($db));
if($result1){
while($row1 = mysqli_fetch_array($result1)){
//echo"<div class = 'groet'> $row1[voornaam] $row1[achternaam] uit $row1[nationaliteit]</div>";
echo"<div class = 'groet'> <a href='spelerdetail.php?spelerid=$row1[spelerid]'>$row1[voornaam] $row1[achternaam]</a> uit $row1[nationaliteit]</div>";
}
}
// <a href='spelerdetailsx.php?spelerid=$row1[spelerid]'>$row1[voornaam] $row1[achternaam]</a>
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse