l106/PO database/teammaker.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>
<script src="js/ajax.js"></script>
<link rel = "stylesheet" type = "text/css" href = "style.css?t=<?php echo time(); ?>">
<script>
</script>
</head>
<body>
<?php
include('menubalk.php');
include('../db.php');
$queryGK = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'GK'
order by achternaam";
$resultGK = mysqli_query($db, $queryGK) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>GK :</span>";
echo "<span class='info'>";
echo "<select name='GK' id='GK'>";
echo "<option value=''></option>";
while($rowGK = mysqli_fetch_array($resultGK)){
echo "<option value='$rowGK[spelerid]'>$rowGK[achternaam], $rowGK[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryCB1 = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'CB'
order by achternaam";
$resultCB1 = mysqli_query($db, $queryCB1) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>CB1 :</span>";
echo "<span class='info'>";
echo "<select name='CB1' id='CB1'>";
echo "<option value=''></option>";
while($rowCB1 = mysqli_fetch_array($resultCB1)){
echo "<option value='$rowCB1[spelerid]'>$rowCB1[achternaam], $rowCB1[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryCB2 = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'CB'
order by achternaam";
$resultCB2 = mysqli_query($db, $queryCB2) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>CB2 :</span>";
echo "<span class='info'>";
echo "<select name='CB2' id='CB2'>";
echo "<option value=''></option>";
while($rowCB2 = mysqli_fetch_array($resultCB2)){
echo "<option value='$rowCB2[spelerid]'>$rowCB2[achternaam], $rowCB2[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryLB = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'LB'
order by achternaam";
$resultLB = mysqli_query($db, $queryLB) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>LB :</span>";
echo "<span class='info'>";
echo "<select name='LB' id='LB'>";
echo "<option value=''></option>";
while($rowLB = mysqli_fetch_array($resultLB)){
echo "<option value='$rowLB[spelerid]'>$rowLB[achternaam], $rowLB[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryRB = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'RB'
order by achternaam";
$resultRB = mysqli_query($db, $queryRB) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>RB :</span>";
echo "<span class='info'>";
echo "<select name='RB' id='RB'>";
echo "<option value=''></option>";
while($rowRB = mysqli_fetch_array($resultRB)){
echo "<option value='$rowRB[spelerid]'>$rowRB[achternaam], $rowRB[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryCM = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'CM'
order by achternaam";
$resultCM = mysqli_query($db, $queryCM) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>CM :</span>";
echo "<span class='info'>";
echo "<select name='CM' id='CM'>";
echo "<option value=''></option>";
while($rowCM = mysqli_fetch_array($resultCM)){
echo "<option value='$rowCM[spelerid]'>$rowCM[achternaam], $rowCM[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryLM = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'CM'
order by achternaam";
$resultLM = mysqli_query($db, $queryLM) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>LM :</span>";
echo "<span class='info'>";
echo "<select name='LM' id='LM'>";
echo "<option value=''></option>";
while($rowLM = mysqli_fetch_array($resultLM)){
echo "<option value='$rowLM[spelerid]'>$rowLM[achternaam], $rowLM[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryRM = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'RM'
order by achternaam";
$resultRM = mysqli_query($db, $queryRM) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>RM :</span>";
echo "<span class='info'>";
echo "<select name='RM' id='RM'>";
echo "<option value=''></option>";
while($rowRM = mysqli_fetch_array($resultRM)){
echo "<option value='$rowRM[spelerid]'>$rowRM[achternaam], $rowRM[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryST = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'ST'
order by achternaam";
$resultST = mysqli_query($db, $queryST) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>ST :</span>";
echo "<span class='info'>";
echo "<select name='ST' id='ST'>";
echo "<option value=''></option>";
while($rowST = mysqli_fetch_array($resultST)){
echo "<option value='$rowST[spelerid]'>$rowST[achternaam], $rowST[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryLW = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'LW'
order by achternaam";
$resultLW = mysqli_query($db, $queryLW) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>LW :</span>";
echo "<span class='info'>";
echo "<select name='LW' id='LW'>";
echo "<option value=''></option>";
while($rowLW = mysqli_fetch_array($resultLW)){
echo "<option value='$rowLW[spelerid]'>$rowLW[achternaam], $rowLW[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
$queryRW = "select * from Spelers, Voorkeuren, Posities
where Spelers.spelerid = Voorkeuren.spelerid and Voorkeuren.positieid = Posities.positieid
and Posities.naam = 'RW'
order by achternaam";
$resultRW = mysqli_query($db, $queryRW) or die(mysqli_error($db));
echo "<p>";
echo "<span class='label'>RW :</span>";
echo "<span class='info'>";
echo "<select name='RW' id='RW'>";
echo "<option value=''></option>";
while($rowRW = mysqli_fetch_array($resultRW)){
echo "<option value='$rowRW[spelerid]'>$rowRW[achternaam], $rowRW[voornaam] </option>";
}
echo "</select></span>";
echo "</p>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse