Untitled

<!DOCTYPE html>
<html lang='nl'>
<head>
    <link rel="stylesheet" href="CSS/Main-stylesheet.css">
    <title>SearchBar</title>
    <meta charset='UTF-8'>
</head>
<body>
    <header>
        <?php include("template_header.php"); ?>
    </header>
    <section>
    <form method="post">
        <input class="Login-input" type="text" name="search">
        <select name="zoekterm">
            <option value="titel">Titel</option>
            <option value="genre">Genre</option>
            <option value="year"> Publication year</option>
            <option value="character"> Character name</option>
        </select>
        <input type="submit" name="SEND"   value="Search Movies"><br><br>
    </form>
    </section>
<footer>
    <?php include("template_footer.php"); ?>
</footer>
</body>
</html>

<?php
$hostname = "(local)";
$dbname = "Fletnix";
$username = "sa";
$password = "SA";

$connection = new PDO("sqlsrv:Server=(local);Database=Fletnix",$username,$password);

$searchType = "Niks";
if (isset($_POST['SEND'])) {
    $zoekterm = $_POST['zoekterm'];
    if ($zoekterm == 'titel') {
        $searchInput = $_POST['search'];
        $sql = "SELECT DISTINCT title
                FROM Movie
                WHERE title LIKE '%$searchInput%'
                ORDER BY title ASC";
        $query = $connection->prepare($sql);
        $query->execute();
        $results = $query->fetchAll(PDO::FETCH_ASSOC);
        echo "Results for titles like ($searchType):<br><b>";
        foreach ($results as $item) {
            echo $item['title'] . "<br>";
        }
    }
    else if ($zoekterm == 'genre') {
        $searchInput = $_POST['search'];
        $sql = "SELECT DISTINCT M.title
                FROM Movie M INNER JOIN Movie_Genre MG
                             ON M.Movie_id = MG.Movie_id
                WHERE MG.genre_name LIKE '%$searchInput%'
                ORDER BY title ASC";
        $query = $connection->prepare($sql);
        $query->execute();
        $results = $query->fetchAll(PDO::FETCH_ASSOC);
        echo "Results for movies with the genre ($searchInput):<br><br>";
        foreach ($results as $item) {
            echo $item['title'] . "<br>";
        }
    }
    else if ($zoekterm == 'year') {
        $searchInput = $_POST['search'];
        $sql = "SELECT DISTINCT title
                FROM Movie
                WHERE publication_year LIKE '%$searchInput%'
                ORDER BY title ASC";
        $query = $connection->prepare($sql);
        $query->execute();
        $results = $query->fetchAll(PDO::FETCH_ASSOC);
        echo "Results for movies released in ($searchInput):<br><br>";
        foreach ($results as $item) {
            echo $item['title'] . "<br>";
        }
    }
    else if ($zoekterm == 'character') {
        $searchInput = $_POST['search'];
        $sql = "SELECT DISTINCT M.title
                FROM movie M  INNER JOIN Movie_cast MC
			                  ON M.movie_id = MC.movie_id
			                  INNER JOIN Person P
			                  ON P.person_id = MC.person_id
                where role LIKE '%$searchInput%'
                ORDER BY title ASC";
        $query = $connection->prepare($sql);
        $query->execute();
        $results = $query->fetchAll(PDO::FETCH_ASSOC);
        echo "Results for movies with the character name ($searchInput):<br><br>";
        foreach ($results as $item) {
            echo $item['title'] . "<br>";
        }
    }
    else {
        echo 'Probleem met het zoeken';
    }
}
?>