{"id":339,"date":"2013-11-29T15:26:08","date_gmt":"2013-11-29T07:26:08","guid":{"rendered":"http:\/\/www.zyuns.com\/?p=339"},"modified":"2015-10-22T15:27:55","modified_gmt":"2015-10-22T07:27:55","slug":"php-di-gui-shi-xian-ceng-ji-shu-zhuang-zhan-xian-shu-ju","status":"publish","type":"post","link":"https:\/\/www.siediyer.cn\/?p=339","title":{"rendered":"PHP \u9012\u5f52\u5b9e\u73b0\u5c42\u7ea7\u6811\u72b6\u5c55\u73b0\u6570\u636e"},"content":{"rendered":"<pre class=\"lang:default decode:true \">&lt;?php\n\n$db = mysql_connect('localhost', 'root', 'root') or die('Can't connect to database');\nmysql_select_db('test') or die('Can't find database : test');\n$result = mysql_query('select id, fid, name from tree');\nwhile($arr = mysql_fetch_array($result)){\n    $data[] = array(\n        'id' =&gt; $arr['id'],\n        'fid' =&gt; $arr['fid'],\n        'name' =&gt; $arr['name'],\n    );\n}\n\n\/\/ \u5c06\u6570\u636e\u6309\u7167\u7f29\u8fdb\u7b80\u5355\u6392\u5217 \u89c1\u56fe1\nfunction data2arr($tree, $rootId = 0, $level = 0) {\n    foreach($tree as $leaf) {\n        if($leaf['fid'] == $rootId) {\n            echo str_repeat('&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;', $level) . $leaf['id'] . ' ' . $leaf['name'] . '&lt;br\/&gt;';\n            foreach($tree as $l) {\n                if($l['fid'] == $leaf['id']) {\n                    data2arr($tree, $leaf['id'], $level + 1);\n                    break;\n                }\n            }\n        }\n    }\n}\n\ndata2arr($data);\necho '&lt;br\/&gt;-----------------------------------------------------------------------&lt;br\/&gt;';\n\n\/\/ \u5c06\u6570\u636e\u6309\u7167\u6240\u5c5e\u5173\u7cfb\u5c01\u88c5 \u89c1\u56fe2\nfunction arr2tree($tree, $rootId = 0) {\n    $return = array();\n    foreach($tree as $leaf) {\n        if($leaf['fid'] == $rootId) {\n            foreach($tree as $subleaf) {\n                if($subleaf['fid'] == $leaf['id']) {\n                    $leaf['children'] = arr2tree($tree, $leaf['id']);\n                    break;\n                }\n            }\n            $return[] = $leaf;\n        }\n    }\n    return $return;\n}\n\n$tree = arr2tree($data);\nprint_r($tree);\necho '&lt;br\/&gt;-----------------------------------------------------------------------&lt;br\/&gt;';\n\n\/\/ \u5c06\u6570\u636e\u4f7f\u7528HTML\u518d\u6b21\u5c55\u73b0 \u89c1\u56fe3\nfunction tree2html($tree) {\n    echo '&lt;ul&gt;';\n    foreach($tree as $leaf) {\n        echo '&lt;li&gt;' .$leaf['name'];\n        if(! empty($leaf['children'])) tree2html($leaf['children']);\n        echo '&lt;\/li&gt;';\n    }\n    echo '&lt;\/ul&gt;';\n}\n\ntree2html($tree);<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u56fe 1\uff1a<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-665\" src=\"http:\/\/www.siediyer.cn\/wp-content\/uploads\/2015\/10\/f472e607-6535-3c50-9160-bcda27c38902.png\" width=\"189\" height=\"358\" alt=\"\" srcset=\"https:\/\/qiniu.shijitianchen.com\/2015\/10\/f472e607-6535-3c50-9160-bcda27c38902.png 189w, https:\/\/qiniu.shijitianchen.com\/2015\/10\/f472e607-6535-3c50-9160-bcda27c38902-158x300.png 158w\" sizes=\"auto, (max-width: 189px) 100vw, 189px\" \/><\/p>\n<p><strong>\u56fe 2\uff1a<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-666\" src=\"http:\/\/www.siediyer.cn\/wp-content\/uploads\/2015\/10\/0e9a969c-3c23-3707-83bd-dd4fd6d673fe.png\" width=\"400\" height=\"657\" alt=\"\" srcset=\"https:\/\/qiniu.shijitianchen.com\/2015\/10\/0e9a969c-3c23-3707-83bd-dd4fd6d673fe.png 400w, https:\/\/qiniu.shijitianchen.com\/2015\/10\/0e9a969c-3c23-3707-83bd-dd4fd6d673fe-183x300.png 183w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><br \/>\n<strong>\u56fe 3\uff1a<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-667\" src=\"http:\/\/www.siediyer.cn\/wp-content\/uploads\/2015\/10\/465c069c-3b15-3a7d-8146-d4cba79c0f86.png\" width=\"265\" height=\"356\" alt=\"\" srcset=\"https:\/\/qiniu.shijitianchen.com\/2015\/10\/465c069c-3b15-3a7d-8146-d4cba79c0f86.png 265w, https:\/\/qiniu.shijitianchen.com\/2015\/10\/465c069c-3b15-3a7d-8146-d4cba79c0f86-223x300.png 223w\" sizes=\"auto, (max-width: 265px) 100vw, 265px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&lt;?php $db = mysql_connect(&#8216;localhost&#8217;, &#8216;root&#8217;, &#8216;root [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-339","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=339"}],"version-history":[{"count":2,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions"}],"predecessor-version":[{"id":668,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/339\/revisions\/668"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/media\/665"}],"wp:attachment":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}