DaniWeb Forum Index > Web Development > PHP

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

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2007

Posts: 64

Reputation: nil_gh_80 is an unknown quantity at this point

Solved Threads: 0

nil_gh_80

Offline

Junior Poster in Training

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

Dec 2nd, 2008

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,

 Help with Code Tags 
 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]

•

Join Date: Dec 2008

Posts: 94

Reputation: sikka_varun is an unknown quantity at this point

Solved Threads: 11

sikka_varun sikka_varun is offline

Offline

Junior Poster in Training

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

Dec 2nd, 2008

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..

 Help with Code Tags 
 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..

VâRûN
---Happy to Help---
sikka_varun@yahoo.com