I have writen a class that does what I wanted except the UL LI part...
anyway .I am going to paste you the code here.
The logic of this script is part of phpLayersMenu in sourceforge but much
simpler.
If at anytime you redevelop that code, I would like to send me the changes
....
As far as I know it can display unlimited levels of menus.
the only problem with the ULs and LIs is that in order to make a DHTML or
plain CSS menu
You need the following structure:
<ul>
<li>Category
<ul>
<li>SubCategory </li>
<li>SubCatego ry
<ul>
<li>SubSubCateg ory</li>
<li>SubSubCateg ory</li>
</ul>
</li>
<li>SubCategory </li>
</ul>
</li>
<li>Category
<ul>
<li>SubCategory </li>
<li>SubCategory </li>
</ul>
</li>
</ul>
*************** *************** ***********
My script,
Closes every LI
so it creates the folowing:
(THAT NEEDS fixing to create UL LIs as above)
<ul>
<li></li>
<ul>
<li></li>
<li></li>
<ul>
<li></li>
</ul>
<li></li>
</ul>
</ul>
*************** ***********
class menu
{
var $parent_id=0;
var $level=0;
var $tree = array();
var $nodesCount=0;
var $firstItem=1;
var $lastItem=0;
var $maxLevel=0;
var $firstLevelCnt= 0;
var $i=0;
var $x = array();
function menu()
{
$this->nodesCount = 0;
$this->tree = array();
$this->treecnt = array();
$this->maxLevel = 0;
$this->firstLevelCn t = array();
$this->firstItem = array();
$this->lastItem = array();
}
function scanTableForMen u()
{
$dbresult = mysql_query('SE LECT * FROM product_categor ies
WHERE product_categor ies_id != 0
');
$this->tmpArray = array();
while ($row = mysql_fetch_arr ay($dbresult))
{
$this->tmpArray[$row['product_catego ries_id']]['parent_id'] =
$row['product_catego ries_parent_id'];
$this->tmpArray[$row['product_catego ries_id']]['name'] =
$row['product_catego ries_name'];
$this->tmpArray[$row['product_catego ries_id']]['body'] =
$row['product_catego ries_body'];
$this->tmpArray[$row['product_catego ries_id']]['img'] =
$row['product_catego ries_img'];
}
$this->depth($this->tmpArray,0,0 );
echo "<ul>";
$this->displayMenu($t his->tree);
echo "</ul>";
}
function depth($tmpArray ,$parent_id,$le vel)
{
reset ($tmpArray);
foreach($tmpArr ay as $key => $value)
{
if ($value['parent_id'] == $parent_id)
{
unset($tmpArray[$key]);
unset($this->tmpArray[$key]);
$cnt = count($this->tree) + 1;
$this->tree[$key]['level'] = $level;
$this->tree[$key]['parent'] = $value['parent_id'];
$this->tree[$key]['name'] = $value['name'];
$this->tree[$key]['body'] = $value['body'];
$this->tree[$key]['img'] = $value['img'];
unset($value);
if($key !=$parent_id)
$this->depth($this->tmpArray,$key, $level+1);
}
}
}
function displayMenu($tr ee,$currentLeve l = 0)
{
//echo "<pre>";
//print_r($this->tree);
//echo "</pre>";
while (list($key, $value) = each($this->tree))// for($ii = 1;$ii
<=$this->cntFirstlevel; $ii++)
{
if($this->tree[$key]['level']>$currentLeve l)
echo "<ul>";
if($this->tree[$key]['level'] == $currentLevel)
{
echo "<li>";
echo "<a href=\"?cat_id= $key\">".$this->tree[$key]['name']."</a>";
}
elseif($this->tree[$key]['level'] == $currentLevel+1 )
{
$this->displayMenu($t his->tree,$currentL evel+1);
}
else
{
for($i=0;$i<$cu rrentLevel;$i++ )
{
echo "</li>";
echo "</ul>";
}
$this->displayMenu($t his->tree,$currentL evel=0);
}
unset($this->tree[$key]);
}
}
}
