daily programmer 83int search - taion809

<?php

class Search
{
    private $DB = NULL;

    public function __construct()
    {
        $this->openDB();
    }

    public function __destruct()
    {
        $this->closeDB();
    }

    public function search($search_term)
    {
        $results = $this->searchDB($search_term);

        return $results;
    }

    private function searchDB($search_term)
    {
        try
        {
            $handler = $this->DB->prepare("SELECT * FROM ft_words WHERE word MATCH :word");
            $handler->execute(array(":word" => $search_term));
            $handler->setFetchMode(PDO::FETCH_ASSOC);
            $result = $handler->fetchAll();

            return $result;
        }
        catch(PDOException $e)
        {
            $e->getMessage();
        }
    }

    private function openDB()
    {
        try
        {
            $this->DB = new PDO("sqlite:index.db");
            $this->DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

            return true;
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
            return false;
        }
    }

    private function closeDB()
    {
        $DB = NULL;
    }
}

?>