Recursive enumeration data DB foreach

Question

Recursive enumeration data DB foreach

ArtemNic Aug '16

Created Aug '16	Last Reply Aug '16	Replies 1	Views 381	Votes 0

ArtemNic 3.7k

Aug '16

Hello! Do DB hierarchy . The problem is this: after working a nested foreach function is no longer to do the previous crawl , eventually process ends on the last nesting level of the first

$robots2 = Data::find();

<?php

    $n=0;
    function data($parent_id, $robots2, $n, $type_id){
        $n++;
        foreach ($robots2 as $robot):
            if ($robot->parent_id==$parent_id):?>
                    <p style = "margin-left:<?php echo 1+$n;?>%"><?php echo $robot->name;?></p>
                    <?php
                            data($robot->id, $robots2,$n, $type_id);
                    ?> 
            <?php endif;
        endforeach;
        $n--;
    }
    ?>

Edwin Manuel Cerrón Angeles · Answer 1 · 2016-08-21T09:46:47-07:00

<?php

    $n=0;
    function data($parent_id, $robots2, $n, $type_id){
        $n++;
        foreach ($robots2 as $robot) {
            if ($robot->parent_id==$parent_id):?>
                   echo '<p style = "margin-left:'. ++$n .'">'. $robot->name .'</p>';
                   data($robot->id, $robots2,$n, $type_id);
             }
        }
        $n--;  // error.
    }