l101/project/spelerszoeken.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(); ?>"> <script src='ajax.js'></script> <script> window.onload = zoeken; function zoeken() { document.getElementById('zoekbalk').onkeyup = zoekenajax; } function zoekenajax() { var zoeken = document.getElementById('zoekbalk').value; ajax('spelersx.php?zoek='+zoeken, 'zoekendiv'); } </script> </head> <body> <?php include('menubalkx.php'); ?> <div>Spelers zoeken : <input type="text" name="zoekbalk" id='zoekbalk' placeholder="Zoeken"></div> <div id="zoekendiv"><?php include('db.php'); $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='teamdetailx.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]"; $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 class = 'link' href='spelerdetailsx.php?spelerid=$row1[spelerid]'>$row1[voornaam] $row1[achternaam]</a> uit $row1[nationaliteit]</div>"; } } } ?></div> </body> </html>

Resultaat

Made by Thijs Aarnoudse