PHP - Left Navigation Coding - More Depth To Navigation Bar

hello

navigation - how can i get the id of an active tab

i have a top nav which is pulling its tabs from a database how can i get the id of the active tab then pass it in a global to side navigation

this is the top nav code

Code: [Select]
<?PHP
require_once("../includes/initialize.php");
global $topNavs;
global $pageName;
?>
<div id="navWrapper">
<?PHP
$topNav = navL1::find_all();
?>
  <div id="ddtabs3" class="solidblockmenu">
<ul>
<?PHP foreach($topNav as $topNavs): ?>

<li><a <?PHP echo ($pageName == $topNavs->title ? 'class="selected"' : '')?> href="<?PHP echo $topNavs->title; ?>.php" id="<?PHP echo $topNavs->title; ?>"><?PHP echo $topNavs->title; echo $topNavs->id;?></a></li>
   
   
<?PHP endforeach; ?>
</ul>
</div><!--  #ddtabs3-->
</div><!--  #navWrapper-->



this prints the id of 5 which is the last tab in my database. if i have tab 1 active how can i get my loop to get that id ?

thanks
rick

 

Hello! Can someone please explain to me why I do not read navigation from mysql database data?

 

Database

 

Code:
 

<style type="text/css">
    .navbar .dropdown-toggle, .navbar .dropdown-menu a {
        cursor: pointer;
    }

    .navbar .dropdown-item.active, .navbar .dropdown-item:active {
        color: inherit;
        text-decoration: none;
        background-color: inherit;
    }

    .navbar .dropdown-item:focus, .navbar .dropdown-item:hover {
        color: #16181b;
        text-decoration: none;
        background-color: #f8f9fa;
    }

    @media (min-width: 767px) {
        .navbar .dropdown-toggle:not(.nav-link)::after {
            display: inline-block;
            width: 0;
            height: 0;
            margin-left: .5em;
            vertical-align: 0;
            border-bottom: .3em solid transparent;
            border-top: .3em solid transparent;
            border-left: .3em solid;
        }
    }
</style>
<script type="text/javascript">
    $(document).ready(function () {
        $('.navbar .dropdown-item').on('click', function (e) {
            var $el = $(this).children('.dropdown-toggle');
            var $parent = $el.offsetParent(".dropdown-menu");
            $(this).parent("li").toggleClass('open');

            if (!$parent.parent().hasClass('navbar-nav')) {
                if ($parent.hasClass('show')) {
                    $parent.removeClass('show');
                    $el.next().removeClass('show');
                    $el.next().css({"top": -999, "left": -999});
                } else {
                    $parent.parent().find('.show').removeClass('show');
                    $parent.addClass('show');
                    $el.next().addClass('show');
                    $el.next().css({"top": $el[0].offsetTop, "left": $parent.outerWidth() - 4});
                }
                e.preventDefault();
                e.stopPropagation();
            }
        });

        $('.navbar .dropdown').on('hidden.bs.dropdown', function () {
            $(this).find('li.dropdown').removeClass('show open');
            $(this).find('ul.dropdown-menu').removeClass('show open');
        });

    });
</script>

<?php 
$servername = "localhost";
$username = "root";
$password = "";

$db = new PDO("mysql:host=$servername;dbname=dbname", $username, $password);

function menu_builder1($db, $parent_id) {
    $sql = $db->prepare("SELECT * FROM menu WHERE status = 1 ORDER BY position ASC");
    if($sql->execute()) {
        while ($row = $sql->fetch(PDO::FETCH_ASSOC)) {
            $array[$row['menu_sub_id']][] = $row;
        }
        main_menu1($array);
    }
}
function main_menu1($array, $parent_id = false) {
    if(!empty($array[$parent_id])) {
        foreach ($array[$parent_id] as $item) {
            if ($item['dropdown'] == false) {
                echo '<li class="nav-item active"><a class="nav-link" href="' . $item['href'] . '">' . $item['name'] . '</a></li>';
            }
            elseif ($item['dropdown'] == true) {
                echo '<li class="nav-item dropdown"><a class="nav-link dropdown-toggle" id="dropdown2" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">' . $item['name'] . '</a>';
                sub_menu1($array, $item['menu_id']);
                echo '</li>';
            }
        }
    }
}
function sub_menu1($array = array(), $parent_id = false) {
    if(!empty($array[$parent_id])) {
        echo '<ul class="dropdown-menu" aria-labelledby="dropdown2">';
        foreach ($array[$parent_id] as $item) {
            if ($item['dropdown'] == false) {
                echo '<li class="dropdown-item"><a href="' . $item['href'] . '">' . $item['name'] . '</a></li>';
            }
            elseif ($item['dropdown'] == true) {
                echo '<li class="dropdown-item dropdown"><a class="dropdown-toggle" id="dropdown2-1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">' . $item['name'] . '</a>';
                sub_sub_menu1($array, $item['menu_id']);
                echo '</li>';
            }
        }
        echo "</ul>";
    }
}

function sub_sub_menu1($array = array(), $parent_id = false) {
    if(!empty($array[$parent_id])) {
        echo '<ul class="dropdown-menu" aria-labelledby="dropdown2-1">';
        foreach ($array[$parent_id] as $item) {
            if ($item['dropdown'] == false) {
                echo '<li class="dropdown-item"><a href="' . $item['href'] . '">' . $item['name'] . '</a></li>';
            }
        }
        echo "</ul>";
    }
}
?>
<div class="navbar navbar-expand-md navbar-dark bg-dark mb-4" role="navigation">
    <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarCollapse" aria-controls="navbarCollapse" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarCollapse">
        <ul class="navbar-nav mr-auto">
            <?=menu_builder1($db, 0)?>
        </ul>
    </div>
</div>

Result:

Hey,

I hope you will understand what I am saying, because english isn't my main language -.-,

Anyway, I need to create a folder navigation, what I mean is like

you got folder on your comp : C:\navThing\ (and many sub folders and files)

what I want to do is list all files from the current directory where the user is. if he is in C:\navThing\ show dir and files in C:\navThing\ only...
if he is in C:\navThing\lol\ show dir and files in C:\navThing\lol only...

but I don't know how to get the user position, for the moment I'm using $_GET, but well, I don't think it's really secure... ( xxx.php?path=lol/ )

if anybody can think of any other way, where the user can't modify it tell me, I thougth session would be good, but what if he use previous... anyway any suggestion?

I am relatively new to PHP, trying to learn more every day.

I have been enjoying using Server Side Includes in my sidebars, footer etc with good results, much handier and more efficient!

I would like to do the same for the header and main site navigation.

However, the main problem that I am not sure how to deal with comes from having 'active' links (differently coloured menu tab for the page the user is on) in my menu.

Here is a small menu example:

Code: [Select]
<div class="menu">
                 <ul>
                         <li><a href="nav.php" class="active">Home</a></li>
                         <li><a href="nav2.php">About</a></li>
                         <li><a href="products1.php">Products</a></li>
                         <li><a href="products2.php">Products 2</a></li>
                         <li><a href="products3.php">Products 3</a></li>

                       
                    </ul>
    </div> 
When the user is on the Home page, the class is set to active - i.e. a different colour.

If I do a simple server side include with my navigation this will of course be across all the pages. Can anyone please advise on what I need to do to make the menu work correctly across all the pages? (have different tabs selected for each respective page).

Any help / insight is much appreciated.

I was talking to some friends, who are just as new as me in programming, and they think it would be better to use a single navigation file for every link in a web site.

Something like this:

Code: [Select]
<a href="nav.php?id=home&otherparams" >Home</a>
<a href="nav.php?id=products&otherparams" >Products</a>
<a href="nav.php?id=contact&otherparams" >Contact</a>
I told them I think this might be easier to maintain, but also might take up on loading time, as the site viewer will have to go through an extra node to get where he wants.
Is this single navigation file a good practice or should it be avoided?

Thanks for any comments...

Hi,

I'm building a dynamic site for a college project (a CMS) and have been using a Lynda tutorial. When the user clicks on a subject, the sub menu appears for the (a UL with a UL), so there is an 'accordian effect'. However, when I click on one of the page links in the sub menu, the content for that page appears, but the second UL containing the links to the pages dissapears. It only re-appears when I click back on the parent element (the subject link).

I'd really appreciate some help. I've tried editing this code below but have had no joy:

Code: [Select]
function public_navigation($sel_subject, $sel_page, $public = true) {
$output = "<ul class=\"subjects\">";
$subject_set = get_all_subjects($public);
while ($subject = mysql_fetch_array($subject_set)) {
$output .= "<li";
if ($subject["id"] == $sel_subject['id']) { $output .= " class=\"selected\""; }
$output .= "><a href=\"index.php?subj=" . urlencode($subject["id"]) .
"\">{$subject["menu_name"]}</a></li>";
if ($subject["id"] == $sel_subject['id']) {
$page_set = get_pages_for_subject($subject["id"], $public);
$output .= "<ul class=\"pages\">";
while ($page = mysql_fetch_array($page_set)) {
$output .= "<li";
if ($page["id"] == $sel_page['id']) { $output .= " class=\"selected\""; }
$output .= "><a href=\"index.php?page=" . urlencode($page["id"]) .
"\">{$page["menu_name"]}</a></li>";
}
$output .= "</ul>";
}
}
$output .= "</ul>";
return $output;
}


The code that precedes this is as follows:

Code: [Select]

function get_all_subjects($public = true) {
global $connection;
$query = "SELECT *
FROM Subjects ";
if ($public) {
$query .= "WHERE visible = 1 ";
}
$query .= "ORDER BY position ASC";
$subject_set = mysql_query($query, $connection);
confirm_query($subject_set);
return $subject_set;
}

function get_pages_for_subject($subject_id, $public = true) {
global $connection;
$query = "SELECT *
FROM pages ";
$query .= "WHERE subject_id = {$subject_id} ";
if ($public) {
$query .= "AND visible = 1 ";
}
$query .= "ORDER BY position ASC";
$page_set = mysql_query($query, $connection);
confirm_query($page_set);
return $page_set;
}

function get_subject_by_id($subject_id) {
global $connection;
$query = "SELECT * ";
$query .= "FROM Subjects ";
$query .= "WHERE id=" . $subject_id ." ";
$query .= "LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
// REMEMBER:
// if no rows are returned, fetch_array will return false
if ($subject = mysql_fetch_array($result_set)) {
return $subject;
} else {
return NULL;
}
}

function get_page_by_id($page_id) {
global $connection;
$query = "SELECT * ";
$query .= "FROM pages ";
$query .= "WHERE id=" . $page_id ." ";
$query .= "LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
// REMEMBER:
// if no rows are returned, fetch_array will return false
if ($page = mysql_fetch_array($result_set)) {
return $page;
} else {
return NULL;
}
}

function get_default_page($subject_id) {
// Get all visible pages
$page_set = get_pages_for_subject($subject_id, true);
if ($first_page = mysql_fetch_array($page_set)) {
return $first_page;
} else {
return NULL;
}
}

function find_selected_page() {
global $sel_subject;
global $sel_page;
if (isset($_GET['subj'])) {
$sel_subject = get_subject_by_id($_GET['subj']);
$sel_page = get_default_page($sel_subject['id']);
} elseif (isset($_GET['page'])) {
$sel_subject = NULL;
$sel_page = get_page_by_id($_GET['page']);
} else {
$sel_subject = NULL;
$sel_page = NULL;
}
}

function navigation($sel_subject, $sel_page, $public = false) {
$output = "<ul class=\"subjects\">";
$subject_set = get_all_subjects($public);
while ($subject = mysql_fetch_array($subject_set)) {
$output .= "<li";
if ($subject["id"] == $sel_subject['id']) { $output .= " class=\"selected\""; }
$output .= "><a href=\"edit_subject.php?subj=" . urlencode($subject["id"]) .
"\">{$subject["menu_name"]}</a></li>";
$page_set = get_pages_for_subject($subject["id"], $public);
$output .= "<ul class=\"pages\">";
while ($page = mysql_fetch_array($page_set)) {
$output .= "<li";
if ($page["id"] == $sel_page['id']) { $output .= " class=\"selected\""; }
$output .= "><a href=\"content.php?page=" . urlencode($page["id"]) .
"\">{$page["menu_name"]}</a></li>";
}
$output .= "</ul>";
}
$output .= "</ul>";
return $output;
}

Hi guys,

I recently wrote a pagination script and it works fine, except from when trying to echo the navigation.

This is the Pagination.php Script
Code: [Select]
<?php

class Pagination 
{
/**
 * Current Page
 *
 * @var integer
 */
var $page;

/**
 * Size of the records per page
 *
 * @var integer
 */
var $size;

/**
 * Total records
 *
 * @var integer
 */
var $total_records;

/**
 * Link used to build navigation
 *
 * @var string
 */
var $link;

/**
 * Class Constructor
 *
 * @param integer $page
 * @param integer $size
 * @param integer $total_records
 */
function Pagination($page = null, $size = null, $total_records = null)
{
$this->page = $page;
$this->size = $size;
$this->total_records = $total_records;
}

/**
 * Set's the current page
 *
 * @param unknown_type $page
 */
function setPage($page)
{
$this->page = 0+$page;
}

/**
 * Set's the records per page
 *
 * @param integer $size
 */
function setSize($size)
{
$this->size = 0+$size;
}

/**
 * Set's total records
 *
 * @param integer $total
 */
function setTotalRecords($total)
{
$this->total_records = 0+$total;
}

/**
 * Sets the link url for navigation pages
 *
 * @param string $url
 */
function setLink($url)
{
$this->link = $url;
}

/**
 * Returns the LIMIT sql statement
 *
 * @return string
 */
function getLimitSql()
{
$sql = " WHERE school = 'ssb' ORDER BY orientation LIMIT " . $this->getLimit();
return $sql;
}

/**
 * Get the LIMIT statment
 *
 * @return string
 */
function getLimit()
{
if ($this->total_records == 0)
{
$lastpage = 0;
}
else 
{
$lastpage = ceil($this->total_records/$this->size);
}

$page = $this->page;

if ($this->page < 1)
{
$page = 1;
} 
else if ($this->page > $lastpage && $lastpage > 0)
{
$page = $lastpage;
}
else 
{
$page = $this->page;
}

$sql = ($page - 1) * $this->size . "," . $this->size;

return $sql;
}

/**
 * Creates page navigation links
 *
 * @return  string
 */
function create_links()
{
$totalItems = $this->total_records;
$perPage = $this->size;
$currentPage = $this->page;
$link = $this->link;

$totalPages = floor($totalItems / $perPage);
$totalPages += ($totalItems % $perPage != 0) ? 1 : 0;

if ($totalPages < 1 || $totalPages == 1){
return null;
}

$output = null;
//$output = '<span id="total_page">Page (' . $currentPage . '/' . $totalPages . ')</span>&nbsp;';

$loopStart = 1; 
$loopEnd = $totalPages;

if ($totalPages > 5)
{
if ($currentPage <= 3)
{
$loopStart = 1;
$loopEnd = 5;
}
else if ($currentPage >= $totalPages - 2)
{
$loopStart = $totalPages - 4;
$loopEnd = $totalPages;
}
else
{
$loopStart = $currentPage - 2;
$loopEnd = $currentPage + 2;
}
}

if ($loopStart != 1){
$output .= sprintf('<li class="disabledpage"><a href="' . $link . '">&#38;#171;</a></li>', '1');
}

if ($currentPage > 1){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">Previous</a></li>', $currentPage - 1);
}

for ($i = $loopStart; $i <= $loopEnd; $i++)
{
if ($i == $currentPage){
$output .= '<li class="currentpage">' . $i . '</li> ';
} else {
$output .= sprintf('<li><a href="' . $link . '">', $i) . $i . '</a></li> ';
}
}

if ($currentPage < $totalPages){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">Next</a></li>', $currentPage + 1);
}

if ($loopEnd != $totalPages){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">&#38;#187;</a></li>', $totalPages);
}



return "<div class='pagination'><ul>" . $output . "</ul></div>";
}
}

?>
And this is the actual page which needs paginating:

Code: [Select]
<?php

include('Pagination.php');

$page = 1;

// how many records per page
$size = 9;

// we get the current page from $_GET
if (isset($_GET['page'])){
    $page = (int) $_GET['page'];
}

// create the pagination class
$pagination = new Pagination();
$pagination->setLink("album.php?page=%s");
$pagination->setPage($page);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);

// now use this SQL statement to get records from your table
//$SQL = "SELECT * FROM mytable " . $pagination->getLimitSql();


$myServer = "********";  
$myUser = "*******";
$myPass = "*******";
$myDB = "*******";

//connection to the database
$dbhandle = mysql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 

//select a database to work with
$selected = mysql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB"); 



$album_query = "SELECT * FROM albums WHERE album_name = '" . $_REQUEST['album'] . "' ";

$album_result = mysql_query($album_query) or die('Error Getting Information Requested for album');

$album_row = mysql_fetch_array($album_result);




$album = $_REQUEST['album'] . " " . $album_row['school'];


$photo_query = "SELECT * FROM `" . $album . "` " . $pagination->getLimitSql();

//$photo_query = "SELECT * FROM `" . $album . "` WHERE school = 'ssb' ORDER BY orientation" . $pagination->getLimitSql();


$photo_result = mysql_query($photo_query) or die('Error Getting Information Requested for photos');

$photo_row = mysql_fetch_array($photo_result);

$photo_row_count = mysql_num_rows($photo_result);




$i = 0;
$cellcnt = 0;
while ($i < $photo_row_count) {

$thumb_selection = $_REQUEST['album'] . " " . $album_row['school'];
$photo_selection = $_REQUEST['album'] . " " . $album_row['school'];

if($thumb_selection == "nutcracker 2007 ssb")
$act_thumb = mysql_result($photo_result,$i,"thumbnail");
else
$act_thumb = mysql_result($photo_result,$i,"thumbnail") . "/" . mysql_result($photo_result,$i,"photo_id") . ".jpg";

if($photo_selection == "nutcracker 2007 ssb")
$act_photo = mysql_result($photo_result,$i,"photo_path");
else
$act_photo = mysql_result($photo_result,$i,"photo_path") . "/" . mysql_result($photo_result,$i,"photo_id") . ".jpg";

if (!(mysql_result($photo_result,$i,"photo_name") == ""))
$photo_name_font_tag = "<font style=' padding: 5px; background-color:grey; font-family: Vag Round, Vag Rounded; color: #C02777;'>";
else
$photo_name_font_tag = "<font style='font-family: Vag Round, Vag Rounded; color: #C02777;'>";

$f1 ="
<td align='center'>
<a class='grouped_elements' rel='group1' href='" . $act_photo . "'><img src='" . $act_thumb . "' />
<br />
" . mysql_result($photo_result,$i,"photo_name") . "</a>
</td></font>
";

echo "" .  $f1 ."";

$cellcnt++;
if ($cellcnt == 3) {
echo "</tr> <tr>";
$cellcnt = 0;
}

$i++;
}

?>
</table>
</td>
<td>
&nbsp;
</td>
<td>
&nbsp;
</td>
</tr>
<tr>
<td>
&nbsp;
</td>
<td>
<?php 

$navigav = $pagination->create_links();
//$navigav = $pagination -> create_links($output);
echo $navigav;

?>


Any help would be greatly appreciated!

Jacob.

im trying to write a simple script. Pretty much to scrape a page content. maybe you can help me.  This is what i got so far

<?php
$url = 'http://www.solecollector.com/forums/memberlist.php';
$output = file_get_contents($url);
echo $output;
?>

which works good. Now how could i have it navigate to the next page and run the script again, and do so untill it reaches the last page.

Any help its appreciated or point me on the right direction.

Hi guys!

I need a php page that is splitted into 2 screens. One will display the navigation menu and the second one is the iframe.

As for the navigation menu, I am getting the list of all files in the current directory with readdir(). Then I create an array with all of the items that are folders (is_dir() function) and apply the same script on them. My problem is to correctly display all of the information I gather in an adequate manner. Can anyone help me with that? Also if anyone has ready-to-go scripts, I would highly appreciate that too.

Also, once a user choose a file, it should be loaded in the iframe. How do I specify "src" attribute for the iframe, in that case?

Thanks!

Is there a way I can do this?

Hi PHP Freaks!

Here is my problem. I want to have a PHP navigation system that uses Arrays to control it.

Code: [Select]
$nav = array(
    "title1" => "url1",
    "title2" => array(
        "sub-page1" => "url1",
        "sub-page2" => "url2"
        ),
    "title3" => array(
        "sub-page1" => "url1",
        "sub-page2" => "url2"
        ),
    "title4" => array(
        "sub-page1" => "url1",
        "sub-page2" => "url2"
        ),
    "title5" => "url1",
    "title6" => "url1"
    );

 $loc = basename($_SERVER["REQUEST_URI"]);


What I'm trying to do, is if the $loc is a url in "title4" I want a ul/li printout of that array. Any help you could share with me would be MUCH appreciated.
The printout should look like:
Code: [Select]
<ul>
<li>Title4<ul>
    <li>url1</li>
    <li>url2</li>
</ul></li>
</ul>

I need to implement a dynamic 3 tier navigation system using php. I have a mysql table containing the following data:-

http://i223.photobucket.com/albums/dd147/jimmyoneshot/categoriestable.jpg

And I'm inches away from getting it working. Basically when the user clicks the top level categories (Cat1A, Cat1B etc) the second level categories (Cat2A, Cat2B etc) within each should show beneath them and in turn when the user clicks these second level categories the third level ones (Cat3A, Cat3B etc) should show beneath those.

I've done this to an extent using a 'child_of' property and do while loops and some if statements but the problem seems to be when I click a category that doesn't have any categories as it's children such as Cat1D and Cat2B a bullet point is still showing beneath those which it shouldn't.

Here's a link to how I have it working at the moment to show this:-

http://www.coolvisiontest.com/garyssite/rhrvouchers/voucherspage.php

And here's my code. Can anyoone please tell me what I'm doing wrong:-



<?php 

require_once('connectionfile.php'); 
mysql_select_db($database, $myconnection);

$categories2_child_of = "0";
if (isset($_GET['child_of2'])) {
  $categories2_child_of = $_GET['child_of2'];
}

$categories3_child_of = "0";
if (isset($_GET['child_of3'])) {
  $categories3_child_of = $_GET['child_of3'];
}

$query_getcategories1 = "SELECT category_id, category, is_parent, child_of FROM categories WHERE is_parent=1 AND child_of=0";
$result_getcategories1 = mysql_query($query_getcategories1, $myconnection) or die(mysql_error());
$row_getcategories1 = mysql_fetch_assoc($result_getcategories1);

$query_getcategories2 = "SELECT category_id, category, is_parent, child_of FROM categories WHERE is_parent=1 AND child_of=$categories2_child_of";
$result_getcategories2 = mysql_query($query_getcategories2, $myconnection) or die(mysql_error());
$row_getcategories2 = mysql_fetch_assoc($result_getcategories2);

$query_getcategories3 = "SELECT category_id, category, is_parent, child_of FROM categories WHERE is_parent=0 AND child_of=$categories3_child_of";
$result_getcategories3 = mysql_query($query_getcategories3, $myconnection) or die(mysql_error());
$row_getcategories3 = mysql_fetch_assoc($result_getcategories3);

?>


<ul>
  <?php do { ?>
    <li>
      <a href="voucherspage.php?child_of2=<?php echo $row_getcategories1['category_id']; ?>&child_of3=0"><?php echo $row_getcategories1['category']; ?></a>
    </li>
     <?php if($row_getcategories1['category_id']==$categories2_child_of) {?>  
   <?php do { ?>
        <li>
          <a href="voucherspage.php?child_of2=<?php echo $categories2_child_of?>&child_of3=<?php echo $row_getcategories2['category_id']; ?>"><?php echo $row_getcategories2['category']; ?></a>
        </li>
<?php if($row_getcategories2['category_id']==$categories3_child_of) {?> 
            <?php do { ?>
            <li>
              <?php echo $row_getcategories3['category']; ?>
            </li>
            <?php } while ($row_getcategories3 = mysql_fetch_assoc($result_getcategories3)); }?>          
        <?php } while ($row_getcategories2 = mysql_fetch_assoc($result_getcategories2)); }?>    
  <?php } while ($row_getcategories1 = mysql_fetch_assoc($result_getcategories1)); ?>
</ul>

Hi all.

I'm working on a project that requires a 3 tier navigation menu that's dynamic and I'm not quite sure where to start with it.  The structure of the menu is like so...

A unique list of Parent-Modules
Tier1: Parent-Module1

Each parent module has a second tier menu that appears upon clicking a parent module.  Each parent module has a unique list of tier 2 sub modules
Tier 2: Sub-Module1  -  Sub-Module2

Each sub module has a third tier menu that appears upon clicking a sub module.  Each sub module has a unique list of tier 3 child modules
Tier 3: Child-Module1 -  Child-Module2 -  Child-Module3

A visual:
Parent (each parent module has this structure)
|
|--------Sub Module
|             |-Child Module 1
|             |-Child Module 2
|             |-Child module 3
|--------Sub Module
|             |-Child Module 1
|             |-Child Module 2
|             |-Child module 3
|--------Sub Module
              |-Child Module 1
              |-Child Module 2
              |-Child module 3

Every tier has to be dynamic as the module names/locations are often changed.  My thought is to use opendir/readdir in order to build the tiers based on what files exist, but I'm not sure if this is a safe/reliable practice.  Any input would be a great help.

EDIT: The navigation links would have to have "pretty" names (e.g. Business Processes instead of business_processes).

I have got a script which is able to create hierarchical categories infinitely and display them as items in a ul.

What I need now is to get these categories to appear in a hierarchical dropdown i.e. the user clicks a menu and the dropdown drops down, then the categories that don't have any children will simply be displayed whereas the categories that do have children will have an arrow pointing to the right and once hovered over all of their children will be displayed in a new menu with their children and so on a nd so forth. Very similar to the way the windows menu bar works except with more levels.

Basically I want it to function sort of like a spry menu bar except it can go down then across etc etc and any further categories and sub categories that are added in will be shown. Can anybody help me out with this or perhaps point me in the direction of a tutorial that helps to avhieve this effect.

Heres my code that creates them in an unordered list:--



<?php

$link = mysqli_connect('localhost','','');
mysqli_select_db($link,'mydb');

$query = mysqli_query($link,'SELECT * FROM nested_categories');
while ( $row = mysqli_fetch_assoc($query) ){        
$menu_array[$row['id']] = array('name' => $row['name'],'parent' => $row['parent_id']);
}

function generate_menu($parent){        
$has_childs = false;        

global $menu_array;        

foreach($menu_array as $key => $value){                
if ($value['parent'] == $parent){ 
                              
if ($has_childs === false){                                

$has_childs = true;                                
echo '<ul id="categories">';                        
}                        

echo '<li>'. $value['name'];                        
generate_menu($key);                        

echo '</li>';                
}        
}        
if ($has_childs === true) echo '</ul>';
}

generate_menu(0);

?>