l102/website/zoeken_ajax.php

<?php $id = $_GET['value']; include ('db.php'); $query = "SELECT * FROM spelers WHERE spelerVoornaam like '%$id%' OR spelerAchternaam like '%$id%'"; $result = mysqli_query($db, $query); echo '<h3>Spelers</h3>'; while ($row = mysqli_fetch_array($result)) { echo "<div><a href='pagina4.php?id=$row[id]'>$row[spelerVoornaam] $row[spelerAchternaam]</a></div>"; } echo '<h3>Leagues</h3>'; $query = "SELECT * FROM leagues WHERE leagueNaam like '%$id%'"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { echo "<div><a href='pagina2.php?id=$row[leagueId]'>$row[leagueNaam]</a></div>"; } echo '<h3>Teams</h3>'; $query = "SELECT * FROM teams WHERE team_naam like '%$id%'"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { echo "<div>$row[team_naam]</div>"; } $query = "SELECT * FROM staff WHERE staffvoornaam like '%$id%' OR staffachternaam like '%$id%'"; $result = mysqli_query($db, $query); echo '<h3>Staff</h3>'; while ($row = mysqli_fetch_array($result)) { echo "<div><a href='pagina4a.php?id=$row[id]'>$row[staffvoornaam] $row[staffachternaam]</a></div>"; } echo '<h3>Prijzen</h3>'; $query = "SELECT * FROM prijzen WHERE prijs_naam like '%$id%'"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { echo "<div>$row[prijs_naam]</div>"; } ?>

Resultaat

Made by Thijs Aarnoudse