PHP uses recursive method to achieve unlimited classification and generate drop-down list-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP uses recursive method to achieve unlimited classification and generate drop-down list

Jul 07, 2017 am 09:50 AM

php Classification generate

phpCustom function RecursionImplementationInfinite classificationGenerate drop-down list, this can improve efficiency, and you don’t have to start from The database reads data.

The code is as follows:

/*—————————————————— */
//– 递归实现无限分类生成下拉列表函数 
//– $tpl-&gt;assign(&#39;sort_list&#39;,createSortOptions ()); 
//– $tpl-&gt;assign(&#39;sort_list&#39;,createSortOptions ($sort_id)); 
/*—————————————————— */
function createSortOptions ($selected=0,$parent_id=0,$n=-1) 
{ 
global $db; 
$sql = &quot;SELECT * FROM `@article_sort` WHERE `parent_id` = &#39;{$parent_id}&#39;&quot;; 
$options = &quot;; 
static $i = 0; 
if ($i == 0) 
{ 
$options .= &#39;&lt;option value=&quot;0″ &gt;请选择&lt;/option&gt;&#39;; 
} 
$res = $db-&gt;query ($sql); 
if ($res) 
{ 
$n++; 
while ($row = $db-&gt;fetch_assoc ($res)) 
{ 
$i++; 
$options .=&quot;&lt;option value=&#39;{$row[&#39;sort_id&#39;]}&#39;&quot;; 
if ($row[&#39;sort_id&#39;] == $selected) 
{ 
$options .=&#39; selected &#39;; 
} 
$options .=&quot;&gt;&quot;.str_repeat(&#39; &#39;,$n*3).$row[&#39;sort_name&#39;].&quot;&lt;/option&gt;\n&quot;; 
$options .=createSortOptions ($selected,$row[&#39;sort_id&#39;],$n); 
} 
} 
return $options; 
}

Copy after login

The above is the detailed content of PHP uses recursive method to achieve unlimited classification and generate drop-down list. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn