PHP Book_Model_DbTable_Tags::select示例

示例#1

文件： Post.php 项目： HiLeo1610/tumlumsach

 public function getTaggedBooks()
 {
     $tagTbl = new Book_Model_DbTable_Tags();
     $tagSelect = $tagTbl->select()->where('object_type = ?', 'book')->where('post_id = ?', $this->getIdentity());
     $bookIds = array();
     foreach ($tagTbl->fetchAll($tagSelect) as $row) {
         array_push($bookIds, $row->object_id);
     }
     if (!empty($bookIds)) {
         $bookTbl = new Book_Model_DbTable_Books();
         $bookTblName = $bookTbl->info(Zend_Db_Table_Abstract::NAME);
         $bookSelect = $bookTbl->getSelect();
         $bookSelect->where("{$bookTblName}.book_id in (?)", $bookIds);
         return $bookTbl->fetchAll($bookSelect);
     }
     return array();
 }