如何递归地构建一个 <select>树深未知

2022-01-05 00:00:00 递归 tree php

我有一个带有树数据结构的 MySQL 表.字段是 _idnameparentId.当记录没有父记录时,parentId 默认为 0.这样我就可以构建一个数组,然后递归打印每条记录.

I have a MySQL table with a tree data structure. The fields are _id, name and parentId. When the record hasn't a parent, parentId defaults as 0. This way I can build an array and then recursively print each record.

构建的数组如下所示:

Array
(
    [1] => Array
        (
            [parentId] => 0
            [name] => Countries
            [_id] => 1
            [children] => Array
                (
                    [2] => Array
                        (
                            [parentId] => 1
                            [name] => America
                            [_id] => 2
                            [children] => Array
                                (
                                    [3] => Array
                                        (
                                            [parentId] => 2
                                            [name] => Canada
                                            [_id] => 3
                                            [children] => Array
                                                (
                                                    [4] => Array
                                                        (
                                                            [parentId] => 3
                                                            [name] => Ottawa
                                                            [_id] => 4
                                                        )

                                                )

                                        )

                                )

                        )

                    [5] => Array
                        (
                            [parentId] => 1
                            [name] => Asia
                            [_id] => 5
                        )

                    [6] => Array
                        (
                            [parentId] => 1
                            [name] => Europe
                            [_id] => 6
                            [children] => Array
                                (
                                    [7] => Array
                                        (
                                            [parentId] => 6
                                            [name] => Italy
                                            [_id] => 7
                                        )

                                    [11] => Array
                                        (
                                            [parentId] => 6
                                            [name] => Germany
                                            [_id] => 11
                                        )

                                    [12] => Array
                                        (
                                            [parentId] => 6
                                            [name] => France
                                            [_id] => 12
                                        )

                                )

                        )

                    [8] => Array
                        (
                            [parentId] => 1
                            [name] => Oceania
                            [_id] => 8
                        )

                )

         )

 )

打印无序列表

    使用递归非常简单.这是我使用的函数:

    Printing an unordered list <ul> is very simple with recursion. Here's the function I use:

    function toUL ($arr) {
    
        $html = '<ul>' . PHP_EOL;
    
        foreach ( $arr as $v ) {
    
            $html.= '<li>' . $v['name'] . '</li>' . PHP_EOL;
    
            if ( array_key_exists('children', $v) ) {
                $html.= toUL($v['children']);
            }
    
        }
    
        $html.= '</ul>' . PHP_EOL;
    
        return $html;
    }
    

    但我一直坚持以树状结构的方式打印 ?

    My question is: is it possible to build a <select> without knowing the depth?

    提前致谢.

    推荐答案

    $pass

    function toUL ($arr, $pass = 0) {
    
        $html = '<ul>' . PHP_EOL;
    
        foreach ( $arr as $v ) {           
    
            $html.= '<li>';
            $html .= str_repeat("--", $pass); // use the $pass value to create the --
            $html .= $v['name'] . '</li>' . PHP_EOL;
    
            if ( array_key_exists('children', $v) ) {
                $html.= toUL($v['children'], $pass+1);
            }
    
        }
    
        $html.= '</ul>' . PHP_EOL;
    
        return $html;
    }
    

相关文章