MovieData::search PHP Method

    public function search($search)
    {
        preg_match('/imdb.com\\/title\\/(tt[0-9]+)/ms', $search, $match);
        if (strlen($match[1]) > 1) {
            $imdb = $this->getDataByImdbId($match[1]);
            return array($imdb);
        } else {
            $searchWords = Helper::searchTextToWordParams($search);
            $sth = $this->db->query('SELECT id, title, year, photo, imdbid, seasoncount FROM imdbinfo WHERE MATCH (title) AGAINST (' . $this->db->quote($searchWords) . ' IN BOOLEAN MODE) ORDER BY year DESC LIMIT 8;');
            return $sth->fetchAll(PDO::FETCH_ASSOC);
        }
    }

Usage Example

Esempio n. 1
0
     break;
 case validateRoute('DELETE', 'mailbox/\\d+'):
     $mailbox = new Mailbox($db, $user);
     httpResponse($mailbox->delete((int) $params[1]));
     break;
 case validateRoute('GET', 'moviedata/\\d+'):
     $movieData = new MovieData($db);
     httpResponse($movieData->getData($params[1]));
     break;
 case validateRoute('GET', 'moviedata/\\d+/refresh'):
     $movieData = new MovieData($db);
     httpResponse($movieData->updateImdbInfo($params[1]));
     break;
 case validateRoute('GET', 'moviedata/search'):
     $movieData = new MovieData($db);
     httpResponse($movieData->search($_GET["search"]));
     break;
 case validateRoute('GET', 'moviedata/imdb/\\w+'):
     $movieData = new MovieData($db);
     $arr = $movieData->getDataByImdbId($params[2]);
     httpResponse($arr);
     break;
 case validateRoute('GET', 'moviedata/toplist'):
     $cacheId = 'toplists-toplist';
     if ($memcache && ($cached = $memcache->get($cacheId))) {
         httpResponse($cached);
     } else {
         $movieData = new MovieData($db);
         $torrent = new Torrent($db);
         $data = $movieData->getToplist();
         $result = array();