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