三级联动

// JavaScript Document
$(document).ready(function(e) {
    
    var str = "<select id='sheng'></select><select id='shi'></select><select id='qu'></select>";
    
    $("#sanji").html(str);
    Fillsheng();
    Fillshi();
    Fillqu();
    $("#sheng").change(function(){
        Fillshi();
        Fillqu();
        })
    
    $("#shi").change(function(){
        Fillqu();
        })    
});    
    
    
    

function Fillsheng(){
    var pcode="0001";
    $.ajax({
        async:false,
        url:"sanchu.php",
        data:{pcode:pcode},
        type:"POST",
        dataType:"TEXT",
        success: function(data){
            var hang = data.split("|");
            var str = "";
            for(var i=0;i<hang.length;i++)
            {
                var lie = hang[i].split("^");
                str = str+"<option value='"+lie[0]+"'>"+lie[1]+"</option>";
            }    
                $("#sheng").html(str);    
            
            }        
        });
    
    
    }
function Fillshi(){
    
    var pcode = $("#sheng").val();
    $.ajax({
        async:false,
        url:"sanchu.php",
        data:{pcode:pcode},
        type:"POST",
        dataType:"TEXT",
        success: function(data){
            var hang = data.split("|");
            var str = "";
            for(var i=0;i<hang.length;i++)
            {
                var lie = hang[i].split("^");
                str = str+"<option value='"+lie[0]+"'>"+lie[1]+"</option>";
            }    
                $("#shi").html(str);    
            
            }        
        });
        }
function Fillqu(){
    
    var pcode = $("#shi").val();
    $.ajax({
        async:false,
        url:"sanchu.php",
        data:{pcode:pcode},
        type:"POST",
        dataType:"TEXT",
        success: function(data){
            var hang = data.split("|");
            var str = "";
            for(var i=0;i<hang.length;i++)
            {
                var lie = hang[i].split("^");
                str = str+"<option value='"+lie[0]+"'>"+lie[1]+"</option>";
            }    
                $("#qu").html(str);    
            
            }        
        });
        }
        

三级联动插件



<?php
$pcode = $_POST["pcode"];
include("DBDA.class.php");
$db=new DBDA();

$sql="select * from chinastates where parentareacode='{$pcode}'";


echo $db->StrQuery($sql);


?>





三级联动处理

 

posted @ 2016-11-13 16:17  刘冉  阅读(155)  评论(0编辑  收藏  举报