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

Ripper · Answer 1 · 2017-01-26T10:50:57.650

1

Just use implode combined with array_column as

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

edited Jan 26 '17 at 10:50

answered Jan 26 '17 at 10:46

Ripper

1,132
13
26

1

`implode()` won't work here, cause it array of arrays. – Yupik Jan 26 '17 at 10:49

score 1 · Accepted Answer · answered Jan 26 '17 at 10:54

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.

How to convert array to string in yii 1

2 Answers2