javascript - Fast way to organize hierarchical MySQL tables? -
i need create (and edit constantly) hierarchical database structure this:
http://sqlfiddle.com/#!2/95654/3
so real structure looks this:
- a
- b
- c
- x
- y
since need add/remove/edit items constantly, pain phpmyadmin, or queries.
so there plugin javascript (ajax) , php, organizes kind of things drag & drop? or other easy way?
thanks !
p.s.: know plugin cannot know item table's structure, need set parent relations (hierarchy_table
in example) quickly. can add items, , make them dom objects. need drag , drop parent relations.
for example, can have div's objects contain data :
<div class='item' data-id='2' data-title='b'/>
and when drag div 'a', should insert or update hierarchy_table
item_id = 2.
Comments
Post a Comment