Yii Framework | Nested arrays in same table

Question

Using CActiveRecord my table looks like this:

A column parent_id has relation many to id, and it works properly.

id | parent_id
---+----------
1    1      <- top
2    1      <- means parent_id with 1 has parent with id=1
3    1
4    2      <- parent for is id=2
5    2
6    2      and so many nested levels....

A goal is how to properly get nested as PHP classically way nested arrays data (arrays inside arrays). array(1,1) { array(2,1) { array(4,2) .... } }

Problem is Yii. I didn't find properly way how to pick up a data as nested array using properly CActiveRecord.

What is best way to make nested array results? A main goal is to easy forward to render view so I don't separate with too many functions and calling many models outside from modules or models.

A good is one function to get a result.

Is there someone tried useful example on nested levels with same table? — Marin Sagovac, Jun 23 '14 at 19:04
@Marin Sagovac, please post all your depending GII generated models, ill help you out. — lin, Jun 23 '14 at 19:06
A simple is, you have 1 table with parent_id column and relation to id. A top level from lowest ID. A some example is good. — Marin Sagovac, Jun 23 '14 at 19:10
Iam sure, this will help you: http://stackoverflow.com/questions/8587341/recursive-function-to-generate-multidimensional-array-from-database-result Cheers! — lin, Jun 23 '14 at 19:56
Yes, I think this is good guide. Exactly for extracting data. Thank you! — Marin Sagovac, Jun 23 '14 at 22:26

score 0 · Accepted Answer · edited May 23 '17 at 10:26

Solved using this: Recursive function to generate multidimensional array from database result

You need get a data as arrays from model:

$somemodel = MyModel::model()->findAll();

Then put all in array rather then Yii objects model or what you need:

foreach ($somemodel as $k => $v)
{
   $arrays[$k] = array('id' => $v->id, 'parent_id' => $v->parent_id, 'somedata' => 'Your data');
}

Then call a function:

function buildTree(array $elements, $parentId = 0) {
    $branch = array();

    foreach ($elements as $element) {
        if ($element['parent_id'] == $parentId) {
            $children = buildTree($elements, $element['id']);
            if ($children) {
                $element['children'] = $children;
            }
            $branch[] = $element;
        }
    }

    return $branch;
}

Then call put all $arrays data into buildTree function to rebuild nesting arrays data.

$tree = buildTree($arrays);

Now your $tree is nested arrays data.

Note: there aren't depth into function but in convient way you can add using like this sample: Create nested list from Multidimensional Array

Yii Framework | Nested arrays in same table

1 Answers1