yii联表查询

最新推荐文章于 2021-12-09 10:48:52 发布

design321

最新推荐文章于 2021-12-09 10:48:52 发布

阅读量1.1k

点赞数

分类专栏： yii

本文链接：https://blog.csdn.net/design321/article/details/42149559

版权

yii 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

$criteria = new CDbCriteria;
        $criteria->join = "JOIN hm_live_catalog on t.catalog_id=hm_live_catalog.id";
        $criteria->addColumnCondition(array('hm_live_catalog.os' => 1));
        $criteria->addColumnCondition(array('t.status' => 1));
        $criteria->addColumnCondition(array('t.com_id' => $this->com_id));
        $criteria->addInCondition('catalog_id', $arrCatalogId);
        $total = Content::model()->count($criteria);
        $content = Content::model()->findAll($criteria);

$attr = array('username' => $params['username'], 'email' => $params['email']);
        $member = Member::model()->findByAttributes($attr);
        p($member->username) ;

添加：

$tag_model = new Tag('add');
$tag_model->tag = $tag;
$tag_model->save();
$id = $tag_model ->id;

删除：

$criteria = new CDbCriteria();
$criteria->addColumnCondition(array('content_id' => $contentid));
$deleteR = ContentTag::model()->deleteAll($criteria);