[parmesh]

for this
i have two tables one is registaration having many columns.
and second table is citylist in which there are only three columns city_id,city_name,state name

and i want to popualte dropdown for city list by getting state name from table and insert into
first table i.e registration


this is my view.php
<div class="row">
<?php echo $form->labelEx($model,'State'); ?>
<?php
$list=CHtml::listData(tblcitylist::model()->findAll(),'state','state');
echo CHtml::activeDropDownList('prjid','', $list,
array(
'empty'=>'Please Select',
'ajax' => array(
'type'=>'POST', //request type
'url'=>CController::createUrl('Registrationd/dynamiccity'), //url to call.
'update'=>'#prjid', //selector to update
'data'=>'js:$(this).serialize()',

)));
?>
<?php echo $form->error($model,'State'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'City'); ?>
<?php
//empty since it will be filled by the other dropdown
echo CHtml::activeDropDownList('prjid','', array(),array('empty'=>'Select','style'=>'width:120px;'));
//echo CHtml::activeDropDownList($model,'city_id', array(),array('prjid'=>'city_id'));
// echo CHtml::activeHiddenField($model,'city_id');
?>
<?php echo $form->error($model,'City'); ?>
</div>



and then in controller.php
public function actiondynamiccity()
{
$data=Lab::model()->findAllBySql('select city_name from tblcitylist where state='.$_POST['state']);
$data=CHtml::listData($data,'prjid','city_name');
foreach($data as $value=>$name)
{
echo CHtml::tag('option',
array('value'=>$value),CHtml::encode($name),true);
}

}

[Rajith R]

use 2nd like this, give that id to it..

echo CHtml::activeDropDownList($model,'batch_id',$data1,array('prompt'=>'Select','id'=>'batch_id'));



use another id to 2nd dropdown
'update'=>'#batch_id'

[Rajith R]

echo CHtml::activeDropDownList($model,'city_id', array(),array('id'=>'city_id'));


and update 'city_id'

[parmesh]

Rajith R, on 11 June 2012 - 08:25 AM, said:

use 2nd like this, give that id to it..

echo CHtml::activeDropDownList($model,'batch_id',$data1,array('prompt'=>'Select','id'=>'batch_id'));



use another id to 2nd dropdown
'update'=>'#batch_id'

if possible please send me modified code,
i am not getting you....
actually i am trying to populate both state and city drop down list from same table.

[ehochedez]

Hi,

don't forget to use the code snippet tool when you insert code in your forum post, otherwise it's not easy to read your code.
You should have a look at this if you haven't yet, there are complete examples:

http://www.yiiframework.com/wiki/24/

Hope it helps.