PHP Classes

Node Tree: Manipulate an hierarchy of objects in a database

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (16)   DownloadInstall with Composer Download .zip   Reputation   Support forum (5)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 2,486 All time: 1,550 This week: 177Up
Version License PHP version Categories
nodetree 1.0.0GNU Lesser Genera...3Databases, Content management


This package can be used to manipulate an hierarchy of objects stored in a MySQL database.

It provides basic methods (actions) that includes adding, editing, deleting, copying, moving and sorting object nodes.

The package includes scripts that provide a Web interface to manipulate the object hierarchy. Database query debug information is dumped at the end of the scripts.

The node classes can be extended to provide additional functionality like generating a XML representation of the hierarchy structure.

Picture of Marko Tapio Manninen
Name: Marko Tapio Manninen <contact>
Classes: 3 packages by
Country: Finland Finland
Age: 48
All time rank: 3422 in Finland Finland
Week rank: 349 Down1 in Finland Finland Up


------------------------------------------------------------------------- READ ME (readme.txt) ------------------------------------------------------------------------- This is a short read me file for a NodeTree components and a sample node modifying tool. NodeTree.php is a class that works in conjuctions with Node and PhpDtObject classes to easily create and modify hierarchical trees for categorizing purposes. Trees are constructed with materialized paths on two dimensional tables in mysql database. Basic methods (actions) includes adding, editing and deleting nodes as well as copying, moving and ordering nodes. Package includes index.php file, that is a script to make modifying trees possible straight from the web interface. Script prints standard html list and with stylesheet and javascript files makes hierarchical data visually accessable. Query debug information is dumped at the end of the script. Structuring data in a hierarchal way is a basic operation when creating more advanced information handling applications. When extending NodeTree with own methods it is possible to retrieve xml like structured data from database in many handy ways. --- Index.php requires config.php and actions.php files to work properly. Additionally you need some media files (style.css, script.js and .gif files) for web interface. NodeTree works with next database table schema: CREATE TABLE `treetest` ( `node_id` int(11) NOT NULL auto_increment, `node_path` varchar(255) NOT NULL default '', `node_depth` int(11) NOT NULL default '0', `node_order` int(11) NOT NULL default '0', `node_title` varchar(255) NOT NULL default '', `node_has_childs` tinyint(4) NOT NULL default '0', PRIMARY KEY (`node_id`), KEY `node_id` (`node_id`), KEY `node_path` (`node_path`), KEY `node_depth` (`node_depth`), KEY `node_order` (`node_order`), KEY `node_title` (`node_title`), KEY `node_has_childs` (`node_has_childs`) ) TYPE=MyISAM; INSERT INTO `treetest` VALUES ('1','x','1','0','1','1'), ('2','x','1','1','2','0'), ('3','x','1','2','3','1'), ('4','x.3','2','1','3.1','0'), ('5','x.3','2','2','3.2','0'), ('6','x.3','2','3','3.3','0'), ('7','x.1','2','0','1.1','0'); Please see files and comments inside them to get more info how they work. JavaScripts and stylesheets are tested succesfully on - mac safari 2.0.3, firefox, netscape 7.2 and omniweb 5.1.1 - pc firefox 1.0.1 Php scripts and classes are tested succesfully on: - Apache 1.3.33, PHP 5.0.4, MySql 4.1.3 - Apache 1.3.34, PHP 4.4.2, MySql 4.1.14 Opera and Internet explorer seems to have problems with javascript and styles at this moment. ************************************************************************** Marko Manninen <> Copyright (c) 2006, Multimediastudio LGPL - Lesser General Public License v. 1.0 2006/21/03 <>

  • screenshot.png
  Files folder image Files  
File Role Description
Files folder imagemedia (6 files)
Files folder imagenode (2 files)
Files folder imagephpdtobject (4 files)
Plain text file actions.php Appl. Node actions operation file
Plain text file config.php Conf. Main configuration file
Plain text file index.php Appl. Main index file
Plain text file readme.txt Doc. Readme file

  Files folder image Files  /  media  
File Role Description
  Image file edit.gif Icon Edit icon
  Image file fieldsetarrow.gif Icon Fieldset arrow icon
  Image file minus.gif Icon Minus icon
  Image file plus.gif Icon Plus icon
  Plain text file script.js Data Javascript
  Plain text file style.css Data Stylesheet

  Files folder image Files  /  node  
File Role Description
  Plain text file Node.php Class Node class
  Plain text file NodeTree.php Class NodeTree class

  Files folder image Files  /  phpdtobject  
File Role Description
  Plain text file MysqlQueryBuilder.php Class MysqlQueryBuilder class
  Plain text file PhpDtObject.php Class PhpDtObject class
  Plain text file PhpDtObject_dsn.php Class PhpDtObject_dsn class
  Plain text file PhpDtObject_mysql.php Class PhpDtObject_mysql class

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:1,550
This week:177Up
User Ratings User Comments (1)
 All time
Excelent, very good aplication and realy help me.
15 years ago (Leysner Orozco Caicedo)