表名:province 结构如下
CallIn.tpl 模板页
<select id="consult_province" name="consult_province" class="easyui-combobox" style="width:200px;"><{$json_province}></select></td> <input id="consult_city" name="consult_city" class="easyui-combobox" data-options="valueField:'id',textField:'text'" style="width:200px;" >
<script type="text/javascript"> //省份 下拉菜单 联动 城市 $("#consult_province").combobox({ onChange: function (n,o) { //alert('223323'); var selected_item=$('#consult_province').combobox('getValue');//省份 //alert(selected_item); /* var data, json; json='[{"id":1 , "text":"兰州" },{"id":14 ,"text":"敦煌" ,"selected":true},{"id":15 , "text":"临夏"}]'; data = $.parseJSON(json); $("#consult_city").combobox("loadData", data); */ $.ajax({ type: "POST", url: "Ajax-index.php?module=<{$module_name}>&action=Ajax_Province_Change", dataType: "json", data: {"data_item":selected_item }, beforeSend: function(){ //$('<div id="msg" />').addClass("loading").html("加载中...").css("color","#999").appendTo('.sub1'); }, success: function(json){ if(json.success==1){ //alert(json.msg); //$("#consult_city option[value!=0]").remove(); //导入批号 var data = $.parseJSON(json.msg); $("#consult_city").combobox("loadData", data); }else{ $.messager.alert('消息','数据加载失败!','error'); return false; } } }); } }); </script>
CallIn.php
//省份 智能提示-------------------------------------------------------------------------- $option='<option value="0"></option>'; $strSql="SELECT distinct name FROM province where deleted=0 order by date_entered asc"; $result_rows=$db->query($strSql); while($row=mysql_fetch_array($result_rows)){ //echo($row[0]); $option.='<option value="'.$row[0] .'">'. $row[0] .'</option>'; } $smarty->assign('json_province', $option);
Ajax_Province_Change.php
$province = stripslashes(trim($_POST['data_item'])); $select=" SELECT city_name "; $select.=" FROM province WHERE deleted=0 and name='" . $province . "' "; $result=$db->query($select); $Select_Option="[";// $i=1; while($row=$db->fetch_array($result)){ $value=$row[0]; if($i==1){ $Select_Option=$Select_Option . '{"id":"' .$value. '" , "text":"' . $value .'","selected":true },'; } else{ $Select_Option=$Select_Option . '{"id":"' .$value. '" , "text":"' . $value .'" },'; } $i=$i+1; } $Select_Option = substr($Select_Option,0,-1); $Select_Option=$Select_Option . ']'; $arr['success'] = 1; $arr['msg'] = $Select_Option; echo json_encode($arr);