why States are not getting populated?

why States are not getting populated?

Hi,

I am using the following code to populate states based on country select using the php and jquery but everytime I select a country nothing is happening and my state dropdown is still empty.

where is the problem please? Happy New Year :)

Html:
  1. <tr>
  2.     <td valign="middle">Country</td>
  3.     <td valign="middle">:</td>
  4.     <td valign="middle">
  5.         <select name="cboCountry" id="cboCountry" style="width: 100%" required>
  6.             <option value="">[Country..]</option>
  7.             <?php
  8.                 $mysql_command = "CALL sp_populate_country()";
  9.                 $mysql_query = $mysql_connection->prepare($mysql_command);

  11.                 $mysql_query->execute();

  13.                 while($mysql_row = $mysql_query->fetch())
  14.                 {
  15.             ?>
  16.             <option value="<?php echo $mysql_row['country_code_alpha2']; ?>" <?php if ($mysql_row['country_code_alpha2'] == $company_country) { echo 'selected'; } ?>><?php echo $mysql_row['country_name']; ?></option>
  17.             <?php } ?>
  18.         </select>
  19.     </td>
  20. </tr>
  21. <tr>
  22.     <td valign="middle">State / City</td>
  23.     <td valign="middle">:</td>
  24.     <td valign="middle">
  25.         <select name="cboRegion" id="cboRegion" style="width: 100%">
  26.             <option value="">[State / City..]</option>
  27.         </select>
  28.     </td>
  29. </tr>


JQuery:
  1. <script type="text/javascript">
  2. $("#cboCountry").change(function() {
  3.         // var country = $(this).find("option:selected").val();
  4.         // alert(country);
  5.         $.ajax({
  6.         url : "populate_region.php?id=" + $(this).val(),
  7.         type: 'GET',
  8.         dataType:'json',
  9.         cache: false,
  10.         success : function(data) {
  11.             if (data.success) {
  12.                 $("#cboRegion").html(data.options);
  13.             }
  14.             else {
  15.                 // Handle error
  16.             }
  17.         }
  18.     });
  19. });
  20. </script>



populate_region.php
  1. <?php
  2.     include('../includes/php_header.php');
  3.     include($_SESSION["absolute_path"] . '/includes/connect2db.php');

  5.     $country_code = $_GET['id'];
  6.     
  7.     if (!isset($country_code)) $reponse = array('success' => FALSE);
  8.     else
  9.     {
  10.         $mysql_command = "CALL sp_populate_region()";
  11.         $mysql_query = $mysql_connection->prepare($mysql_command);
  12.         $mysql_query->bindParam(':param_country_code', $country_code, PDO::PARAM_STR);

  14.         $mysql_query->execute();

  16.         while($mysql_row = $mysql_query->fetch())
  17.         {
  18.             $options .= '<option value="'. $mysql_row['region_id'] .'">'. $mysql_row['region_name'] .'</option>';
  19.         }

  21.         $response = array
  22.         (
  23.             'success' => TRUE,
  24.             'options' => $options
  25.         );

  27.         header('Content-Type: application/json');
  28.         echo json_encode($response);
  29.         
  30.         // include($_SESSION["absolute_path"] . '/includes/php_footer.php');
  31.     }
  32. ?>