[RESOLVED] Tree menu with unlimited depth using php and mysql

gandotratushar

I want to create a tree menu from a table which has the following fields

catagory_id
parent_catagory_id.

now using these two fields i need to build a tree menu of unlimited depth. That tree needs to be expandable and collapsable.....some body please help me

Thanks in advance
Tushar

bbreslauer

Well, say you have the following structure:

tree1
    tree2
    tree3
       tree4
    tree5
       tree6

tree1 would have no parent
tree2, 3, 5 would have tree1 as their parent
tree4 would have tree3 as its parent
tree6 would have tree5 as its parent

leatherback

Search this forum for my posts on recursion and menu. I posted a number of scripts that do these kind of things

gandotratushar

bbreslauer wrote:
Well, say you have the following structure:
tree1
    tree2
    tree3
       tree4
    tree5
       tree6
tree1 would have no parent
tree2, 3, 5 would have tree1 as their parent
tree4 would have tree3 as its parent
tree6 would have tree5 as its parent

I want exactly this thing. the tree should get its value from a table. can u plz show me how

Drakla

Search the site - I've done this, Leatherback has done this, and so will loads of other people - Drawmack, if I remember rightly, was the one that taught me it, so it's on here loads.

Search for things like tree, menu, parent id, pid, heirarchy - variations on those.

gandotratushar

<?php
session_start();
include_once('dbconnect.php');

$query="select * from category_master where project_id=1 and parent_category_id=0";
$result=mysql_query($query);
?>
<html>
<head>

<title>Manage Projects</title>

function MM_reloadPage(init) { //reloads the window if Nav4 resized

if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

}

MM_reloadPage(true);
function reloadfrm()
{
document.disp.method="post"
document.disp.action="<?php echo $_SERVER['PHP_SELF']; ?>"
document.disp.submit()
}

<?php
function myTree ($pid,$cid)
{
$item_query=mysql_query ( "select from category_master where project_id=$pid and parent_category_id=$cid");
while($row=mysql_fetch_array( $item_query ))
{
?>
<br><br><img src="Images/folder.gif"> <a href="<?php echo $SERVER['PHP_SELF']; ?>?catid=<?php echo $row['category_id'];?>&catname=<?php echo $row['category_name'];?>" class="links" "><?php echo $row['category_name'];?></a><br>

<?php
if(isset($GET['catid']))
{
$catid=$GET['catid'];
unset($GET['catid']);
$query="select from category_master where parent_category_id=$catid and project_id=$pid";
$result=mysql_query($query);
while($r=mysql_fetch_array($result))
{?>
<br><br><img src="Images/folder.gif"> <a href="<?php echo $_SERVER['PHP_SELF']; ?>?catid=<?php echo $r['category_id'];?>&catname=<?php echo $r['category_name'];?>" class="links" "><?php echo $r['category_name'];?></a><br>
<?php }
}
}
} ?>
</script>

</head>
<body class="pagebgcolour">

<form method="post" name="disp">
<?php

echo $_SESSION['path'];
myTree("33","0");
//myTree("33","9");
?>
<input type="hidden" name="subcat">
</form>

</body>
</html>

This is the code fragment I am currently working on... we have to browse down the categories onclick... and when I click on the sub category the sub sub category is shown but the prev level sub category is not shown. Please help me with this..
thanks a lot,
Tushar

leatherback

After searching for recursive and leatherback, I found a post, which pointed me here