Use js jquery to achieve infinite linkage_jquery

今天工作需要写树形的联动，于是写了个可扩展的无限极联动下拉选项
代码写的比较凌乱 先mark有空再整理

随便截个图！
先贴数据库

id	category_name 分类名	pid 父分类id	orders 排序
1	22223331	0	1
2	2222111	1	1
12	44444	11	0
5	2222	1	1
6	2222	1	1
11	333	2	0
13	555555	12	0

SMARTY used for page code

Copy code The code is as follows:

 
  Please select Category
                                                                                                      category_name}
                                                                         The PHP code to remove data is



Copy code

The code is as follows: $sql = " select * from yl_gallery_category where pid = 0"; $galleryCategory = $db->query($sql); $smarty->assign("galleryCategory",$galleryCategory);

The original code used is relatively easy to understand
Then there is the key JS code function change(val) {

Copy code

The code is as follows:

var str = val; //select id
var num; //current level
var id; //category id
num = str.substr(9,10) ;
//alert(num);
var nownum = parseInt(num) 1; // Convert string to number
id = $("#" str "").val();
var r = /^[1-9] [0-9]*]*$/; //Positive integer
if (!r.test(id)) {
//Clear out-of-date Options
           $("select")                                                                                                                                            } )

return false;
}
var url = 'gallery.php?act=category&pid=' id;
$.ajax({
type: "POST",
cache: false,
url: url,
datatype: 'json',
timeout: 3000,
success: function(result){
if ( result != 0) {
            var html = "

"; Classification";
var datas = eval(result);
$.each(datas, function(i,val){                   value='" val. id "' >" val.category_name "";
                                                              Empty outdated options
              $("select")                                                                                                                                     }
})

                     $("#select"                                                                                                                                            ; 🎜>                                                                                                           ​ })　　　}

},
error: false
});

}


AJAX data retrieval PHP code




Copy code


The code is as follows:

$sql = " select * from yl_gallery_category where pid = " .$pid;
    $res = $db->query($sql);
    if (empty($res)) {
        $res = 0;
    }
    echo json_encode($res);

OK 大功告成！