<?php
include "db.php";
$zoek = $_GET["zoek"];
$query = "SELECT * FROM afleveringen WHERE serienaam like '%$zoek%' OR titel like '%$zoek%'";
$result = mysqli_query($db, $query);
if($result){
echo '<div><h2>Afleveringen</h2></div>';
while ($row = mysqli_fetch_array($result)) {
echo "<div><a href='afleveringen.php?serieid=$row[serieid]&seiznr=$row[seiznr]'>$row[titel] - $row[serienaam]</a></div>";
}
}
$query = "SELECT * FROM films WHERE titel like '%$zoek%'";
$result = mysqli_query($db, $query);
if($result){
echo '<div><h2>Films</h2></div>';
while ($row = mysqli_fetch_array($result)) {
echo "<div><a href='zoek2.php?filmid=$row[filmid]'>$row[titel]</a></div>";
}
}
$query = "SELECT * FROM series WHERE naam like '%$zoek%'";
$result = mysqli_query($db, $query);
if($result){
echo '<div><h2>Series</h2></div>';
while ($row = mysqli_fetch_array($result)) {
echo "<div><a href='zoek2.php?serieid=$row[serieid]'>$row[naam]</div>";
}
}
$query = "SELECT * FROM streamingsdiensten WHERE naam like '%$zoek%'";
$result = mysqli_query($db, $query);
if($result){
echo '<div><h2>Streamingsdiensten</h2></div>';
while ($row = mysqli_fetch_array($result)) {
echo "<div>$row[naam]</div>";
}
}
?>