insert sql result inside array in yii 1

Question

I need execute following sql in yii 1 application.

select user_group.user_id and user_rights.region_id 
from user_rights inner join user_group on
 user_rights.user_group_id=user_group.user_group_id

and to retrieve only all region_ids and paste it inside array? (e.g

                $regions = array();
                $regions[]='1';
                $regions[]='2';

) How can I do it using foreach(or another way) in yii 1?

Kumar Rakesh · Accepted Answer · 2017-01-25 07:56:21Z

1

Try with this query: you will get all region_id . You can use as your wish by foreach loop etc.

 Yii::app()->db->createCommand()
    ->select('user_rights.region_id')
    ->from('user_rights')
    ->join('user_group', 'user_rights.user_group_id=user_group.user_group_id')
    ->queryAll();

Also for creating query in Yii please read more here: DOCs

edited Jan 25, 2017 at 7:56

answered Jan 25, 2017 at 7:46

Kumar Rakesh

2,7082 gold badges20 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert sql result inside array in yii 1

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related