[RESOLVED] How to display in the form of a tree

[gandotratushar]

Hi

I m facing a problem plz help me. i want to display information from the database in the form of a tree.how can i do that using php. Like i have a directory structure in the database,i want to display that structure in the form of a tree. if i click the top directory i should see all the sub directories in the tree structure............

Thanks in advance....
Tushar

[maxpup979]

here is a quick and dirty directory walker. you can use the same basic logic on any heirarchical structure.

function dir_listing($dir){
	if(($dir=="")or(!(isset($dir)))){show_errors(1);exit;}
	if(is_dir($dir)){
		#get directory listing, and display dirs/files
		if ($handle = opendir($dir)) {
			print "<table border=1>";
   			print "Directory : $dir <br>";
 			while (false !== ($file = readdir($handle))) {
				if($file=="."){}
				else if($file==".."){show_dir($dir,$file);}
 				else if(is_dir($dir."/".$file)){show_dir($dir,$file);}
				else if(is_file($dir."/".$file)){show_file($dir,$file);}
				else{error(2);exit;}
 	   		}
			print "</table>";
   			closedir($handle);
		}

}
}#close function

[gandotratushar]

This is my table structure and i want to display it in the form of tree.

---

category_id int(4) auto_increment

parent_category_id int(4)

project_id int(4)

category_name varchar(20)
date_of_creation date

is_active tinyint(1)

created_by int(4)

if parent category is there it should come as sub directory otherwise it should be the main directory

Thanks in advance

[cyberlew15]

ignore your current table structure could you not have a giant table where all of the data goes. for example

GLOBAL_ID 0 // ID in the database
CAT_ID 4565 // Action
PARENT_CAT_ID 0022 // Games
PROJECT_ID 0004
CAT_NAME bob // not sure why you want this
DOC 20042005 // Date DDMMYYYY psuedo timestamp
IS_ACTIVE yes
CREATED_BY bill clinton
LEVEL "1"

now do a super expandable code for the level
echo "<img src=".$itemlevel.".gif>";

this means that for each level you would have a gif file to input before the text creating a psuedo tree view effect

[kakki]

maybe you can do sth. recursive
( thats a draft of the "dirwalker" with your table-structure )

function myTree ( $id )
{
          $item_query=mysql_query ( "SELECT * FROM xxx WHERE id=" . $id );
          $item=mysql_fetch_array( $item_query );   

          // print the item

       // now go for the sub-directories
       $subdir_query=mysql_query ( "SELECT * FROM xxx WHERE parent_id=" . $id );
       while ( $row = @mysql_fetch_array( $subdir_query ) )
       {
                myTree ( $row[ 'id'] );
       }
}