cakephp get tree into an array

Question

I have a table with nodes that acts as a tree. I have a tree structure:

Null
Null
-Child
--ChildofChild
--ChildofChild
-Child
Null

etc...

I want to get it into an array structure like this:

array(
   0 => array( id => ''),
   1 => array( id => '', array( 
        0 => array( id => '', 
             0 => array(
                  id => '',
                 )
             1 => array (
                  id =>''),
        1 => array(id => '')      
   2 => array ( id => '')

I have missed some closing brackets, but the idea is to get an array including an array for every node inside the array of its parent. all arrays will contain just the node's id. I tried with find('threaded) but I can't get it as I want. Any ideas??

Please read carefully the CakePHP Docs at Tree. The solution is there — Cris Sawfish
– Cris Sawfish, Commented Feb 18, 2013 at 14:38

Claudio Bredfeldt · Accepted Answer · 2013-05-11 21:23:28Z

7

This is what you'r looking for:

$categories = $this->Category->find('threaded', array(
    'fields' => array('id', 'parent_id', 'name'),
    'order' => array('lft ASC') // or array('id ASC')
));

answered May 11, 2013 at 21:23

Claudio Bredfeldt

1,42217 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cakephp get tree into an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related