<?php
include('../db.php'); //Verbinding maken met database
//echo $zoeken;
//Als er iets in de zoekbalk is ingevuld
if($_GET['text']){
$zoeken = $_GET['text'];
$query = "select *
from acteurs
where act_voornaam like '%$zoeken%' OR act_achternaam like '%$zoeken%'
";
echo "<h3>Acteurs</h3>";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)) {
echo "<div>$row[act_voornaam] $row[act_tussenvoegsel] $row[act_achternaam]</div>";
}
$query = "select *
from films
where titel like '%$zoeken%'
";
echo "<h3>Films</h3>";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)) {
echo "<div>$row[titel]</div>";
}
$query = "select *
from streamingsdienst
where dienstnaam like '%$zoeken%'
";
echo "<h3>Streamingsdienst</h3>";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)) {
echo "<div>$row[dienstnaam]</div>";
}
}
?>