An Easy Solution for Dependent dropDownList Using AJAX

Yii Framework Wiki

Popular Tags

An Easy Solution for Dependent dropDownList Using AJAX

You are viewing revision #8 of this wiki article.
This is the latest version of this article.
You may want to see the changes made in this revision.
« previous (#7)

Sometimes new Yii guys face problem to manage dependent dropDownList using AJAX. I am going to discuss an easy solution about this issue.

Example code:

Code in View-

<?php									
  echo CHtml::dropDownList('region_id','', 
  array(2=>'New England',1=>'Middle Atlantic',3=>'East North Central'),

  array(
    'prompt'=>'Select Region',
    'ajax' => array(
    'type'=>'POST', 
    'url'=>Yii::app()->createUrl('YourController/loadcities'), //or $this->createUrl('loadcities') if '$this' extends CController
    'update'=>'#city_name', //or 'success' => 'function(data){...handle the data in the way you want...}',
  'data'=>array('region_id'=>'js:this.value'),
  ))); 
									 
								
 
echo CHtml::dropDownList('city_name','', array(), array('prompt'=>'Select City'));
?>

Code in Controller-

public function actionLoadcities()
{
   $data=RegionCity::model()->findAll('region_id=:region_id', 
   array(':region_id'=>(int) $_POST['region_id']));
	 
   $data=CHtml::listData($data,'id','city_name');
		
   echo "<option value=''>Select City</option>";
   foreach($data as $value=>$city_name)
   echo CHtml::tag('option', array('value'=>$value),CHtml::encode($city_name),true);
}

I think this will help to understand actually how AJAX works in Yii for dependent dropDownList also AJAX working behavior in Yii framework.

--Enjoy, Explore... Yii

7 1

24 followers

Viewed: 102 862 times

Version: Unknown (update)

Category: Tips

Tags: AJAX, drop down list

Written by: mrs

Last updated by: Kostas Apazidis (KonApaz)

Created on: Dec 9, 2012

Last updated: 10 years ago

Update Article

Revisions

View all history

10 years ago by Kostas Apazidis (KonApaz)
alternative handle of received data
10 years ago by Kostas Apazidis (KonApaz)
#
11 years ago by mrs
Text
11 years ago by mrs
Text

User Contributed Notes 11

#11966

0 0

thank

nice tutorial

kevindng at Feb 16, 2013, 7:23:38 AM

#12158

0 0

thanks

It is working fine for display part, I was able to get the first down values using $model but how to save dependent drop down value to $model?

venuk at Mar 2, 2013, 12:28:29 PM

#12221

0 0

Dependent drop down

I've three drop down.

Provinces (Hard-codded values)
Districts (Filling the drop down using Ajax, working perfect)
View Part for the Districts:

<div class="row">
		<?php echo $form->labelEx($model,'inst_province'); ?>
	        <?php
                echo CHtml::dropDownList('inst_province','', 
                array(1=>'A',2=>'B',3=>'C', 4=>'D'),
                array(
                  'prompt'=>'Select Province',
                  'ajax' => array(
                  'type'=>'POST',
                  'url'=>CController::createUrl('loaddistricts'),
                  'update'=>'#inst_distt', 
                  'data'=>array('inst_province'=>'js:this.value'),
                )));
              ?>
        <span class="help-inline"><?php echo $form->error($model,'inst_province'); ?></span>            
    </div>

Tehsils (Problem here, as AJAX does not work here, may be the District drop down ID is not passing) here is the View part

<div class="row">
<?php echo $form->labelEx($model,'inst_distt'); ?>
<?php echo CHtml::dropDownList('inst_distt','', array(), array('prompt'=>'Select Option'),
                        array(
                        'ajax' => array(
                                    'type'=>'POST', 
                                    'url'=>CController::createUrl('loadtehsils'),
                                    'update'=>'#inst_tehsil', 
                                    'data'=>array('inst_distt'=>'js:this.value'),
                        )));?>
<span class="help-inline"><?php echo $form->error($model,'inst_distt'); ?></span>

</div>

Any advice?

Adil Shahzad at Mar 7, 2013, 1:07:09 PM

#12370

0 0

getting error undefined index : region_id

i used the same coding as given above, im getting error undefined index : region_id, help needed

rkrram37 at Mar 16, 2013, 12:31:37 PM

#13162

0 0

parent dropdownlist from model

hi,
this is the independant dropdown list case, is there an article for dropdownlist from model which get the parent and the child values from the parent?

i need a detailed example, i am new in using yii

thank you

freshyiiuser at May 9, 2013, 8:31:19 PM

#13335

1 0

Not saving values to db

Did you ever figure out what the problem was from Your own comment on the orginal topic / tip.. This is the same exact thing aka repost with no solution.

skworden at May 22, 2013, 6:15:57 PM

#14371

0 0

data is coming in database

nice tutorial... its work for me...

but data is not inserting inside database (only country_id and all, rest all are going inside database).

kalpit at Aug 7, 2013, 6:43:52 AM

#14709

0 0

cascade Dropdown list one child depend upon multiple perent

this example is applicable in case of one child depends upon multiple parent?

i have cycle, type and behavior, to select the behavior i have to select the cycle and the type.

can anyone help me in this? i didnt find such issue in the forum

thank you

freshyiiuser at Sep 5, 2013, 7:48:56 AM

#14740

0 0

Gracias

Fue de mucha ayuda!

lisseth23 at Sep 6, 2013, 7:42:40 PM

#15612

1 0

400 The CSRF token could not be verified

Wondering about the error Yii Error 400 The CSRF token could not be verified...

After some research it turned out that I had to change

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

into

'data' => array('region_id' => 'js:this.value', 'YII_CSRF_TOKEN' => Yii::app()->request->csrfToken),

banago at Nov 28, 2013, 11:25:32 AM

#19840

0 0

Resolve

@Adil Shahzad
<?php echo $form->error($model,'inst_distt'); ?>
change the class in there to id e.g
<?php echo $form->error($model,'inst_distt'); ?>

ASODAD at Apr 25, 2016, 5:17:27 PM

Categories

Popular Tags

Recent Comments

An Easy Solution for Dependent dropDownList Using AJAX

Revisions

Related Articles