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
 developerWorks - FREE Tools!
|
<a href="http://zeus.developershed.com/shonuff.php?blackbird=3853&zoneid=442&source=&dest=http%3A%2F%2Fwww.ibm.com%2Fdeveloperworks%2Fspaces%2Fjazz%3FS_TACT%3D105AGY31%26S_CMP%3DDEVSHED&ismap="><img src="http://images.devshed.com/corp/img/news/jazz01.gif" alt="developerWorks Jazz space" align="left"></a>You've heard the buzz about Jazz... want to know more about it from a developer's perspective? Check out the Jazz space on developerWorks. This space is an up-to-date resource for developers, including technical information about Jazz and products built on Jazz, like Rational Team Concert Express. The Jazz space includes content from a wide variety of sources, including links, feeds, and comments from experts.
FREE! Go There Now!
|
|
|
|
Effective governance for lean development isn’t about command and control. Instead, the focus is on enabling the right behaviors and practices through collaborative and supportive techniques. Hear from Scott Ambler on how it is far more effective to motivate people to do the right thing than it is to force them to do so. Learn how to form a lightweight, collaboration-based framework that reflects the realities of modern IT organizations.
FREE! Go There Now!
|
|
|
|
Learn to enable users to both rate existing animations and to combine existing animations into new snippets. This is the third in a series of three tutorials that chronicle the building of a site that enables collaborative discussion and animation building using Domino and OpenLaszlo.
FREE! Go There Now!
|
|
|
|
Visit IBM developerWorks to download a free trial version of WebSphere Extended Deployment Compute Grid, which lets you schedule, execute, and monitor batch jobs. Because online transaction processing and batch jobs execute simultaneously on the same server resources, you can avoid costly duplication of resources. Compute Grid supports job types of Java transactional batch, compute-intensive and a new type called "native execution", which enables non-Java workloads to run on distributed end points.
FREE! Go There Now!
|
|
|
|
Join this webcast to see how IBM Data Studio Developer and pureQuery can take the pain out of Java data access. uApplications developed using both Java and SQL have become a common requirement. Database connectivity using Java Database Connectivity (JDBC) to create an application is a multi-step tedious process, and tooling that covers both SQL and Java has been unavailable, until now. IBM Data Studio introduces the pureQuery platform: a high-performance, Java data access platform focused on simplifying the tasks of developing, managing, and optimizing database applications and services.
FREE! Go There Now!
|
|
|
|
Asset Reuse is a key strategy for companies looking to create innovative solutions to solve complex software development problems. Searching for, identifying, updating, using and deploying software assets can be a difficult challenge. Listen to this webcast, to learn about strategies and tools that you can leverage for a successful project, including Rational Asset Manager, Rational Software Architect and WebSphere Service Registry and Repository.
FREE! Go There Now!
|
|
|
|
XML has become a common way of storing business data as flat files and many data server vendors including IBM have provided ways to store this data within relational database systems. Increasingly collections of XML files are accessed like databases using an xQuery and other XML standard mechanisms. Businesses find the need to combine the traditional tabular structured data with XML formatted data. In this webcast, you’ll learn about IBM’s WebSphere Federation Server technology, which provides users with the ability to integrate these two data formats.
FREE! Go There Now!
|
|
|
|
Join this Rational Talks to You teleconference on December 6 at 1:00 pm ET to participate in an agile application development discussion and get your questions answered on using IBM Rational Method Composer in a distributed environment.Get your questions answered!
FREE! Go There Now!
|
|
|
|
In this webcast, you'll get an introduction to the eXtreme Transaction Processing (XTP) features of WebSphere Extended Deployment and the common architectural traits required by XTP applications. See how WebSphere Extended Deployment's ObjectGrid feature provides a state-of-the-art infrastructure for hosting XTP applications.
FREE! Go There Now!
|
|
|
|
Join this webcast to learn how IBM Rational's Functional Testing solution enables you to implement automation your way, at your pace, with your existing staff. In this webcast, you’ll learn how you can eliminate redundancy of manual test scripts, reduce errors, and increase test coverage through test automation. After this presentation you will understand how IBM Rational Functional Testing solution can streamline your manual testing and make test automation easily attainable.
FREE! Go There Now!
|
|
|
|
All FREE IBM® developerWorks Tools!
|
/ 8 
