Dropdownlist

vaibhavjha · August 23, 2012, 8:37pm

Issue, I have an array with a list of cities. However, after I sort it and display it in the dropdownlist and click submit. My city column in the database gets populated with index of the array i.e 0 or 1 or 2. Even though in the form dropdownlist I see London, New Jersey or Chicago. I would like to save the city name in my database and not the index.

Could you suggest how I could do this by referring to the code below.

This the _form.php code

&lt;div class=&quot;row&quot;&gt;


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


	&lt;?php echo &#036;form-&gt;dropDownList(&#036;model,'city',&#036;model-&gt;getCityOptions()); ?&gt;


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


&lt;/div&gt;

This is Model code

public function getCityOptions()

{


	&#036;list=array('New Jersey','Chicago','London',);


 	asort(&#036;list);


 return &#036;list;


}

seenivasan · August 23, 2012, 9:09pm

Dear Friend,

Array values are displayed and array keys are stored.

Try this.




public function getCityOptions()

{

   $list=array('New Jersey'=>'New Jersey','Chicago'=>'Chicago','London'=>'London',);

   asort($list);

   return $list;

}

vaibhavjha · August 23, 2012, 9:19pm

Thanks! nice hack

seenivasan:

Dear Friend,

Array values are displayed and array keys are stored.

Try this.




public function getCityOptions()

{

   $list=array('New Jersey'=>'New Jersey','Chicago'=>'Chicago','London'=>'London',);

   asort($list);

   return $list;

}