How to populate saved multiple values from junction table into dropdown in YII2?

Question

I got an error message, when i want to load back saved elements on update form.

Controller

$contentCategory = ContentCategory::find()
->where(['content_id' => $id])->all();

View

<?= $form->field($contentCategory, 'category_id')
->dropdownList(ArrayHelper::map(Category::find()->all(),'id','title'),
    ['prompt'=>'Select Category', 'multiple' => 'multiple']
)->label('Add categories'); ?>

The error message.

Call to a member function isAttributeRequired() on array

If i change the all() method to one() it's works but select only one element (of course).

Update: @scaisEdge I'm using a content_category junction table to insert relations contents with categories.

content_id  category_id
1           2
1           3

Model

public function rules()
{
    return [
        [['content_id', 'category_id'], 'integer'],
        [['category_id'], 'exist', 'skipOnError' => true, 'targetClass' => Category::className(), 'targetAttribute' => ['category_id' => 'id']],
        [['content_id'], 'exist', 'skipOnError' => true, 'targetClass' => Content::className(), 'targetAttribute' => ['content_id' => 'id']],
    ];
}

seems a validation message ..update your question and add your model validation rules code .. — ScaisEdge, Aug 04 '17 at 06:53

score 0 · Answer 1 · answered Aug 04 '17 at 09:42

0

The trouble in that you use $contentCategory array of founded models as form field model.

I think you should just change $contentCategory variable from your view on your certain model like $model = ContentCategory::findOne($id);

answered Aug 04 '17 at 09:42

Dmitry

242
1
9
20

score 0 · Answer 2 · answered Aug 04 '17 at 10:25

@Csaba Faragó

$arr = array();
$colorarr=array();
foreach ($detmodel as $key => $detailm){
//$detailm;
$id =  $detailm['productid'];
$sid =  $detailm['sizeid'];
$sidex= explode(",",$sid);
$i = 0;
foreach($sidex as $size_id)
{
$val = $sidex[$i];
$val = (int)$val;
array_push($arr, $val);
$i++;   
}

<?php  $sizelist = ArrayHelper::map(Size::find()->all(),'id','size');
        // $idd = '4';     
?>
<?php  
$detailm->sizeid =  $arr; 
// print_r($detailm->sizeid);
?>
<?=  $form->field($detailm, 'sizeid')->widget(Select2::classname(), [
'data' => $sizelist,
'language' => 'de',
'options' => ['placeholder' => 'Select sizes ...','multiple' => true],
'pluginOptions' => [
'tags' => true,
'tokenSeparators' => [',', ' '],
'maximumInputLength' => 10
],
]);  
?>

do all this in view page

Csaba Faragó · Accepted Answer · 2017-08-06T22:30:05.227

0

I have found a solution here. He is perfectly solve my issue.

edited Aug 06 '17 at 22:30

answered Aug 06 '17 at 21:18

Csaba Faragó

3
1
3

How to populate saved multiple values from junction table into dropdown in YII2?

3 Answers3