Need listbox with multiple selection - in yii

Question

I need listbox of multiple selection in yii, i have code of form area but its saving to database as a word "Array" in field, How to handle this problem?

how to get back while view and update and grid view also

<?php echo $form->dropDownList($model,'clients', 
  CHtml::listData(client::model()->findAll(array('order'=>'id')), 'id', 'name'),
     array('empty'=>'','multiple'=>'multiple','style'=>'width:400px;','size'=>'10'));
?>

Thank you.

It is being saved in the database as array because multiple select will return an array. Loop through the array to extract the values and then save them accordingly, either as multiple entries or as comma separated values — Orlymee, May 25 '12 at 11:04

score 3 · Answer 1 · answered Jan 18 '13 at 13:46

For me works this:

'multiple'=>true

Your code must be something like that:

<?php echo $form->dropDownList($model,'clients', 
  CHtml::listData(client::model()->findAll(array('order'=>'id')), 'id', 'name'),
     array('empty'=>'','multiple'=>true ,'style'=>'width:400px;','size'=>'10'));
?>

score 1 · Answer 2 · answered May 17 '13 at 08:43

1


$htmlOptions = array('size' => '5', 'multiple' => 'true','style'=>'width: 333px');

$model->field_id    =   array_of_data_to_be_selected

$form->listBox($model,'field_id',$listData, $htmlOptions);

answered May 17 '13 at 08:43

Anil Kumar

701
11
28

score 0 · Answer 3 · answered May 27 '12 at 15:49

If it is a relation you may want to use this : http://yiiext.github.com/activerecord-relation-behavior/ which takes care of saving array into many to many relation junction table.

Otherwise, like Orlymee said, you need to save each item of the array by looping through it or you can serialize the array or implode it into comma separated values and do the reverse of whatever method you chose to save, while viewing.

score 0 · Answer 4 · edited Jun 06 '12 at 06:54

0

keep this code in controller

$arr = implode(",",$model->attributes['hobbies']);

$model->hobbies=$arr;

in controler create,update in the first if condition

in database you can see the values with comma as delimiter

edited Jun 06 '12 at 06:54

Botz3000

39,020
8
103
127

answered Jun 06 '12 at 05:23

aruna

1

Thanks for your answers, My major problem is int he view/_form page, how i can re-select back while update. because all the values are separated by commas, i can explode it also no issue, but, i dont know how i can re-select automatically while update.. – bala Jun 13 '12 at 05:20

score 0 · Answer 5 · answered Dec 19 '14 at 11:53

How does this work in CHtml::listBox()

if(!empty($htmlOptions['multiple']))
{
    if(substr($name,-2)!=='[]')
        $name.='[]';
}

So you can try this

<?php echo $form->dropDownList($model,'clients', 
    CHtml::listData(client::model()->findAll(array('order'=>'id')), 'id', 'name'),
    array(
>>>     'name'=>CHtml::resolveName($model, 'clients').'[]',
        'empty'=>'',
        'multiple'=>'multiple',
        'style'=>'width:400px;',
        'size'=>'10',
    )
);?>

But it's better to use CHtml::listBox()

Need listbox with multiple selection - in yii

5 Answers5

Linked