Dependent Dropdown

Hi,

I'm having some troubles with the dependent dropdownlist, I found some code in this site so I adapted my code (you can see it below), once the first dropdownlist is selected, the second doesn't update...can anybody help me?, please.





Thanks... =)

_form.php

<div class="row">

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


<?php echo $form->dropDownList($model,'estado_id',CHTML::listData(ebeca_estados::model()->findAll(),


	'estado_id','estado'), 


	array('empty'=>'--please select--'), 


	array('ajax'=>array('type'=>'POST',


	                    'data'=>array('estado_id'=>'js.this.value'),


		  	    'url'=>CController::createURL('ebeca_municipios/getmunicipios'),


			    'update'=>'#estado_id',))); ?>


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

</div>

<div class="row">

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


<?php echo $form->dropDownList($model,'municipio_id',array()); ?>


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

</div>

_Ebeca_municipiosController

public function actionGetmunicipios()

{

$data=ebeca_municipios::model()->findAll('estado_id:=estado_id',


array(':estado_id'=>$_POST[estado_id]));


$data=CHTML::listData($data,'municipio_id','municipio');





foreach ($data as $value => $name) {


	echo CHTML::tag('option', 


	array('value'=>$name),CHTML::enconde($name),true);

}

There are indeed many tutorials around on this site. It is one of those simple things that until you understand it, can appear like its not working.

Here are some pointers;

[list=1][]if you have filters() and accessRules() defined in your controller make sure you also have ‘ajaxOnly + getmunicipios’ and ‘allow’=>‘getmunicipios’ set respectively.[]Check in firebug or chrome developer tool to see what response you are getting[]also remember that code in public function actionGetmunicipios() {…} will only work when actual ajax request is made.[]Because you are using cactiveform the line

'update'=>'#estado_id',))); ?>

should be something like

 'update'=>'#'.CHtml::activeId($model, 'municipio_id',))); ?>

// NOTE: I put ‘municipio_id’ rather than estado as I assume that is your target to update field[/list]

If you follow this wiki 24…I can assure you that it will work you.

If not, then I recommend you post the errors you are getting from both browser tool or app response. This way others may be able to shine the light to areas you need to pay attention

I only ask that you post your working solution back to the community once you have it working

Hi,

Thanks a lot for your answer, I read the link that you send me, and I realized that it was a lot of errors in the code that I post, buy finally it works, here is the code with all the corrections.





 Thanks and have a nice day =)

__form.php

      echo $form->labelEx($model,'estado_id'); 


	 	echo $form->dropDownList($model,'estado_id',CHtml::listData(ebeca_estados::model()->findAll(),


		'estado_id','estado'), 


					array(


						'empty'=>'--please select--',


						'ajax'=>array('type'=>'POST',


								'data'=>array('estado_id'=>'js:this.value'),


								'url'=>CController::createURL('ebeca_municipios/getmunicipios'),


								'update'=>'#municipio_id'))); 


		echo $form->error($model,'estado_id'); 





		echo $form->labelEx($model,'municipio_id');


		echo CHtml::dropDownList('municipio_id','',array(),array('prompt'=>'PleaseSelect'));


		echo $form->error($model,'municipio_id'); 

__ebeca_municipiosController

 public function actionGetmunicipios()


 {


	$data=ebeca_municipios::model()->findAll('estado_id=:estado_id', array(


								':estado_id'=>$_POST['estado_id']));


																					


	$data=CHtml::listData($data,'municipio_id','municipio');


	foreach ($data as $value=>$name) {


		echo CHtml::tag('option',array('value'=>$value),CHtml::encode($name),true);


	


	}						


 }

Good on you friend

hi seal;

i am using the dependent drop down list it’s working correctly during creation…

during the update process… first drop down list showing values . in second drop down list nothing available…

Thanks.

How about posting your controller and relevant views?

Dude. I just tried something like this…

Sorry. I’m on the rush and can’t comment the code. Check if you can understand by yourself.

<?php echo $form->textFieldRow($model, 'zipcode', array('class'=>'span5', 'maxlength'=>10)); ?>


<?php echo $form->textFieldRow($model, 'address', array('class'=>'span5', 'maxlength'=>255)); ?>


<?php echo $form->textFieldRow($model, 'number', array('class'=>'span5', 'maxlength'=>10)); ?>


<?php echo $form->textFieldRow($model, 'complement', array('class'=>'span5', 'maxlength'=>150)); ?>


<?php echo $form->textFieldRow($model, 'neighborhood', array('class'=>'span5', 'maxlength'=>100)); ?>


<?php if($model->isNewRecord): ?>


	<?php echo $form->dropDownListRow($model, 'country', CHtml::listData(Countries::model()->findAll(array('order'=>'name ASC')), 'id', 'name'), array('class'=>'span5', 'prompt'=>Yii::t('interface', 'Select one country'), 

		'ajax'=>array(

			'type'=>'GET',

			'url'=>$this->createUrl('suggestStates'), 

			'data'=>array('cid'=>'js:$(this).val()'), 

			'update'=>'#Properties_state',

			'afterAjaxUpdate'=>'js:$("#Properties_state").attr("disabled", false)', 

		))); ?>

			

	<?php echo $form->dropDownListRow($model, 'state', array(), array('class'=>'span5', 'disabled'=>'true', 'prompt'=>Yii::t('interface', 'Select one state'), 

		'ajax'=>array(

			'type'=>'GET', 

			'url'=>$this->createUrl('suggestCities'), 

			'data'=>array('cid'=>'js:$("#Properties_country").val()', 'sid'=>'js:$(this).val()'), 

			'update'=>'#Properties_city', 

			'afterAjaxUpdate'=>'js:$("#Properties_city").attr("disabled", false)', 

		))); ?>		

		

	<?php echo $form->dropDownListRow($model, 'city', array(), array('class'=>'span5', 'disabled'=>'true', 'prompt'=>Yii::t('interface', 'Select one city'))); ?>


<?php else: ?>


	<?php echo $form->dropDownListRow($model, 'country', CHtml::listData(Countries::model()->findAll(array('order'=>'name ASC')), 'id', 'name'), array('class'=>'span5', 'prompt'=>Yii::t('interface', 'Select one country'), 

		'ajax'=>array(

			'type'=>'GET',

			'url'=>$this->createUrl('suggestStates'), 

			'data'=>array('cid'=>'js:$(this).val()'), 

			'update'=>'#Properties_state',

			'afterAjaxUpdate'=>'js:$("#Properties_state").attr("disabled", false)', 

		))); ?>

		

	<?php echo $form->hiddenField($model, 'state', array('id'=>'state', 'name'=>'state')); ?>

			

	<?php echo $form->dropDownListRow($model, 'state', array(), array('class'=>'span5', 'disabled'=>'true', 'prompt'=>Yii::t('interface', 'Select one state'), 

		'ajax'=>array(

			'type'=>'GET', 

			'url'=>$this->createUrl('suggestCities'), 

			'data'=>array('cid'=>'js:$("#Properties_country").val()', 'sid'=>'js:$(this).val()'), 

			'update'=>'#Properties_city', 

			'afterAjaxUpdate'=>'js:$("#Properties_city").attr("disabled", false)', 

		))); ?>

		

	<?php echo $form->hiddenField($model, 'city', array('id'=>'city', 'name'=>'city')); ?>

		

	<?php echo $form->dropDownListRow($model, 'city', array(), array('class'=>'span5', 'disabled'=>'true', 'prompt'=>Yii::t('interface', 'Select one city'))); ?>

	

	<?php Yii::app()->clientScript->registerScript(uniqid(), "

		$(window).load(function(){

			$.ajax({

				type		:	'GET',

				url		:	'" . $this->createUrl('suggestStates') . "', 

				data		: 	{ cid: $('#Properties_country').val(), },

				success	:	function (data) { 

					$('#Properties_state').html(data);

					$('#Properties_state').val($('#state').val())

					$.ajax({

									type		:	'GET',

									url		:	'" . $this->createUrl('suggestCities') . "', 

									data		: 	{ cid: $('#Properties_country').val(), 'sid': $('#Properties_state').val() },

									success	:	function (data) { 

										$('#Properties_city').html(data);

										$('#Properties_city').val($('#city').val())

					},

					});

				},

				});

			$('#Properties_state').attr('disabled', false);

			$('#Properties_city').attr('disabled', false);

		});

	");

	?> 

	

<?php endif; ?>