php 实现 family tree,tree.php · jiehu0992/家谱familytree - Gitee.com

include("conn.php");//数据库连接

$array=array();

$sql=mysql_query("select * from tree_lr");

while ($row=mysql_fetch_array($sql)){

$array[]=$row; //查出数据保存到数组中

}

//后台左侧循环树形栏目

function lefttree(){

global $array; //设置全局变量

$tree = array();

$categorylist="";

if( $array ){

foreach ( $array as $v ){

//$pt = $v['pid'];

$pt = $v['pid'];

$list = @$tree[$pt] ? $tree[$pt] : array();

array_push( $list, $v );

$tree[$pt] = $list;

}

}

if(is_array($tree[0])){

$i = 0;

foreach($tree[0] as $k=>$v){

$i++;

if($tree[$v["id"]]){

$categorylist.="

".$v["name"]."\n字辈：".$v["zibei"]."，刘氏第".$v["dc"]."世代，妻子：".$v["wname"]."。平生简介：".$v["info"]."";

$categorylist.="

• \n";

$categorylist.=sonTree($tree[$v["id"]],$tree,0,$type);

$categorylist.="

\n";

$categorylist.="

\n";

}else{

if($v["is_link"]==0){

/*$categorylist.="

".$v["name"]." \n".$v["info"]."";*/

$categorylist.="

".$v["name"]."\n".$v["info"]."";

}

}

}

}

return $categorylist;

}

function sonTree($arr,$tree,$level,$type){

$level++;

$ii=0;

foreach($arr as $k2=>$v2){

$ii++;

if($tree[$v2["id"]]){

$categorylist.="

".$v2["name"]."\n";

$categorylist.="详细

• \n";

$categorylist.=sonTree($tree[$v2["id"]],$tree,$level,$type);

$categorylist.="

\n";

$categorylist.="

\n";

}else{

if($v["is_link"]==0){

/*$categorylist.="

".$v2["name"]."\n字辈： ".$v2["zibei"]."，刘氏第 ".$v2["dc"]."世代，妻子： ".$v2["wname"]."。平生简介：".$v2["info"]."";*/

$categorylist.="

".$v2["name"]."\n 详细";

}

}

}

return $categorylist;

}

$menu=lefttree();//调用函数

?>

一键复制

编辑

Web IDE

原始数据

按行查看

历史