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

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -