1 $query0 = ImGroupUser::find()->where([‘gid‘=>‘56680dfc60b215d62104a4d8‘])->select(‘user_client_id‘)->all();//AR 2 $query1=ImGroupUser::findAll([‘gid‘=>‘56680dfc60b215d62104a4d8‘]);//AR 3 $query2=ImGroupUser::findBySql("select user_client_id from im_group_user where gid=‘56680dfc60b215d62104a4d8‘")->all();//AR 4 $query3=ImGroupUser::find()->where([‘gid‘=>‘56680dfc60b215d62104a4d8‘])->select(‘user_client_id‘)->asArray()->all();//Array 5 $query = new yii\db\Query(); 6 $query4 = $query 7 ->select([‘user_client_id‘]) 8 ->from([‘im_group_user‘]) 9 ->where([‘gid‘=>‘56680dfc60b215d62104a4d8‘]) 10 ->all();//Array 11 $arr=[]; 12 foreach($query4 as $key=>$value){ 13 // $arr[]=$value->user_client_id; 14 $arr[]=$value[‘user_client_id‘]; 15 } 16 var_dump($arr);
AR查询结果默认为AR单条数据的对象,返回AR对象,用13行取对象结果集,返回Array对象用14行取结果集 注意query4查询结果为数组对象
原文:http://www.cnblogs.com/JimmyBright/p/5045857.html