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); } }