<?php
include('../db.php'); //Verbinding maken met database
if($_GET['input_film']){
$zoeken_film = $_GET['input_film'];
$query = "select *
from films
where titel like '%$zoeken_film%'";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)) {
echo "<a class='link-verwijzing' href='filmdetails.php?film_id=$row[film_id]'>";
echo "<div class='link'><p>$row[titel]</p></div>";
echo "</a>";
}
} else {
$query = "select *
from films
order by titel";
//resultaat opslaan in variabele
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "<div class='link-container'>";
//Ophalen uit het resultaat en resultaat laten zien
while($row = mysqli_fetch_array($result)){
//link naar pagina filmdetails
echo "<a class='link-verwijzing' href='filmdetails.php?film_id=$row[film_id]'>";
echo "<div class='link'><p>$row[titel]</p></div>";
echo "</a>";
}
echo "</div>";
}
?>