MySQL nested hierarchical data

Looking to hire a PHP developer for a paid position? Looking for a paid PHP job? Want to post your resume? Let the job hunt begin...

Moderator: General Moderators

Post Reply
User avatar
spamyboy
Forum Contributor
Posts: 266
Joined: Sun Nov 06, 2005 11:29 am
Location: Lithuania, vilnius

MySQL nested hierarchical data

Post by spamyboy »

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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: MySQL nested hierarchical data

Post by Weirdan »

Where's 'the screenshot'?
The last requirement is not clear to me. Did you mean "selected node's children without grandchildren"?
Ah, and do you care about the code itself? Could it simply use some doctrine-based objects with nested set behavior attached or do you need it dumbed down like it was written for class assignment?
Post Reply