jQuery Grid Plugin - jqGrid - Topic: Dependent combo boxes http://www.trirand.com/blog/?page_id=393/help/dependent-combo-boxes Simple:Press Version 5.7.5.3 sebastiancb on Dependent combo boxes http://www.trirand.com/blog/?page_id=393/help/dependent-combo-boxes#p27456 Help http://www.trirand.com/blog/?page_id=393/help/dependent-combo-boxes#p27456 Hello, please what I need is to implement two dependent combobox in the jqgrid, but I have no idea, I have seen examples but I can`t get they work.

The first combobox loads the countries and depending of the country the second combobox loads the cities.

The source code:

index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Ejemplo</title>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery-ui.js"></script>
<script type="text/javascript" src="grid.locale-es.js"></script>
<script type="text/javascript" src="jquery.jqGrid.min.js"></script>
<link href="jquery-ui.css" rel="stylesheet" type="text/css" />
<link href="ui.jqgrid.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
$(document).ready(function(){
//--------------------------------------
function load_countries(){
var countries;
    $.ajax({
           url: 'load_countries.php',
           type: 'get',
           async: false,
           success: function(data){
            countries=data;        
           }
        });
    return countries;
}
//--------------------------------------
function load_cities(id){
var cities;
    $.ajax({
           url: 'load_cities.php?id_country='+id,
           type: 'get',
           async: false,
           success: function(data){
            cities=data;        
           }
        });
    return cities;
}

//--------------------------------------
$("#list3").jqGrid({ url:'list.php',
        datatype: "xml",
        colNames:['Id','name','country','city'],
        colModel:[
                {name:'idp',index:'idp', width:100,sortable:true,editable:true},
            {name:'name',index:'name', width:100,sortable:false,editable:true,sortable:true},
        {name:'namect',index:'namect', width:150,sortable:false,editable:true,sortable:true,edittype:'select',editoptions:{value:load_countries(),dataEvents:[{
               type:'change',
               fn:function(e){id_country=$(e.target).val();//get id country to load the cities in the following combobox with the function load_cities
                  //How to update the combobox namecy depending of the country
    
                             }
               }]}},
                {name:'namecy',index:'namecy', width:150,sortable:false,editable:true,sortable:true,edittype:'select'}],
                recreateForm:true,
        rowNum:10,
        rowList:[10,20,30],
        pager: '#pager3',
        sortname: 'idp',
        viewrecords: true,
        sortorder: "asc",
        xmlReader: {root: "rows",
                            repeatitems : true,
                           id: "[id]"                           
                          },
        caption: "Estudiantes",
        height:'100%',
        editurl:"edit.php"
});

//--------------------------------------
$("#list3").jqGrid('navGrid','#pager3',{edit:true,add:true,del:true,search:true});
//**********************************************************************************
});
</script>
</head>
<body>
 <table id="list3"></table>
 <div id="pager3"></div>
</body>
</html>


load_countries.php

<?php
$bd = mysql_connect("localhost","root","") or die("Connection Error: " . mysql_error());
mysql_select_db("depselect") or die("Error conecting to db.");
$id_country=$_GET['id_country'];
$sql="select id,namecy from cities where idc=$id_country";
$rs = mysql_query($sql);
$cities="";
while ($reg=mysql_fetch_array($rs)) {
$cities=$cities.$reg['id'].":".$reg['namecy'].";";
}

$cities=substr($cities,0,strlen($cities)-1);
echo utf8_encode($cities);
?>

load_cities.php

<?php
$bd = mysql_connect("localhost","root","") or die("Connection Error: " . mysql_error());
mysql_select_db("depselect") or die("Error conecting to db.");
$id_country=$_GET['id_country'];
$sql="select id,namecy from cities where idc=$id_country";
$rs = mysql_query($sql);
$cities="";
while ($reg=mysql_fetch_array($rs)) {
$cities=$cities.$reg['id'].":".$reg['namecy'].";";
}

$cities=substr($cities,0,strlen($cities)-1);
echo utf8_encode($cities);
?>

]]> Mon, 01 Oct 2012 22:36:30 +0300