创建动态PHP / HTML类别树

Question

我已经知道如何使用ul > li结构来获取每个父/子类，但是现在我被卡住了，子类别ul需要一个类'dropdown‘，但是不能解决这个问题。

我的目标是创建一个具有Foundation导航标记的无限动态ul菜单。

PHP

function fetchCategoryTreeList($parent = 0, $user_tree_array = '') {

$isParent = '';

if (!is_array($user_tree_array))
$user_tree_array = array();

$sql = "SELECT id,name,parent FROM `categories` WHERE 1 AND parent=$parent ORDER BY id ASC" or die(mysql_error);

if (database_querySelect($sql,$rows)) {

    $user_tree_array[] = "<ul>";

        foreach ($rows as $row) {

            if ($row["parent"] == "0") { $isParent = "has-dropdown"; } 

            $user_tree_array[] = "<li class='".$isParent."'>". $row["name"]. "</li>";

            $user_tree_array = fetchCategoryTreeList($row["id"], $user_tree_array);

        }

    $user_tree_array[] = "</ul>";   

}

  return $user_tree_array;

显示cat的代码

 <?php
  $res = fetchCategoryTreeList();
    foreach ($res as $r) {
      echo $r;
    }
  ?>

输出

<ul>
  <li class='has-dropdown'>Golf Equipment</li>

    <ul>
        <li class=''>Manual Golf Trolleys</li>
        <li class=''>Electric Golf Trolleys</li>
    </ul>

  <li class='has-dropdown'>Weight Training</li>

    <ul>
        <li class=''>Weight Benches</li>
        <li class=''>Weights</li>
    </ul>
  </li>
</ul>

Answer 1

我希望能帮上忙..我不知道(需要一个类'dropdown')做什么……您可以给main ul一个类

$user_tree_array[] = "<ul  class='main_ul'>";

然后，您可以在css和jquery中使用选择器

 .main_ul .has-dropdown ul {
}

Answer 2

功能：

<?php

    function fetchCategoryTreeList( $parent = 0, $user_tree_array = "" ) {

        if ( ! is_array($user_tree_array))
            $user_tree_array = array();


        $sql  = "SELECT id,name,parent ";
        $sql .= "FROM `categories` ";
        $sql .= "WHERE 1 AND parent = {$parent} ";
        $sql .= "ORDER BY id ASC";

        if ( database_querySelect( $sql, $rows) )
        {

            foreach ( $rows as $row ) 
            {

                $user_tree_array[] = "<li class='' >{$row["name"]}</li>";

                if ( $parent != $row["id"] )
                {

                    $user_tree_array[] = "<ul>";

                    $user_tree_array = fetchCategoryTreeList( $connection, $row["id"], $user_tree_array );

                    $user_tree_array[] = "</ul>";

                }
                else
                { 

                    $user_tree_array = fetchCategoryTreeList( $row["id"], $user_tree_array );               

                }

            }

        }

        return $user_tree_array;

    }

?>

呼叫：

<?php

    $arrays = fetchCategoryTreeList();

    foreach ( $arrays as $list) 
    {
        echo $list;
    }

?>