Some Advice Needed For Menus

You can use a root_id left_id right_id level schema.

@bashy i don't understand

Then do some research on it: http://en.wikipedia.org/wiki/Nested_set_model

Obviously this is only one option, there's many.

What @bashy is trying to say it's this:

Schema::create('menu', function(Blueprint $table)
{
    $table->increments('id');
    $table->string('text');
    /*some cool features */
    $table->integer('order'); 
    $table->boolean('is_visible');
    $table->integer('badge');
    /*some cool features */
    $table->integer('parent_id')->unsigned()->nullable()->default(null);
    $table->foreign('parent_id')->references('id')->on('menu');
});)        

A menu table has a references to itself. It means a menu can be submenu(has a parent menu) of another menu. That's probably the best option.

Now you can select all menus and order by parent_id and order field. The first menu will have parent_id null.

The easiest way to generate the menu list will be a recursive function. Recursion is kinda complicated thing when you're starting but easy when you get the idea.

the recursion idea is something like this:

it's a Pseudocode (not a real one...)

function print_menu($node)
{
    for($i =0; $i<$node->children->size(); ++$i)
    {
        echo "<li>".$node->children[$i]."</li>";
        if($node->children[$i]->children > 0)
        {
        echo "<ul>";
        print_menu($node->children[$i]);
        echo "</ul>";
        }
    }
}

echo "<ul>";
print_menu($root);
echo "</ul>";

The left_id / right_id also allows for ordering so orderBy('left_id', 'ASC') will return them in order (which you show in the backend), you can add a sort function in JS.

@sonu You could also use a package for this like Baum for example. which also has good documentation.

i implemented a drap drop functionality.

@sonu Did you used a package for it or build your own solution?

@kazehaya My Own Have a look . http://screencast.com/t/b45evzeOce8

@sonu Looks great! how did you manage to get the drag and drop working with multiple levels deep? Im trying to find a solution for this for some time now. Mind sharing how you did it? :)