Country/State Dropdown in CakePHP

Question

How do i deal with dependent combo boxes in the views with the form helper. For example:

Country Select Box (Choosing a country shall filter out the states of the selected country) States Select Box

This should happen with the help of Javascript / Jquery etc. I came across an example for the same with Cake's core AJAX helper but it would be very nice if someone can help with a Javascript example.

Thanks

Answer 1

In views/ edit.ctp

<script type="text/javascript">
document.ready(function (){
 $('#country').change(function() {
   $('#state').load('/controller/getStates/'+$(this).val());
 });
});
</script>
<select id="country" name="country">
<option value="1">Greece</option>
</select>

<span id="state">
<select name="state">
<option value=""></option>
</select>
</span>

and in controller.php

function getStates(int countryID){
  $this->set('selectbox',
    $this->State->find('list',array('conditions'=>'State.Country_id='.$countryID,
      'fields;=>array('description')));
}

and views/getStates.ctp

<select name="state">
<option value=""></option>

<?php 
foreach($selectbox as $option) 
  echo '<option value="'.$option['id'].'">'.$option['description'].'</option>'."\n";
?>
</select>

I hope I don't forget something