MySQL nested hierarchical data
Posted: Wed Jun 15, 2011 12:54 pm
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)
* list selected node children without children-children
No JavaScript must be involved while working in tree control. See the screen-shot as to how it should look.
This projects requires you to have extensive knowledge of Nested set model http://en.wikipedia.org/wiki/Nested_set_model
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.
Contact g.kuizinas@gmail.com if interested naming your price. I need this done within 7 days.
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)
* list selected node children without children-children
No JavaScript must be involved while working in tree control. See the screen-shot as to how it should look.
This projects requires you to have extensive knowledge of Nested set model http://en.wikipedia.org/wiki/Nested_set_model
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.
Contact g.kuizinas@gmail.com if interested naming your price. I need this done within 7 days.