FuelPHP Forums

Can you be more specific? What exactly do you want to know?

Do you understand the principle behind nested sets? If not, read this first, so you get an understanding of how it works: http://www.evanpetersen.com/item/nested-sets.html

Yes, you can create multiple tree structures in a single table, using the 'tree_id' column to uniquely identify the tree. You can use if field as a foreign key to a parent table that defines the trees (give them a name, etc), but you don't need to.

You can add nodes to an existing tree without problems.

If you look at the example given here: http://docs.fuelphp.com/packages/orm/model/nestedset.html#/usage, you can see that it is very easy.

Say you have a menu like this:
- Item A
- Item B
- Item C

and you want
- Item A
- Item B
  - Item B.1
  - Item B.2
- Item C

All you have to do is:

// create the two new objects
$b1 = Model_Menu::forge(array('name' => 'Item B.1'));
$b2 = Model_Menu::forge(array('name' => 'Item B.2'));

// get the node that has to become the parent (standard ORM query)
$b = Model_Menu::query()->where('name', '=', 'Item B')->get_one();

// and assign the new nodes to it (reverse order, child() inserts before)
$b->child($b2)->save();
$b->child($b1)->save();