<?php
error_reporting(E_ALL);

$dsn = 'mysql:dbname=movies;host=127.0.0.1';
$user = 'root';
$password = '';

// Yhteyden muodostus
try {
    $pdo = new PDO($dsn, $user, $password); // Uusi PDO objekti

} catch (PDOException $e) {

    echo 'Connection failed: ' . $e->getMessage();
}

if(isset($_POST['search']))  {

    $searchq = $_POST['search'];
    $data = array();

    $sql = "SELECT * FROM `movie-info` WHERE `keywords` LIKE :keyword"; // SQL-kysely
    $stmt = $pdo->prepare($sql);

    // Suoritetaan SQL-kysely
    $stmt->execute(array(
      'keyword' => '%' . $_POST['search'] . '%'
      ));

    // Ei hakutuloksia
    if($stmt->rowCount() == 0) {

        $data['error'] = true;
        $data['message'] = 'There is no search results!';

        echo json_encode($data);
        exit();

    // Jos tuloksia
    } else {

        $i = 0;

        $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

        foreach($results as $row) {

            // Tallennetaan data -taulukkoon, omalla tietokannan id arvollaan
            $output = '<div id="title"><b>Otsikko: </b>'.$row['title'].'</div>';
            $output .= '<div id="description"><b>Kuvaus: </b>'.$row['description'].'</div>';
            echo $output;
        }

    } // end of else
} // end of if statement