categories sub categories Tree

unknowngiver · 03-04-2007, 06:10 PM

Hey
I am working on a website and im stuck on how to make a php categories and sub categories tree
i can load all the categories..but i dont know how to have sub categories under them
heres how my categories table look like:

Category
-id
-name
-parent
-status

I am looking for the best and efficient way of doing it..a script/tutorial..w.e u got

also..if possible..i wana use ajax in it...2 dynamically load sub categories..etc..not that biggie right now tho..
thanks

vinodkv · 03-04-2007, 08:12 PM

check these ....

http://forums.devshed.com/php-develo...on-292257.html

http://forums.devshed.com/php-develo...ry+subcategory

http://dev.mysql.com/tech-resources/...ical-data.html

i think its will solve your problem....

unknowngiver · 03-04-2007, 08:26 PM

awesome

thanks

unknowngiver · 03-05-2007, 02:39 PM

hey i followed the php recursion code..but i see a Blank page:S for some reason..heres the code

PHP Code:

  <?php

include "include/database.php";

    function catGen($catID, $cPath)

    {

        if ($catID == 0) return;

        $sql = "SELECT `id`,`name`,`parent` FROM `category` WHERE `id` = {$catID} LIMIT 1"; 

        $query = mysql_query($sql) or trigger_error(mysql_errno() . ': ' . mysql_error()); 

        

        if (mysql_num_rows($query) > 0)

        {

            $result = mysql_fetch_array($query, MYSQL_ASSOC);

            $cPath[ $result['id'] ] = $result['name'];

            if ($result['parent'] > 0)

            { 

                catGen($result['parent'], $cPath);

            }

            else

            {

                return; 

            } 

        }

        else

        {

            return; 

        }

    }

 
// START IT

//ERROR_REPORTING(E_ALL);

$catID = 1;

catGen($catID, $container);

 
print_r($container);

?>

and heres the mysql table

Code:

CREATE TABLE `category` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `parent` int(5) NOT NULL default '0',
  `status` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `category`
-- 

INSERT INTO `category` VALUES (1, 'Funny Videos', 0, 1);
INSERT INTO `category` VALUES (2, 'Animation/Flash', 0, 1);
INSERT INTO `category` VALUES (4, 'Test1', 1, 0);
INSERT INTO `category` VALUES (5, 'Test2', 3, 0);
INSERT INTO `category` VALUES (6, 'abc', 1, 0);

cef · 03-06-2007, 12:07 AM

change the catGen function declaration from

PHP Code:

  function catGen($catID, $cPath)

to

PHP Code:

  function catGen($catID, &$cPath)

(put an '&' in front of $cPath)

This passes the parameter by reference, so that any changes you make to it are to the same instance of the $cPath variable, and they propagate back up the chain as you pop your recursion.

Also, you should declare an initial empty array before calling the function for the first time:

PHP Code:

  $catID = 1;

$container = array();

catGen($catID, $container);

print_r($container);

Lastly, if you have a lot of nested categories, you might want to free your mysql query memory along the way with a call to mysql_free_result($query); right before you start recursing in the catGen function.

03-04-2007, 06:10 PM	#1 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	categories sub categories Tree Hey I am working on a website and im stuck on how to make a php categories and sub categories tree i can load all the categories..but i dont know how to have sub categories under them heres how my categories table look like: Category -id -name -parent -status I am looking for the best and efficient way of doing it..a script/tutorial..w.e u got also..if possible..i wana use ajax in it...2 dynamically load sub categories..etc..not that biggie right now tho.. thanks __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

03-04-2007, 08:12 PM	#2 (permalink)
vinodkv NamePros Regular Join Date: Feb 2007 Posts: 403 190.75 NP$ (Donate)	check these .... http://forums.devshed.com/php-develo...on-292257.html http://forums.devshed.com/php-develo...ry+subcategory http://dev.mysql.com/tech-resources/...ical-data.html i think its will solve your problem.... __________________ Web Design Forum - - Free Web Directory

03-04-2007, 08:26 PM	#3 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	awesome thanks __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free

03-05-2007, 02:39 PM	#4 (permalink)
unknowngiver Senior Member Join Date: May 2005 Location: Ontario Canada Posts: 2,928 1,675.13 NP$ (Donate)	hey i followed the php recursion code..but i see a Blank page:S for some reason..heres the code PHP Code: <?php include "include/database.php"; function catGen($catID, $cPath) { if ($catID == 0) return; $sql = "SELECT `id`,`name`,`parent` FROM `category` WHERE `id` = {$catID} LIMIT 1"; $query = mysql_query($sql) or trigger_error(mysql_errno() . ': ' . mysql_error()); if (mysql_num_rows($query) > 0) { $result = mysql_fetch_array($query, MYSQL_ASSOC); $cPath[ $result['id'] ] = $result['name']; if ($result['parent'] > 0) { catGen($result['parent'], $cPath); } else { return; } } else { return; } } // START IT //ERROR_REPORTING(E_ALL); $catID = 1; catGen($catID, $container); print_r($container); ?> and heres the mysql table Code: CREATE TABLE `category` ( `id` int(11) NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `parent` int(5) NOT NULL default '0', `status` smallint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `category` -- INSERT INTO `category` VALUES (1, 'Funny Videos', 0, 1); INSERT INTO `category` VALUES (2, 'Animation/Flash', 0, 1); INSERT INTO `category` VALUES (4, 'Test1', 1, 0); INSERT INTO `category` VALUES (5, 'Test2', 3, 0); INSERT INTO `category` VALUES (6, 'abc', 1, 0); __________________ B3Z.NET Proxy \|\| B5Y.NET Proxy \|\| B7J.NET Proxy \|\| B5J.NET Proxy \|\| B5L.NET Proxy cPanelHosting.com-cPanel Experts For 8 Years Hosting From $4.99 And 2 Months Free Last edited by unknowngiver; 03-05-2007 at 02:48 PM.

03-06-2007, 12:07 AM	#5 (permalink)
cef NamePros Regular Join Date: May 2004 Location: NYC Posts: 236 76.50 NP$ (Donate)	change the catGen function declaration from PHP Code: `function catGen($catID, $cPath)` to PHP Code: `function catGen($catID, &$cPath)` (put an '&' in front of $cPath) This passes the parameter by reference, so that any changes you make to it are to the same instance of the $cPath variable, and they propagate back up the chain as you pop your recursion. Also, you should declare an initial empty array before calling the function for the first time: PHP Code: `$catID = 1; $container = array(); catGen($catID, $container); print_r($container);` Lastly, if you have a lot of nested categories, you might want to free your mysql query memory along the way with a call to mysql_free_result($query); right before you start recursing in the catGen function.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)