三个表分别是
articles
id caption
1 xxx
2 fff
categories
id category_caption
1 ddd
2 kkk
3 sss
articles_categories
id article_id category_id
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
class Articles extends Zend_Db_Table_Abstract
{
protected $_name = 'products';
protected $_dependentTables = array('ArticlesCategories');
}
class Categories extends Zend_Db_Table_Abstract
{
protected $_name = 'categories';
protected $_dependentTables = array('ArticlesCategories');
}
class ArticlesCategories extends Zend_Db_Table_Abstract
{
protected $_name = 'articles_categories';
protected $_referenceMap = array(
'Article' => array(
'columns' => array('article_id'),
'refTableClass' => 'Articles',
'refColumns' => array('article_id')
),
'Category' => array(
'columns' => array('category_id'),
'refTableClass' => 'Categories',
'refColumns' => array('category_id')
)
}
$articles = new Articles();
//遍历所有文章
foreach($articles->fetchAll() as $article)
{
//获取类别
$categories = $article->findCategoriesViaArticlesCategoriesByArticle();
/*
爱干啥干啥
*/
}
