Adding Dropdown List

Yii 1.1 General Discussion
1

can anybody help me how to create drop down list in yii all view files?

2

Hi


<?CHtml::dropDownList($model,'coupon_id', CHtml::listData(Coupon::model()->findAll("user_id=$model->user_id"),'id','title')); ?>
3

i have to fetch distinct of data from database

4

Tiny correction; you’ll need to use <?= or <? echo to output the drop down list.

5

where i need to add this code? i am new to yii…, plz help me

6

in your view file

7

i hacve added in view/dataform.php like

<div class="row">

	&lt;?php echo &#036;form-&gt;labelEx(&#036;model,'tier'); ?&gt;


	&lt;?php echo CHtml::dropDownList(&#036;model,'tier', CHtml::listData(Coupon::model()-&gt;findAll(&quot;tier=&#036;model-&gt;tier&quot;),'AssetID','title')); ?&gt;


	&#60;&#33;--&lt;?php echo &#036;form-&gt;;dropDownList(&#036;model,'tier', CHtml::listData(Tier::model()-&gt;findAll(), 'AssetID', 'tier'), array('empty'=&gt;;'--please select--')); ?&gt;--&#62;


	&lt;?php echo &#036;form-&gt;error(&#036;model,'tier'); ?&gt;


&lt;/div&gt;

still getting text box only…, do i need to add extra code in datacontroller.php??in actionCreate()

8

You should be using the $form->dropDownList() method in your case. Why do you have a $form->dropDownList() call commented out in your HTML, along with random semicolons?

9

plz explain in detail

10

try this


	


$list =  CHtml::listData(ModelName::model()->findAll(array('group'=>'field u  want to be distinct')), 'save_field', 'display_field');


$form=$this->beginWidget('CActiveForm');


echo $form->dropDownList($model,'save_field', $list); 


$this->endWidget();

Model will b Ur Model Name from which U want to Fetch Data

save_field is that field which u want to save value of

display_field is that field to display to User in dropdown