ztree php应用实例,zTree_v3无限分类操作案例

/**

* Created by 小雨在线

* User: 飛天

* Date: 2017/6/11 0011

* Time: 10:33

*/

?>

zTree_v3操作案例

function zTreeOnClick(event, treeId, treeNode) {

//alert(treeNode.tId + ", " + treeNode.name);

console.log(treeNode);

console.log(treeNode.pId);

console.log(treeNode.id);

console.log(treeNode.name);

//alert(treeId);

};

var setting = {

data: {

simpleData: {

enable: true

}

},

callback: {

onClick: zTreeOnClick

}

};

$(document).ready(function () {

//ajax提交数据，请求后台PHP处理返回出目录结构json数据

$.ajax({

url: "./test2.php",

type: "get",

async: false,

dataType: "json",

success: function (data) {

zNodes = data; //将请求返回的数据存起来

//alert(zNodes);

},

error: function () {//请求失败处理函数

alert('请求失败');

}

});

var tree = $.fn.zTree.init($("#treeDemo"), setting, zNodes);

tree.expandALL(true);//默认展开

});

/**

* Created by 小雨在线

* User: 飛天

* Date: 2017/6/11 0011

* Time: 10:42

*/

define("HOST", "xxx"); //主机名

define("USER", "aa"); //账号

define("PASS", "bb"); //密码

define("DBNAME", "cc"); //数据库名

$conn = new mysqli(HOST, USER, PASS);

$conn->select_db(DBNAME);

$sql = "SELECT id,pid AS pId,catename AS name FROM wuxianfenlei_deepcate ORDER BY id DESC";

$result = $conn->query($sql);

$data1 = [];

while ($row = $result->fetch_assoc()) {

$data1[] = $row;

}

echo json_encode($data1);

前台操作事例：