I need script to manage hierarchical data in MySQL database using nested set model. Simple PHP interface is required.
The required functions:
* display node tree as <ul> <li> structure (incl. numeric index, e.g. 1., 1.1., 1.2., 1.2.1., etc.)
* create node (add child)
* delete node (along with the sub-tree)
* change node position (along with the sub-tree)
* change node parent (along with the sub-tree)
This projects requires you to have extensive knowledge of Nested set model http://en.wikipedia.org/wiki/Nested_set_model
Don't bid if you have no experience with Nested set model. One more thing I forgot to include in features list:
* list selected node children without children-children
This job does not require you to work with an existing database. You are required to create your own simple database (id | name | left | right) and use your own simple PHP script to execute appropriate SQL queries/manipulate the tree.