Select or Dropdown list from CActiveRecord in Yii

Question

I have table types and i want to build selectbox with all values from this table In my controller i wrote this code

$allRegistrationTypes = RegistrationType::model()->findAll();
$this->render('index', array('allRegistrationTypes' => $allRegistrationTypes))

How build selectbox in view file ?

selectbox means multiple selection from dropdownList? – Afnan Bashir Jul 04 '12 at 07:59 — Afnan Bashir, Jul 04 '12 at 07:59
@AfnanBashir no its simple dropdownlist – yAnTar Jul 04 '12 at 08:05 — yAnTar, Jul 04 '12 at 08:05

score 6 · Accepted Answer · answered Jul 04 '12 at 08:14

Well then its pretty simple all you need to do is first create List Data like

CHtml::ListData(allRegistrationTypes,'value you want to pass when item is selected','value you have to display');

for ex

typeList = CHtml::ListData(allRegistrationTypes,'id','type');

now remember both id and type are fields in table

now all you have to do is if you are using form then

<?php echo $form->dropDownList($model, 'type_id', $typeList, array('empty'=>'Select a tyoe')); ?>

and if you need multiple you can pass multiple => multiple in the array as htmlOptions

score 2 · Answer 2 · answered Jul 04 '12 at 08:00

You would use CHtml::dropDownList, or activeDropDownList if there is a "parent" model and you want to leverage its validation rules.

If you want to make the <select> element multiple-selection-capable, pass in 'multiple' => 'multiple' and 'size' => X as part of the $htmlOptions parameter.

score 1 · Answer 3 · edited Jul 24 '13 at 12:49

Simplest Method to get "Select Box" in YII Framework:

<div class="row">
    <?php
        echo $form->labelEx($model,'county');
        $data = CHtml::listData(County::model()->findAll(), 'id', 'county');
        $htmlOptions =     array('size' => '1', 'prompt'=>'-- select county --', );
        echo $form->listBox($model,'county', $data, $htmlOptions);
        echo $form->error($model,'county');
    ?>
</div>

Good Luck..

Select or Dropdown list from CActiveRecord in Yii

3 Answers3