非常简单的解决方案,使用PHP打印出ID和所有最后一个子节点的路径,因为我不知道在MysqL中这样做的方法。希望这可以帮助!
function getChildren($parent= "", $x = 0) {
$sql = "SELECT id, name FROM recurr WHERE parentId = $x";
$rs = MysqL_query($sql);
//echo "Name: $parent has ". MysqL_num_rows($rs)." children<br/>";
while ($obj = MysqL_fetch_object($rs)) {
if (hasChildren($obj->id)) {
getChildren($parent."/".$obj->name, $obj->id);
} else {
echo $obj->id .", ".$parent."/".$obj->name."<br/>";
}
}
}
function hasChildren($x) {
$sql = "SELECT * FROM recurr WHERE parentId = $x";
$rs = MysqL_query($sql);
if (MysqL_num_rows($rs) > 0) {
return true;
} else {
return false;
}
}
要运行,只需致电:
getChildren();