0)
{
foreach ($array as $k => $arr)
{
removeKey($array[$k], $key);
}
}
}
}
$hostName = "localhost";
$username = "root";
$password = "loskyoc";
$dbname = "newskybni";
$dblink = mysqli_connect($hostName, $username, $password, $dbname) or die(mysqli_error());
$menustring='';
$id =1;
$chkid=0;
$parentKey = 0;// isset($_GET['id'])?$_GET['id']:0 ;//$_SESSION['login_addr'];
//$parentKey = isset($_GET['id'])?$_GET['id']:1 ;//$_SESSION['login_addr'];
$showrefer=true;
//if($parentKey==1){ $showrefer=true;}
$act=isset($_GET['act'])?$_GET['act']:"showicon";
$sql = sprintf("SELECT * FROM `mtree` WHERE slink='%s' ",$act);
$result2 = mysqli_query($dblink, $sql);
$value2 = mysqli_fetch_assoc($result2);
$totalRows = mysqli_num_rows($result2);
$actid=0;
$actspid=0;
if($totalRows>0){
$actid=$value2['id'];
$actspid=$value2['spid'];
}
//$data=array();
//$result = mysqli_query($dblink, $sql);
$data = membersTree($parentKey);
function membersTree($parentKey)
{
$hostName = "localhost";
$username = "root";
$password = "loskyoc";
$dbname = "newskybni";
$dblink = mysqli_connect($hostName, $username, $password, $dbname) or die(mysqli_error());
//mysql_query("SET NAMES UTF8");
mysqli_query($dblink,"SET NAMES UTF8");
global $chkid;
global $showrefer ;
global $menustring;
global $actid;
global $actspid;
$row1=array();
$sql = sprintf("SELECT id, title,slink,spid from mtree WHERE fck='Y' AND spid='%s' order by idx asc",$parentKey);
$chkid++;
$result = mysqli_query($dblink, $sql);
$totalRows = mysqli_num_rows($result);
$chkid_b=$chkid;
if($totalRows>0){
if($chkid_b>1){ $menustring .='';}
while($value = mysqli_fetch_assoc($result)){
// class="active opened active" class="active"
$s1='';
if($value['id']==$actid){ $s1='class="active"'; }
else if($value['id']==$actspid){ $s1='class="active opened active"'; }
$menustring .='- ' ;
$icon=($chkid_b==1)?'class="linecons-cog"':'';
$link=($value['slink']=='')?'#':'main.php?act='.$value['slink'];
$menustring .=' '.$value['title'].'';
$id = $value['id'] ;//$value['id'];
$row1[$id]['id'] = $value['id'];
if($showrefer){ $row1[$id]['title'] = $value['title'].','.$value['spid'].','.$value['id'] ;}
else{ $row1[$id]['title'] = $value['title']; }
$row1[$id]['spid'] = $value['spid'];
//$row1[$id]['tag'] = count(membersTree($value['id']));
// $tag = count(membersTree($value['id']));
$sql2 = sprintf("SELECT id from mtree WHERE fck='Y' AND spid='%s' ",$value['id']);
$result2 = mysqli_query($dblink, $sql2);
$totalRows2 = mysqli_num_rows($result2);
$tag =$totalRows2 ;
// if($row1[$id]['tag'] >0){
if($tag >0){
$row1[$id]['children'] = array_values(membersTree($value['id']));
}
}
$menustring .='
';
}
if($chkid_b>1){ $menustring .='
';}
return $row1 ;
mysqli_close($dblink);
}
// class="active opened active" class="active"
// removeKey($data, 'id');
// removeKey($data, 'ref');
// $str1 = json_encode(array_values($data));
// $str1 =mb_substr($str1,1,-1);
//echo $str1;
//echo $menustring;
mysqli_close($dblink);
?>
