PHP Classes
elePHPant
Icontem

Node Tree: Manipulate an hierarchy of objects in a database

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   Screenshots Screenshots   View files View files (16)   DownloadInstall with Composer Download .zip   Reputation   Support forum (5)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-03-22 (9 years ago) RSS 2.0 feedStarStarStarStar 63%Total: 2,448 All time: 1,492 This week: 1,332Up
Version License PHP version Categories  
nodetree 1.0GNU Lesser Genera...3Databases, Content management
Description Author  

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: 39
All time rank: 3262 in Finland Finland
Week rank: 911 Down2 in Finland Finland Equal

Details provided by the author  
-------------------------------------------------------------------------
	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 1.5.0.1, 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 <marko@multimediastudio.fi>
Copyright (c) 2006, Multimediastudio 
LGPL - Lesser General Public License
v. 1.0 2006/21/03 <marko@multimediastudio.fi> 
Screenshots  
  • 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  
 0%Total:2,448All time:1,492
 This week:0This week:1,332Up
User Ratings User Comments (1)  
 All time
Utility:91%StarStarStarStarStar
Consistency:86%StarStarStarStarStar
Documentation:86%StarStarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:63%StarStarStarStar
Rank:680
 
Excelent, very good aplication and realy help me.
7 years ago (Leysner Orozco Caicedo)
70%StarStarStarStar