Question

I really dig the idea of using a recursice function to build my site menus but I am having a problem and have been banging my head for ages now. I need my menu function to return a nested list but I dont want non-active irelevent elements of the tree to be displayed.

详情。我有一个MySql数据库,有一个表格,称为菜单,用于储存所有通常领域的所有物品(目标、链接、文字、所有权等),以及每个项目的独一无二的影子,而重要的是是亲子。

这完全需要辩论,例如,在XML档案中储存这些信息会比较容易?

例如,这里就是一个例子,所有要素都显示:

<ul>
    <li><a href="1.html">link 1</a>
        <ul>
            <li><a href="1-1.html">link 1-1</a>
            <li><a href="1-2.html">link 1-2</a>
        </ul>
    </li>
    <li><a href="2.html">link 2</a>
        <ul>
            <li><a href="2-1.html">link 2-1</a>
            <li><a href="2-2.html">link 2-2</a>
        </ul>
    </li>
    <li><a href="3.html">link 3</a></li>
</ul>

但是,如果现在的网页是1-2.html,那么我就希望这样作:

<ul>
    <li><a href="1.html">link 1</a>
        <ul>
            <li><a href="1-1.html">link 1-1</a>
            <li><a href="1-2.html">link 1-2</a>
        </ul>
    </li>
    <li><a href="2.html">link 2</a></li>
    <li><a href="3.html">link 3</a></li>
</ul>

显然,我将把身份证或现有网页的名称传给Mendu公司。

Any ideas anyone? I have been banging my head against a wall for some time now :-)

Answer 1

这是我完整的方法,数据集有一页的影子、一张母子、一个链接(链接)和一个标题;希望能够帮助。

function make_nav($current_page_id)
{
    nav_rec(0, $current_page_id, constant( SITE_URL ), 0);
}

function nav_rec($page, $current_page_id, $link, $level)
{   
    if (!$page)
    {
        $page = array();
        $page[ page_id ] =   0 ;
    }
    else
    {
        ?><a class="nav-link nav-level-<?= $level ?>" href="<?= $link ?>"><?= $page[ title ] ?></a><?
    }

    // Checks for the subpages from this page.  
    $page_q = "
        SELECT id AS page_id, parent_id, permalink, page_title AS title 
        FROM ".constant( MYSQL_PREFIX )."pages 
        WHERE `page_type` =  page 
        AND `in_nav` =  1 
        AND `status` =  published 
        AND `is_deleted` =  0 
        AND `parent_id` =  ".$page[ page_id ]." ";

    if ($page_rs = mysql_query($page_q))
    {
        if (mysql_num_rows($page_rs))
        {
            while($page = mysql_fetch_assoc($page_rs))
            {
                nav_rec($page, $current_page_id, $link . $page[ permalink ]. / , $level+1);
            }
        }
        else
        {
            $level = 0;
        }
    }
    else
    {
        $level = 0;
    }
}

友情链接