Site Navigation Code

  Home arrow Site Navigation Code arrow Simple Menu System
SITE NAVIGATION CODE

Simple Menu System
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 10
    2006-12-12

    Table of Contents:

     
     

    SEARCH CODEWALKERS

    TOOLS YOU CAN USE

    advertisement
    This file builds a simple vertical menu. It runs off of a database table `tbl_menu` with fields:

    menu_id (int, pk)
    menu_name (varchar)
    menu_id_parent (int)
    menu_link (varchar)
    display_page (varchar)
    sort_order (int)

    menu_id_parent is the menu_id one page above another.
    display_page is the page to show the link on (* for all)
    sort_order dictates in what order the links should appear

    *Note that when inserting new pages into the table, you need to use the location relative to the root (i.e. /index.php, /users/cpanel.php, not ../foo.php or index.php)

    Finally, you can use CSS to change how the menu looks.
    Parent Label ("Back to: ") -> span.backlabel
    Parent Link -> a.backlink
    Menu Title -> span.menutitle
    Menu Link -> a.menulink

    By : foreignis

    <?php

    #First things first, connect to your database
    mysql_connect("foobar.com", "foo", "bar");
    mysql_select_db("foobar");

    #This is the function we will use to "backtrack" to the top
    function getParents($url)
    {
    #Find the parent for the supplied URL, if there is one.
    $sql="SELECT * FROM tbl_menu ".
    "WHERE menu_link='$url' ".
    "AND menu_id_parent IS NOT NULL";

    $result=mysql_query($sql) or die(mysql_error());
    $num=mysql_num_rows($result);

    #If we found a parent, good!
    if ($num > 0)
    {
    #Get the necessary information to construct a link for the parent
    $sql="SELECT * FROM tbl_menu ".
    "WHERE menu_id='".mysql_result($result, 0, "menu_id_parent")."'";
    $result=mysql_query($sql) or die(mysql_error());
    $name=mysql_result($result, 0, "menu_name");
    $url=mysql_result($result, 0, "menu_link");

    #Now that we have our information, we will recursively call the getParents
    #with the new URL. We do this prior to our echo for the purpose of printing
    #the path in reverse order (from home down as opposed to bottom-up)
    getParents($url);

    #Once all the recursive calls above this one have returned, display link
    echo "<span class=\"backlabel\">Back to: </span><a class=\"backlink\" href=\"$url\">$name</a><br>";
    }
    }

    #find the current page
    $current_page=$_SERVER['PHP_SELF'];

    #get the path to this page, create links.
    getParents($current_page);

    #pull out information for this page from the database
    $sql="SELECT * FROM tbl_menu WHERE menu_link='$current_page'";
    $result=mysql_query($sql) or die(mysql_error());

    #if we found anything, display the name of the page as the menu's title
    if (mysql_num_rows($result) > 0)
    {
    $menu_title=mysql_result($result, 0, "menu_name");
    echo "<span class=\"menutitle\">$menu_title</span>";
    }

    #now, get everything that isn't the current page that is set either to display on this page or on all pages (*).
    $sql="SELECT * FROM tbl_menu ".
    "WHERE menu_link != '$current_page' ".
    "AND (display_page='$current_page' OR display_page='*') ".
    "ORDER BY sort_order";
    $result=mysql_query($sql) or die(mysql_error());
    $num=mysql_num_rows($result);

    #display a link for each row returned
    for($i=0; $i<$num; $i++)
    {
    $url=mysql_result($result, $i, "menu_link");
    $name=mysql_result($result, $i, "menu_name");
    echo "<br><a class=\"menulink\" href=\"$url\">$name</a>";
    }
    ?>
    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

    More Site Navigation Code Articles
    More By Codewalkers

    blog comments powered by Disqus

    SITE NAVIGATION CODE ARTICLES

    - Simple Menu System
    - Simply image viewer script
    - Simple File Lister
    - Dynamic Error Pages
    - BSoftEditor
    - Yahoo Status
    - Page numbers
    - PHP Search Navigator 1.0
    - Simple Page Navigation
    - An easy page browser ( prev 6 7 8 9 10 next )
    - AutoIndex PHP Script (Directory Indexer)
    - Bs_HtmlNavigation (Navigation and Sitemap cl...
    - Another Paging with Stage
    - Website Navigation via PHP
    - MySQL Paging Class


    © 2003-2012 by Developer Shed. All rights reserved. DS Cluster 7 - Follow our Sitemap