<?php
$parent_menu = array();
$sub_menu = array();
$items=$pdo->prepare("SELECT id,label,ziel,parent_id FROM test_menu ORDER BY parent_id,id ASC");
$items->execute();
while ($obj=$items->fetchObject())
{
if ($obj->parent_id == 0)
{
$parent_menu[$obj->id]['label']=$obj->label;
$parent_menu[$obj->id]['link']=$obj->ziel;
}
else
{
$sub_menu[$obj->id]['parent']=$obj->parent_id;
$sub_menu[$obj->id]['label']=$obj->label;
$sub_menu[$obj->id]['link']=$obj->ziel;
if (empty($parent_menu[$obj->parent_id]['count']))
{
$parent_menu[$obj->parent_id]['count']=0;
}
$parent_menu[$obj->parent_id]['count']++;
}
}
function test_menu($parent_array,$sub_array,$qs_val="pid")
{
$page=isset($_GET['page']) ? $_GET['page'] : '';
$menu = "";
foreach($parent_array as $pkey=>$pval)
{
if (!empty($pval['count']))
{
if (($page)==$pval["link"])
{
$menu.='<ul><li>'.$pval['label'].'</li></ul>';
}
else
$menu.='<ul><li>
<a href="index.php?page='.$pval['link'].'&'.$qs_val.'='.$pkey.'">'.$pval['label'].'</a>
</li></ul>';
}
else
{
if (($page) == $pval["link"])
{
$menu.='<li>'.$pval['label'].'</li>';
}
else
$menu.='<li><a href="index.php?page='.$pval['link'].'">'.$pval['label'].'</a></li>';
}
if (!empty($_REQUEST[$qs_val]))
{
$menu.='<ul>';
foreach($sub_array as $sval)
{
if ($pkey == $_REQUEST[$qs_val] && $pkey == $sval['parent'])
{
if (($page) == $sval["link"])
{
$menu.= '<li class="raus">'.$sval['label'].'</li>';
}
else
$menu.='<ul><li class="raus"><a href="index.php?page='.rebuild_link($sval['link'], $qs_val, $sval['parent']).'">'.$sval['label'].'</a></li></ul>';
}
}
$menu.='</ul>';
}
}
return $menu;
}
function rebuild_link($link, $parent_var, $parent_val)
{
$link_parts=explode("&", $link);
$base_var="&".$parent_var."=".$parent_val;
return $link_parts[0].$base_var;
}
echo test_menu($parent_menu, $sub_menu);
?>

<?php
if(!isset($_SESSION))
{
session_start();
}
if(!isset($_SESSION["loggedin"]))
{
$stmt=$pdo->prepare("SELECT labbel,ziele FROM log_menu");
$stmt->bindColumn(1,$labbel);
$stmt->bindColumn(2,$ziele);
$stmt->execute();
echo'<ul class="liner">';
while($stmt->fetch())
{
if(($page)==$ziele)
{
echo'<li>'.$labbel.'</li>';
}
else
{
echo'<li><a href="index.php?page='.$ziele.'">'.$labbel.'</a></li>';
}
}
echo'</ul>';
}
else
{
echo'<div id="user">';
echo'<div class="hallo">
Hallo <span>'.htmlspecialchars($_SESSION["username"]).'</span>
</div>';
echo'<ul class="liner">';
?>

<?php
if (isset($_SESSION["id"]) && $_SESSION["id"]==1)
{
if(($page)=="99")
{
echo'<li>Admin-Center</li>';
}
else
{
echo'<li><a href="index.php?page=99">Admin-Center</a></li>';
}
}
if(isset($_SESSION['loggedin']))
{
if(($page)=="96")
{
echo'<li>Profil</li>';
}
else
{
echo'<li><a href="index.php?page=96">Profil</a></li>';
}
if(($page)=="98")
{
echo'<li>Logout</li>';
}
else
{
echo'<li><a href="index.php?page=98">Logout</a></li>';
}
}
echo'</ul>';
echo'</div>';
}
?>

<?php
if(file_exists('admin/conf_ing.php') == true)
{
require('admin/conf_ing.php');
}
if(file_exists('header.php') == true)
{
require('header.php');
}
echo'<nav>';
if(file_exists('menue.php') == true)
{
require('menue.php');
}
echo'</nav>';
echo'<main>';
if(empty($page))
{
if(file_exists('sites/home.php') == true)
{
require('sites/home.php');
}
}
$stmt=$pdo->prepare("SELECT ziel,link_url FROM test_menu ORDER BY id");
$stmt->bindColumn(1,$ziel);
$stmt->bindColumn(2,$linkurl);
$stmt->execute();
while ($stmt->fetch())
{
switch ($page)
{
case $ziel:
if(file_exists($linkurl)==true)
{
require $linkurl;
};
break;
}
}
$stmt=$pdo->prepare("SELECT ziele,ling_url FROM log_menu ORDER BY id");
$stmt->bindColumn(1,$ziele);
$stmt->bindColumn(2,$lingurl);
$stmt->execute();
while ($stmt->fetch())
{
switch ($page)
{
case $ziele:
if(file_exists($lingurl)==true)
{
require $lingurl;
};
break;
}
}
$stmt=$pdo->prepare("SELECT ziels,linken_url FROM blind_menu ORDER BY id");
$stmt->bindColumn(1,$ziels);
$stmt->bindColumn(2,$linkurls);
$stmt->execute();
while ($stmt->fetch())
{
switch ($page)
{
case $ziels:
if(file_exists($linkurls)==true)
{
require $linkurls;
};
break;
}
}
echo'</main>'; if(file_exists('footer.php') == true)
{
require('footer.php');
}
$stmt=null;
$pdo=null;
?>