Two DB Fields in One Dropwdown

Yii 1.1 General Discussion
1

Hi All,

I am new to Yii, and have used Yii for a couple of weeks :)

My question is how to show two database fields in one single dropdown.

Example :

In Model A, I usually use this


public function getBank()

{

  return CHtml::listData(Listbank::model()->findAll(), 'bankcode', 'bankname'); 

		 

}

and in my views, I usually write this




	<div class="row">

		<?php echo $form->labelEx($model,'bankcode'); ?>

		<?php echo $form->dropDownList($model,'bankcode', $model->getBank()); ?>

		<?php echo $form->error($model,'bankcode'); ?>

	</div>

So the dropdown will list for eg :




<select name="Identitaspekerja[bankcode]" id="Identitaspekerja_kodebankcode">

<option value="JKT">BANK MANDIRI</option>

<option value="YG">BANK MANDIRI</option>

</select>

What I need is like this :




<select name="Identitaspekerja[bankcode]" id="Identitaspekerja_kodebank">

<option value="JKT">JKT-BANK MANDIRI</option>

<option value="YG">YG-BANK MANDIRI</option>

</select>

I really appreciate your help.

Thank you

2

It’s simple. Add to you Listbank model this code:




public function getBankCodeWithName()

{

    return $this->bankcode.'-'.$this->bankname;

}

And change code in model A to:




public function getBank()

{

    return CHtml::listData(Listbank::model()->findAll(), 'bankcode', 'bankCodeWithName'); 

}
3

SOLVED !!

Thank you, I love Yii… and ofcourse its community :rolleyes: