(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; }
版权声明:本文为song_csdn1550原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。