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