function getMenu()
{
echo '<a id="login" href="admin/login.php">login</a>';
echo '<ul class="menu">';
require 'db_conn.php';
$query = "SELECT * FROM pagecontent";
$result = $db->query($query);
$content = $result->fetch_all(MYSQLI_ASSOC);
foreach ($content as $menuoption) {
$menu = isset($menuoption['menuoption']) ? $menuoption['menuoption'] : null;
$page = $menuoption['page'];
$getpage = isset($_GET['page']) ? $_GET['page'] : 'home';
$active = $page == $getpage ? 'active' : 'inactive';
$pagecontent_id = $menuoption['pagecontent_id'];
if ($menu != null && $pagecontent_id == 0) {
?>
<li class="<?php
echo $active;
?>
"><a href="?page=<?php
echo $page;
?>
"><?php
echo $menu;
?>
</a><?php
echo getSubmenu($menuoption['id']);
}
}
echo '</ul>';
}
function menu($link, $page)
{
//if the page is not found the value of the variables makes an erorr page while still making the menu
$PageContent = array();
$title = "Error";
$contents = "Error page not found!";
$chek = "layout";
$menu = "<ul>";
$query = "SELECT * FROM `pagecontent.` WHERE pagecontentid = 0 AND menuoption<>'' ORDER BY menuorder";
$result = $link->query($query);
$pagecontent = $result->fetch_all(MYSQLI_ASSOC);
foreach ($pagecontent as $content) {
$submenus = getSubmenu($link, $content['id']);
if ($page == $content['page']) {
$contents = $content['content'];
$title = $content['page'];
$chek = $content['template'];
$menu .= "\n<li class=\"active\"><a href=\"?page={$content['page']}\">{$content['menuoption']}</a>";
} else {
$menu .= "\n<li><a href=\"?page={$content['page']}\">{$content['menuoption']}</a>";
}
if ($submenus != null) {
$menu .= "<ul class=\"submenu\">";
foreach ($submenus as $submenu) {
if ($page == $submenu['page']) {
$contents = $submenu['content'];
$title = $submenu['page'];
$chek = $submenu['template'];
$menu .= "\n<li class=\"active\"><a href=\"?page={$submenu['page']}\">{$submenu['menuoption']}</a></li>";
} else {
$menu .= "\n<li><a href=\"?page={$submenu['page']}\">{$submenu['menuoption']}</a></li>";
}
}
$menu .= "</ul>";
continue;
}
$menu .= "</li>";
}
$menu .= "</ul>";
$PageContent = array($contents, $title, $chek, $menu);
return $PageContent;
}
<?php
$link = new mysqli('localhost', 'root', '', 'doomla');
$query = "SELECT * FROM `pagecontent.` WHERE pagecontentid = 0 AND menuoption<>''";
$result = $link->query($query);
$pages = $result->fetch_all(MYSQLI_ASSOC);
echo "<ul>";
foreach ($pages as $page) {
$submenus = getSubmenu($link, $page['id']);
echo "<li>" . $page['page'] . "</li>";
if ($submenus != null) {
echo "<ul>";
foreach ($submenus as $submenu) {
echo "<li>" . $submenu['page'] . "</li>";
}
echo "</ul>";
}
}
echo "</ul>";
function getSubmenu($link, $id)
{
$query = "SELECT * FROM `pagecontent.` WHERE pagecontentid = {$id}";
$result = $link->query($query);
if ($result->num_rows > 0) {
$submenus = $result->fetch_all(MYSQLI_ASSOC);
return $submenus;
}
$submenus = null;
return $submenus;
}
$link = new mysqli('localhost', 'root', '', 'doomla');
$page = "home";
$template = "template.php";
$content = "erorr page not found";
$id = 1;
$submenu = "";
$pageid = 0;
$contents = "";
$page = isset($_GET['page']) ? $_GET['page'] : "home";
$query = "SELECT * FROM `pagecontent.` WHERE pagecontentid = 0 AND menuoption<>'' ORDER BY menuorder";
$result = $link->query($query);
$pagecontent = $result->fetch_all(MYSQLI_ASSOC);
$menu = "<ul>";
$pagesub = 0;
foreach ($pagecontent as $content) {
$submenus = getSubmenu($link, $content['id']);
if ($page == $content['page']) {
$contents = $content['content'];
$title = $content['page'];
$chek = $content['template'];
$menu .= "\n<li class=\"active\"><a href=\"?page={$content['page']}\">{$content['menuoption']}</a>";
} else {
$menu .= "\n<li><a href=\"?page={$content['page']}\">{$content['menuoption']}</a>";
}
if ($submenus != null) {
$menu .= "<ul class=\"submenu\">";
foreach ($submenus as $submenu) {
if ($page == $submenu['page']) {
$contents = $submenu['content'];
$title = $submenu['page'];
$chek = $submenu['template'];
function getSubmenu ($oC, $MnID, $UsID, $GpID, $x, &$Stm)
{
global $oU;
$oUp = new umpermission($oC);
$oGp = new umgpermission($oC);
$oMn = new ummenu($oC);
$oMn->SearchByKey($MnID);
$oMn->GetRecord();
$flg = 1;
$oUp->SearchByKey($UsID, $MnID);
if ($oUp->GetRecord()) {
$flg = $oUp->pmX;
} else {
$oGp->SearchByKey($GpID, $MnID);
if ($oGp->GetRecord()) {
$flg = $oGp->gpX;
}
}
if ($flg == $x){
if ($oMn->MnLevel > 0){
if ($oMn->MnNameT != "-") {
if (trim($oMn->MnURL) <> "") {
$Stm .= str_pad("", 5 * 6 * $oMn->MnLevel, " ", STR_PAD_RIGHT)."<img src=\"" . $GLOBALS["_INFO_URL"] . "/img/submenu_mini.gif\" align=\"middle\" border=\"0\" alt=\"\">";
$Stm .= " <a href=\"$oMn->MnURL\" style=\"font-weight: bold; color: #11387D;\">" . trim($oMn->MnNameT) . "</a>";
} else {
$Stm .= str_pad("", 5 * 6 * $oMn->MnLevel, " ", STR_PAD_RIGHT)."<img src=\"" . $GLOBALS["_INFO_URL"] . "/img/submenu_mini_cyan.gif\" align=\"middle\" border=\"0\" alt=\"\">";
$Stm .= "<span style=\"font-weight: bold; color: #777777;\"> " . trim($oMn->MnNameT) . "</span>";
}
$Stm .= "<br>\n";
}
}
$oMn->RSmenuByParentMn($MnID);
}
while ($oMn->GetRecord()) {
getSubmenu($oC, $oMn->MnID, $UsID, $GpID, $flg, $Stm);
}
}
