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