Category hierarchy problem............

Expand Post »

Hello friends,

I've a category table, the structure is:

category{
id int(11) autoincrement,
name varchar(255),
parentid int(11);
}

Now a node can have multiple child nodes and grand child nodes. now if I want to get all childnodes and grandchild nodes of a node id what should i do ???????

I've written a recursive function but this is not working properly,

php Syntax (Toggle Plain Text)
 
//mysql connection
 
 
$objcatId = new catId();
$rsId[] = $objcatId->prod_view(22);
print_r($rsId);
 
class catId{
 
	var $id;
 
	function prod_view($id){
 
	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);
 
	if($num > 0){
 
		while($row = mysql_fetch_array($sql)){
 
			$idArray[] = $row['id'];
 
			$this->prod_view($row['id']);
		}		
 
	}	
		//print_r($idArray);
		return $idArray;
	}	
 
}
//mysql connection


$objcatId = new catId();
$rsId[] = $objcatId->prod_view(22);
print_r($rsId);

class catId{
	
	var $id;
		
	function prod_view($id){
		
	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);
		
	if($num > 0){
		
		while($row = mysql_fetch_array($sql)){
			
			$idArray[] = $row['id'];
			
			$this->prod_view($row['id']);
		}		
		
	}	
		//print_r($idArray);
		return $idArray;
	}	

}

Last edited by peter_budo; Dec 2nd, 2008 at 8:15 pm. Reason: Please, either use [code] or [code=php] (or other langiage as necessary). DO NOT USE [code language=php]

Similar Threads

0x8004010F error in all Offline Address Books from Exchange 2000 server in Windows NT / 2000 / XP

nil_gh_80

Reputation Points: 8

Solved Threads: 2

Junior Poster in Training

Offline

64 posts
since Aug 2007

Permalink

Dec 2nd, 2008

Re: Category hierarchy problem............

Hii...
What it seems from your code is, you are storing the value after mysql_fetch_array in an array without an id..
So try this code..

PHP Syntax (Toggle Plain Text)
//mysql connection
 
 
$objcatId = new catId();
$rsId[] = explode(",",$objcatId->prod_view(22));
print_r($rsId);
 
class catId{
 
static $idvalues="";
 
function prod_view($id)
{
 
	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);
 
	if($num > 0)
	{
 
		while($row = mysql_fetch_array($sql))
		{
			if(self::$idvalues=="")
			{
				self::$idvalues=$row['id'];
			}
			else
			{
				self::$idvalues.=",".$row['id'];
			}
 
			$this->prod_view($row['id']);
 
		}
 
	}
 
	return self::$idvalues;
} 
 
}
//mysql connection


$objcatId = new catId();
$rsId[] = explode(",",$objcatId->prod_view(22));
print_r($rsId);

class catId{

static $idvalues="";

function prod_view($id)
{

	$sql = mysql_query("select id from cart_category where pid='$id'") or die(mysql_error());
	$num = mysql_num_rows($sql);

	if($num > 0)
	{

		while($row = mysql_fetch_array($sql))
		{
			if(self::$idvalues=="")
			{
				self::$idvalues=$row['id'];
			}
			else
			{
				self::$idvalues.=",".$row['id'];
			}
			
			$this->prod_view($row['id']);

		}
	
	}

	return self::$idvalues;
} 

}

Try this code... The system im using right now doesnt have PHP installed.. so cant check it here.. Hope this helps you.. If any problem comes, then tell me the error..

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

Permalink

Dec 3rd, 2008

Database Category hierarchy problem............

This article should help

Storing hierarchical data in database

chrisranjana

Reputation Points: 11

Solved Threads: 3

Junior Poster in Training

Offline

82 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: search from database

Next Thread in PHP Forum Timeline: PHP Gaming basics

DaniWeb Message

Cancel Changes

User Name
Password