CODEWITHSUNDEEP
phpjsonmenu
David Edwards
David Edwards

Reputation: 232

How to take a flat JSON file and build a hierarchical menu using PHP

I have a database with a list of menu links. Every menu link has an ID in the field 'menu_pages_id'.

In the database there is a field "subPageOf" which says what its parent is. There are also three different kinds of menu links, which is defined in the field "menuType"

I have outputted this list into a flat JSON file, and want to reconstruct the hierarchy.

$jsonMenu = json_decode($jsonMenu);
foreach ($jsonMenu as $pageInfo ) {
    $pageUrl = $pageInfo->pageUrl;
    $menuPageName = $pageInfo->pageName;
    $menuType = $pageInfo->menuType;
    $subPageOf = $pageInfo->subPageOf;
    $menu_pages_id = $pageInfo->menu_pages_id;
    
    if( $menuType == 'header' &&  $subPageOf == '0' ){
        $headerMenu .= "<a href='$pageUrl'>$menuPageName</a>"; 
    }
    
    if( $menuType == 'category' &&  $subPageOf == '0'){
        $categoryMenu .= "<li><a href='$pageUrl'>$menuPageName</a></li>";
    }
    
    if( $menuType == 'footer' &&  $subPageOf == '0' ){
        $footerMenu .= "<a href='$pageUrl'>$menuPageName</a>"; 
    } 
}

$categoryMenu = '<ul>'.$categoryMenu.'</ul>';
echo $headerMenu
echo $categoryMenu
echo $footerMenu

This will output the first level of course... but how do I nest the sub-pages into the <li> of its parent for the category menus.

I could put another whole foreach loop in the <li> element and run it again filtering for the parent id. But this means I would have to hard code a depth to search for, and it seems like a lot of extra code. I am hoping for a more elegant solution.

Here is an example Json Menu

[{"menu_pages_id":"77","menu_id":"1","page_id":"1","listOrder":"0","subPageOf":"0","pageName":"Home","pageUrl":"home","pageType":"system","isProtected":"1","customerGroup":"1001","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"78","menu_id":"1","page_id":"14","listOrder":"0","subPageOf":"0","pageName":"About Us","pageUrl":"aboutus","pageType":"content","isProtected":"0","customerGroup":"1001","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"80","menu_id":"1","page_id":"6","listOrder":"0","subPageOf":"0","pageName":"Register","pageUrl":"register","pageType":"system","isProtected":"1","customerGroup":"1004","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"81","menu_id":"1","page_id":"7","listOrder":"0","subPageOf":"0","pageName":"Your Account","pageUrl":"account","pageType":"system","isProtected":"1","customerGroup":"1003","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"82","menu_id":"1","page_id":"9","listOrder":"0","subPageOf":"0","pageName":"Logout","pageUrl":"logout","pageType":"system","isProtected":"1","customerGroup":"1003","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"83","menu_id":"2","page_id":"15","listOrder":"0","subPageOf":"0","pageName":"Terms and Conditions","pageUrl":"terms-and-conditions","pageType":"content","isProtected":"0","customerGroup":"1001","menuName":"Footer","menuType":"footer","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"84","menu_id":"2","page_id":"44","listOrder":"0","subPageOf":"0","pageName":"Wholesale","pageUrl":"wholesale","pageType":"content","isProtected":"0","customerGroup":"1005, 1007","menuName":"Footer","menuType":"footer","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"97","menu_id":"24","page_id":"1","listOrder":"0","subPageOf":"0","pageName":"Home","pageUrl":"home","pageType":"system","isProtected":"1","customerGroup":"1001","menuName":"Test Menu","menuType":"category","assignedGroup_id":"3","menuStatus":"Active"},{"menu_pages_id":"98","menu_id":"24","page_id":"14","listOrder":"0","subPageOf":"0","pageName":"About Us","pageUrl":"aboutus","pageType":"content","isProtected":"0","customerGroup":"1001","menuName":"Test Menu","menuType":"category","assignedGroup_id":"3","menuStatus":"Active"},{"menu_pages_id":"99","menu_id":"24","page_id":"5","listOrder":"0","subPageOf":"97","pageName":"Login","pageUrl":"login","pageType":"system","isProtected":"1","customerGroup":"1004","menuName":"Test Menu","menuType":"category","assignedGroup_id":"3","menuStatus":"Active"},{"menu_pages_id":"100","menu_id":"24","page_id":"3","listOrder":"0","subPageOf":"99","pageName":"Support","pageUrl":"support","pageType":"system","isProtected":"1","customerGroup":"1001","menuName":"Test Menu","menuType":"category","assignedGroup_id":"3","menuStatus":"Active"},{"menu_pages_id":"101","menu_id":"24","page_id":"15","listOrder":"0","subPageOf":"0","pageName":"Terms and Conditions","pageUrl":"terms-and-conditions","pageType":"content","isProtected":"0","customerGroup":"1001","menuName":"Test Menu","menuType":"category","assignedGroup_id":"3","menuStatus":"Active"},{"menu_pages_id":"79","menu_id":"1","page_id":"5","listOrder":"3","subPageOf":"0","pageName":"Login","pageUrl":"login","pageType":"system","isProtected":"1","customerGroup":"1004","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"},{"menu_pages_id":"96","menu_id":"1","page_id":"44","listOrder":"8","subPageOf":"0","pageName":"Wholesale","pageUrl":"wholesale","pageType":"content","isProtected":"0","customerGroup":"1005, 1007","menuName":"Header Menu","menuType":"header","assignedGroup_id":"1","menuStatus":"Active"}]

Upvotes: 0

Views: 473

Answers (2)

David Edwards
David Edwards

Reputation: 232

Taking from what Kewlashu said I was able to make it work using the following.

$jsonMenu = json_decode($menus);
function makeMenu($jsonMenu,$parentId) {
    $menu .=  "<ul>";
    foreach ($jsonMenu as $pageInfo ) {
        $menuCustomerGroup = $pageInfo->customerGroup;
        $pageUrl = $pageInfo->pageUrl;
        $menuPageName = $pageInfo->pageName;
        $menuType = $pageInfo->menuType;
        $subPageOf = $pageInfo->subPageOf;
        $menu_pages_id = $pageInfo->menu_pages_id;
        if($menuType == 'category' &&  $subPageOf == $parentId){
            $menu .= "<li><a href='$pageUrl'>$menuPageName</a>".makeMenu($jsonMenu,$menu_pages_id)."</li>";
        }   
    }
    $menu .= "</ul>";
    return $menu;    
} 

$menu = makeMenu($jsonMenu,0);
$menu = str_replace("<ul></ul>",'', $menu);
echo $menu;

This solution left empty <ul></ul> elements at the bottom of each submenu so I used string replace to remove them before output.

Upvotes: 0

kewlashu
kewlashu

Reputation: 1109

Recursion should be used i think. Some code based on rough example below shall work:

$menus = "your flat menu array";

function getNestedMenu($menus,$subPageOf){
    $nestedMenus = array();
    foreach($menus as $menu){
        if($menu['subPageOf'] = $subPageOf){
            $nestedMenu = $menu;
            $nestedMenu['subPages'] = getNestedMenu($menus,$menu['page_id']);
            $nestedMenus[] = $nestedMenu;
        }
    }
    return $nestedMenus;
}

$myNestedMenus = getNestedMenu($menu,"0");

Using above code you can also adapt it to make nested ul li based menu html code

Upvotes: 1

Related Questions