PHP Classes
elePHPant
Icontem

Nested Sets DB Tree: Manipulate database records in hierarchical trees

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Kuzma Feskov
Name: Kuzma Feskov <contact>
Classes: 1 package by
Country: Russian Federation Russian Federation
Age: 38
All time rank: 3588 in Russian Federation Russian Federation
Week rank: 131 Up7 in Russian Federation Russian Federation Up


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
This class can be used to manipulate nested sets of database table records as an hierarchical tree.

It can initialize a tree, insert nodes in specific positions of the tree, retrieve node and it's parent records, change nodes position and delete nodes.

Currently the class functions can:

- Retrieve all data for node with number node id
- Retrieve data of closest parent for node with number node id
- Add new child element to node with number parent id
- Add a new element into the tree near node with number node id
- Assigns another parent parent id to a node node id with all its children
- Change position of nodes within the same parent and same level of nesting
- Swapping nodes with it's children within the same parent and same level of nesting
- Deletes element with number node id from the tree without deleting it's children, moving its children up one level
- Deletes element with number node id from the tree and all it children.
- Returns all elements of the tree sorted by left value
- Returns all elements of a branch starting from an element with number node id
- Returns all parents of element with number node id
- Returns a slightly opened tree from an element with number node id
- Sort children in a tree for order field in alphabetical order
- Makes UL/LI HTML from nested sets tree with links if needed

  Classes of Kuzma Feskov  >  Nested Sets DB Tree  >  Download Download .zip .tar.gz  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Nested Sets DB Tree
Base name: dbtree
Description: Manipulate database records in hierarchical trees
Version: 4.4
PHP version: 5
License: GNU General Public License (GPL)
All time users: 7085 users
All time rank: 251
Week users: 9 users
Week rank: 91 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Data types Modeling and manipulating data types View top rated classes

  Files folder image Screenshots  
dbtree_manage
File Role Description
Accessible without login Image file dbtree_manage Screen Admin interfase demo sample


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (98%) Good (83%) Good (81%) Good (89%) - - Sufficient (74%) 94
Month: Not yet rated by the users

  Applications that use this package  
The Southern generating company
Site navigation
The State Saint-Petersburg Drama Theatre
Site navigation tree

Add link image If you know an application of this package, send a message to the author to add a link here.

  Files folder image Files  
File Role Description
Files folder imageexamples (3 files)
Files folder imagelanguage (2 files)
Plain text file DbTree.class.php Class DbTree v4.4
Plain text file DbTreeExt.class.php Class DbTree v4.4
Plain text file README.md Doc. Documentation
Plain text file safemysql.class.php Class Class source

  Files folder image Files  /  examples  
File Role Description
  Plain text file dbtree_demo.php Example Example script
  Plain text file dbtree_visual_demo.php Example Example script
  Plain text file sample_dump.sql Example MySQL dump of demo

  Files folder image Files  /  language  
File Role Description
  Plain text file dbtree.lang-en.php Class Class source
  Plain text file dbtree.lang-ru.php Class Class source

Install with Composer Install with Composer - Download Download all files: dbtree.tar.gz dbtree.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.