yii2 SUM用法
来源:互联网 发布:网络出版服务规定 编辑:程序博客网 时间:2024/06/04 17:41
(new \yii\db\Query()) ->select(["SUM(ht_sina.sina_fans) as fans","SUM(ht_sina) as ones"]) ->from('ht_sina') ->innerjoin("ht_sinegory","ht_sinacory.cid=ht_sinaa_cid") //->innerjoin("ht_media","ht_m=dia.media_id=ht_siedia_id") ->innerjoin("ht_admin","ht_adn.admin_id=ht_sina.n_id") ->where($where) ->andwhere($weiboname) ->andwhere($weiboid) ->andwhere($sinafans)
->andwhere($updatetime) ->all();
多条件查询 放进数组
$weiboname = ""; if(!empty($sinaame)) { $weiboname = ['like','ht_sina.na_name',$sa_name]; } $weiboid = ""; if(!empty($sina_nmber)) $weiboid = ['like','ht_sina.sina_umber',$sina_nur]; } $sinafans = ""; if(!empty($sina_fans) && !empty($sina_f-09anss)) { $sinafans = ['between', 'ht_sina.na_fans', "$si_fans", "$iu"]; }else { if(!empty($na_fans)) { $where['ht_sina.sa_fans'] = $sina_fans; }else if(!empty($sina_anss)) { $where['ht_sina.sna_fans'] = $sina_fanss; } } if(!empty($sina_fenlei)) { $where['ht_sinacategory.cname'] = $sina_fenlei; }
0 0