PHP Base::getDb方法代码示例

 public static function getSerieById($serieId)
 {
     $result = parent::getDb()->prepare('select id, name  from series where id = ?');
     $result->execute(array($serieId));
     if ($post = $result->fetchObject()) {
         return new Serie($post);
     }
     return NULL;
 }

 public static function getTagById($tagId)
 {
     $result = parent::getDb()->prepare('select id, name  from tags where id = ?');
     $result->execute(array($tagId));
     if ($post = $result->fetchObject()) {
         return new Tag($post);
     }
     return NULL;
 }

    public static function getAuthorByBookId($bookId)
    {
        $result = parent::getDb()->prepare('select ' . self::AUTHOR_COLUMNS . ' from authors, books_authors_link
where author = authors.id
and book = ?');
        $result->execute(array($bookId));
        $authorArray = array();
        while ($post = $result->fetchObject()) {
            array_push($authorArray, new Author($post));
        }
        return $authorArray;
    }

    public static function getAuthorByBookId($bookId)
    {
        $result = parent::getDb()->prepare('select authors.id as id, authors.name as name, authors.sort as sort from authors, books_authors_link
where author = authors.id
and book = ?');
        $result->execute(array($bookId));
        $authorArray = array();
        while ($post = $result->fetchObject()) {
            array_push($authorArray, new Author($post));
        }
        return $authorArray;
    }

    public static function getAllLanguages()
    {
        $result = parent::getDb()->query('select languages.id as id, languages.lang_code as lang_code, count(*) as count
from languages, books_languages_link
where languages.id = books_languages_link.lang_code
group by languages.id, books_languages_link.lang_code
order by languages.lang_code');
        $entryArray = array();
        while ($post = $result->fetchObject()) {
            $language = new Language($post->id, $post->lang_code);
            array_push($entryArray, new Entry(Language::getLanguageString($language->lang_code), $language->getEntryId(), str_format(localize("bookword", $post->count), $post->count), "text", array(new LinkNavigation($language->getUri())), "", $post->count));
        }
        return $entryArray;
    }

    public static function getAllCustoms($customId)
    {
        $result = parent::getDb()->query(str_format('select {0}.id as id, {0}.value as name, count(*) as count
from {0}, {1}
where {0}.id = {1}.{2}
group by {0}.id, {0}.value
order by {0}.value', self::getTableName($customId), self::getTableLinkName($customId), self::getTableLinkColumn($customId)));
        $entryArray = array();
        while ($post = $result->fetchObject()) {
            $customColumn = new CustomColumn($post->id, $post->name, $customId);
            array_push($entryArray, new Entry($customColumn->name, $customColumn->getEntryId(), str_format(localize("bookword", $post->count), $post->count), "text", array(new LinkNavigation($customColumn->getUri())), "", $post->count));
        }
        return $entryArray;
    }

 public function doSearchByCategory()
 {
     $database = GetUrlParam(DB);
     $out = array();
     $pagequery = Base::PAGE_OPENSEARCH_QUERY;
     $dbArray = array("");
     $d = $database;
     $query = $this->query;
     // Special case when no databases were chosen, we search on all databases
     if (Base::noDatabaseSelected()) {
         $dbArray = Base::getDbNameList();
         $d = 0;
     }
     foreach ($dbArray as $key) {
         if (Base::noDatabaseSelected()) {
             array_push($this->entryArray, new Entry($key, DB . ":query:{$d}", " ", "text", array(new LinkNavigation("?" . DB . "={$d}")), "tt-header"));
             Base::getDb($d);
         }
         foreach (array(PageQueryResult::SCOPE_BOOK, PageQueryResult::SCOPE_AUTHOR, PageQueryResult::SCOPE_SERIES, PageQueryResult::SCOPE_TAG, PageQueryResult::SCOPE_PUBLISHER) as $key) {
             if (in_array($key, getCurrentOption('ignored_categories'))) {
                 continue;
             }
             $array = $this->searchByScope($key, TRUE);
             $i = 0;
             if (count($array) == 2 && is_array($array[0])) {
                 $total = $array[1];
                 $array = $array[0];
             } else {
                 $total = count($array);
             }
             if ($total > 0) {
                 // Comment to help the perl i18n script
                 // str_format (localize("bookword", count($array))
                 // str_format (localize("authorword", count($array))
                 // str_format (localize("seriesword", count($array))
                 // str_format (localize("tagword", count($array))
                 // str_format (localize("publisherword", count($array))
                 array_push($this->entryArray, new Entry(str_format(localize("search.result.{$key}"), $this->query), DB . ":query:{$d}:{$key}", str_format(localize("{$key}word", $total), $total), "text", array(new LinkNavigation("?page={$pagequery}&query={$query}&db={$d}&scope={$key}")), Base::noDatabaseSelected() ? "" : "tt-header", $total));
             }
             if (!Base::noDatabaseSelected() && $this->useTypeahead()) {
                 foreach ($array as $entry) {
                     array_push($this->entryArray, $entry);
                     $i++;
                     if ($i > 4) {
                         break;
                     }
                 }
             }
         }
         $d++;
         if (Base::noDatabaseSelected()) {
             Base::clearDb();
         }
     }
     return $out;
 }

    public static function getBookByDataId($dataId)
    {
        $result = parent::getDb()->prepare('select ' . self::BOOK_COLUMNS . ', data.name, data.format
from data, books ' . self::SQL_BOOKS_LEFT_JOIN . '
where data.book = books.id and data.id = ?');
        $result->execute(array($dataId));
        while ($post = $result->fetchObject()) {
            $book = new Book($post);
            $data = new Data($post, $book);
            $data->id = $dataId;
            $book->datas = array($data);
            return $book;
        }
        return NULL;
    }

 public static function getDataByBook($book)
 {
     $out = array();
     $result = parent::getDb()->prepare('select id, format, name
                                          from data where book = ?');
     $result->execute(array($book->id));
     while ($post = $result->fetchObject()) {
         array_push($out, new Data($post, $book));
     }
     return $out;
 }

 public static function getRatingById($ratingId)
 {
     $result = parent::getDb()->prepare('select rating from ratings where id = ?');
     $result->execute(array($ratingId));
     return new Rating($ratingId, $result->fetchColumn());
 }

 /**
  * Get the title of a CustomColumn by its customID
  *
  * @param integer $customId
  * @return string
  */
 protected static function getTitleByCustomID($customId)
 {
     $result = parent::getDb()->prepare('SELECT name FROM custom_columns WHERE id = ?');
     $result->execute(array($customId));
     if ($post = $result->fetchObject()) {
         return $post->name;
     }
     return "";
 }