0)
{
foreach ($array as $k => $arr)
{
removeKey($array[$k], $key);
}
}
}
}
$hostName = "localhost";
$username = "root";
$password = "loskyoc";
$dbname = "newskybni";
$level='' ;
//$levelnow='' ;
$dblink = mysqli_connect($hostName, $username, $password, $dbname) or die(mysqli_error());
$id =1;
$chkid=1;
$parentKey = isset($_GET['id'])?$_GET['id']:1 ;//$_SESSION['login_addr'];
//$parentKey = isset($_GET['id'])?$_GET['id']:1 ;//$_SESSION['login_addr'];
$showrefer=true;
//if($parentKey==1){ $showrefer=true;}
$sql = "SELECT * FROM usertree" ;
//$data=array();
$result = mysqli_query($dblink, $sql);
if(mysqli_num_rows($result) > 0)
{
$data = membersTree($parentKey,$id);
}else{
$data='["id"=>"0","name"=>"No Members present in list","text"=>"No Members is present in list","nodes"=>[]]';
// $data='["name"=>"No Members present in list"]';
}
function membersTree($parentKey,$ppid)
{
$hostName = "localhost";
$username = "root";
$password = "loskyoc";
$dbname = "newskybni";
$dblink = mysqli_connect($hostName, $username, $password, $dbname) or die(mysqli_error());
global $chkid;
global $showrefer ;
global $level;
$setmaxleve=3;
$levelnow='';
$row1=array();
if($chkid==1){
$sql = 'SELECT id, name,parentid from usertree WHERE id="'.$parentKey.'"';
} else{
$sql = 'SELECT id, name,parentid from usertree WHERE parentid="'.$parentKey.'"';
}
$chkid++;
$result = mysqli_query($dblink, $sql);
$totalRows = mysqli_num_rows($result);
if($totalRows>0){
if ($chkid>2){
$level .= $parentKey.',' ;
// echo "lll > ".$parentKey."
";//$parentKey;//$parentKey
// echo "l > ".$level."==p>".$parentKey.'==id>'.$id."
";//$parentKey
$a=explode(',',$level);
$c=-1;
$level2='';
for($i=0;$i ".$id."<==>".$a[$i]."
" ;
if ($c<0){ $level2.= $a[$i].','; }
if( $ppid==$a[$i]) {
$c=$i;
$level2.= $parentKey.',';
// echo " FFFFFFF > ".$c." add :".$parentKey ."
";//$parentKey;//$parentKey
// echo " ref > ".$level2."==p>".$parentKey.'==id>'.$id."
";//$parentKey
break;
}
}
$level=$level2;
$levelnow=$level2;
// echo " ref2 > ".$level."==p>".$parentKey.'==id>'.$id."
";//$parentKey
}
$a1=explode(",",$levelnow);
while($value = mysqli_fetch_assoc($result)){
$id = $value['id'] ;//$value['id'];
$row1[$id]['id'] = $value['id'];
if($showrefer){ $row1[$id]['name'] = $value['id'].$value['name'] ;} //.'-'.$levelnow ;
else{ $row1[$id]['name'] = $value['name']; }
$row1[$id]['parentid'] = $value['parentid'];
if($setmaxleve>count($a1)){
$sql2 = sprintf("SELECT id from usertree WHERE parentid='%s' ",$value['id']);
$result2 = mysqli_query($dblink, $sql2);
$totalRows2 = mysqli_num_rows($result2);
$tag =$totalRows2 ;
if($tag >0){
$row1[$id]['children'] = array_values(membersTree($value['id'],$value['parentid']));
} // end $tag
} //end max count children
} // end while
} // end $totalRows>0
return $row1 ;
mysqli_close($dblink);
} // end function
removeKey($data, 'id');
removeKey($data, 'parentid');
$str1 = json_encode(array_values($data));
$str1 =mb_substr($str1,1,-1);
echo $str1;
mysqli_close($dblink);
?>