How to convert array to string in yii 1

Question

I have following code in my controller in my yii 1application:

$recipientRegion=1710;
        $data= Yii::app()->db->createCommand()
            ->select('user_group_id')
            ->from('user_rights')
            ->where('region_id='.$recipientRegion)
            ->queryAll();

var_dump($data) returns following result:

array(2) { [0]=> array(1) { ["user_group_id"]=> string(1) "1" } [1]=> array(1) { ["user_group_id"]=> string(1) "3" } }

How can I convert this array result into string

Yupik · Accepted Answer · 2017-01-26 10:54:28Z

1

Simple display one per one:

foreach($data as $item) {
   echo $item['user_group_id'];
}

Fetch to one string (like @Ripper mentioned):

implode(',', array_column($data, 'user_group_id'));

It depends on what u want to do with this results. Please describe it so we can provide best solution.

answered Jan 26, 2017 at 10:54

Yupik

5,0291 gold badge15 silver badges27 bronze badges

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

Comments

Ripper · Accepted Answer · 2017-01-26 10:50:57Z

1

Just use implode combined with array_column as

imlpode(',', array_column($data, 'user_group_id'));

edited Jan 26, 2017 at 10:50

answered Jan 26, 2017 at 10:46

Ripper

1,16215 silver badges27 bronze badges

1 Comment

Yupik Over a year ago

implode() won't work here, cause it array of arrays.

Collectives™ on Stack Overflow

How to convert array to string in yii 1

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related