How To: Vertical Menus (non JS)?

[civ +]

Great looking site, and great idea to display your categories this way!

[dawnrae]

Thanks! Eric did the hard part, though ... he made my menu work with his magical skills!

Dawn

[michael +]

Excellent! One question though. What if listings are nested at various depths according to the category they are in?

e.g.

Motors
>Vans
>Ford
>Transit

and

Pets
>Rabbits

[ombre +]

Originally Posted by dawnrae

For anyone else who wishes a vertical menu in a similar fashion, here's the final code (many, many thanks to Eric).

function getTotal($cat)
{
global $db;
$sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."listings WHERE display = 'Y' AND expiration > NOW() AND section=".$cat;
$result=$db->query($sSQL);
$row = $result->fetch();
return $row['total'];
}
?>

This is now bugfixed getTotal function the products table is changed to listings so we must query the listings table.

Regards, and thanks for this function. Great work boys

[Red +]

I've got this nearly working.
The menu shows, but there's no count, and when a category is selected it opens the category.php and not the actual single category id.

View here http://thebikemart.com/index.php

TIA


Fixed Problem!

[hel68c +]

Nice function,

but how to display level2 subcategory in categories?

category-->sub1-->sub2

Radio_Control-->Plane-->engine

[hel68c +]

Nobody has an idea?

[hel68c +]

I found how to make a second level of sub category.

Category (9)
-->level1_sub_category (5)
-->-->level2_sub_category (4)

Here is my contribution to help.

<?php
/**
* smarty_function_categories_ul
*
* This function is useful for using your categories in the navigation.
*
* All source code & content (c) Copyright 2006, 68 Classifieds
* unless specifically noted otherwise.
*
* @package 68classifieds
* @author Eric Barnes
* @copyright 68 Classifieds
* @link http://www.68classifieds.com
* @$Revision: 1.1 $
* @Updated: $Date: 2007/01/08 19:12:22 $
*/

function smarty_function_categories_ul($params, &$smarty)
{
global $db;

$ul_attr = '';
$li_attr = '';
$depth=2;
$show_total = 'Y';

foreach ($params as $_key=>$_value)
{
switch ($_key)
{
case 'depth':
$$_key = (int)$_value;
break;

case 'ul_attr':
case 'li_attr':
case 'show_total':
$$_key = (string)$_value;
break;
}
}

$sSQL="SELECT id,name,parent_id,cOrder,cLink,slug FROM ".PREFIX."categories WHERE parent_id=0 AND display<>'N' ORDER BY cORDER DESC, name ASC";
$result=$db->query($sSQL);
$output="<ul ".$ul_attr.">\n";
while($row = $result->fetch())
{
$slug=$row['slug'];
$id=$row['id'];
$parent=$row['parent_id'];
if($row['cLink']<>'')
{
$link=$row['cLink'];
}
else
{
$link='category.php?cat='.$slug;
}
$output .= "<strong><li ".$li_attr."><a href=\"".$link."\">".$row['name']."</strong></a>\n";
if($show_total=='Y')
{
$arr_childs='';
$arr_childs = array($id);
get_cat_ids($arr_childs);
$total=get_cat_count($arr_childs);
$output.="( ". $total .")";
}
//get sub categories
$sSQL2="SELECT id,name,parent_id,cOrder,cLink,slug FROM ".PREFIX."categories WHERE parent_id=".$id." AND display<>'N' ORDER BY cORDER DESC, name ASC";
//$output.=$sSQL2."\n";
$result2=$db->query($sSQL2);
if($result2->size() > 0)
{
$output.="<ul>\n";
while($row = $result2->fetch())
{
$slug=$row['slug'];
$subid=$row['id'];
if($row['cLink']<>'')
{
$link=$row['cLink'];
}
else
{
if($subid>1)
{
$link='category.php?cat='.$slug;
}
else
{
$link='category.php?cat='.$slug;
}
}
$output .= "<li ".$li_attr."><a href=\"".$link."\">-->".$row['name']."</a>\n";
if($show_total=='Y') {
$arr_childs='';
$arr_childs = array($subid);
get_cat_ids($arr_childs);
$total=get_cat_count($arr_childs);
$output.="( ". $total .")";

}

//get sub_sub categories
$sSQL3="SELECT id,name,parent_id,cOrder,cLink,slug FROM ".PREFIX."categories WHERE parent_id=".$subid." AND display<>'N' ORDER BY cORDER DESC, name ASC";
$result3=$db->query($sSQL3);
if($result3->size() > 0)
{
$output.="<ul>\n";
while($row = $result3->fetch())
{
$slug=$row['slug'];
$sub_subid=$row['id'];
if($row['cLink']<>'')
{
$link=$row['cLink'];
}
else
{
if($sub_subid>1)
{
$link='category.php?cat='.$slug;
}
else
{
$link='category.php?cat='.$slug;
}
}
$output .= "<li ".$li_attr."><a href=\"".$link."\">-->-->".$row['name']."</a>\n";
if($show_total=='Y')
{
$arr_childs='';
$arr_childs = array($sub_subid);
get_cat_ids($arr_childs);
$total=get_cat_count($arr_childs);
$output.="( ". $total .")";
}
}
$output.="</ul>\n";
}
$output.="</li>\n";


}
$output.="</ul>\n";
}
$output.="</li>\n";
}
$output.="</ul>\n";
return $output;
}

function get_cat_ids($arr_ids)
{
$arr_new= array();
global $arr_childs, $db;
$sSQL="SELECT id FROM ".PREFIX."categories WHERE parent_id In (". implode(', ', $arr_ids) .")";
$result=$db->query($sSQL);
if($result->size() >= '1')
{
while($rs=$result->fetch())
{
if (!in_array($rs['id'], $arr_childs))
{
$arr_childs[] = $rs['id'];
$arr_new[] = $rs['id'];
}
}
if (count($arr_new) >= '1')
{
get_cat_ids($arr_new);
}
else
{
return;
}

}
else
{
return;
}
}
function get_cat_count($arr_ids)
{
global $db, $modules;
$sSQL="SELECT COUNT(*) AS size FROM ".PREFIX."listings WHERE ".$where." section In (". implode(', ', $arr_ids) .") AND expiration > NOW() AND (display='Y' OR display='S')";
$result=$db->query($sSQL);
$row = $result->fetch();
$total=$row['size'];
return $total;
}
/*
//get sub_sub categories
$sSQL3="SELECT id,name,parent_id,cOrder,cLink,slug FROM ".PREFIX."categories WHERE parent_id=".$subid." AND display<>'N' ORDER BY cORDER DESC, name ASC";
$result3=$db->query($sSQL3);
if($result3->size() > 0)
{
$output.="<ul>\n";
while($row = $result3->fetch())
{
$slug=$row['slug'];
$sub_subid=$row['id'];
if($row['cLink']<>'')
{
$link=$row['cLink'];
}
else
{
if($sub_subid>1)
{
$link='category.php?cat='.$slug;
}
else
{
$link='category.php?cat='.$slug;
}
}
$output .= "<li ".$li_attr."><a href=\"".$link."\">".$row['name']."</a>\n";
if($show_total=='Y')
{
$arr_childs='';
$arr_childs = array($sub_subid);
get_cat_ids($arr_childs);
$total=get_cat_count($arr_childs);
$output.="( ". $total .")";
}
}
$output.="</ul>\n";
}
$output.="</li>\n"; */



?>

[Eric Barnes +]

Hi,

Thanks for sharing. You may want to post this as a new topic in the module release section so other people can find it.