如何修改代码类别 ul li 形成这些代码 - How to modify code category ul li form these code?

How to modify code category ul li form these code?

本文关键字：代码 li ul 何修改修改 | 更新日期: 2023-09-27

function display_children_category($parent, $level) { 
    $db = new My_sqli();    
    $result ="SELECT parent.product_category_id, parent.product_category_name, parent.product_category_level, count(product.product_name) AS sum_products FROM product_category AS node JOIN product_category AS parent ON node.product_category_lft BETWEEN parent.product_category_lft AND parent.product_category_rgt LEFT JOIN product ON node.product_category_id = product.product_category_id WHERE parent.product_category_parent='$parent' GROUP BY parent.product_category_name, parent.product_category_level ORDER BY node.product_category_lft";
    // display each child 
    $num = $db->get_results($result);
    foreach($num as $row){
             echo "<li>".str_repeat('',$level).$row['product_category_name']."( ".$row['sum_products']." ชิ้น)</li>"; 
             display_children_category($row['product_category_id'], $level+1); 
    }   
}

如何修改代码类别 ul li 形成这些代码？请帮助我。

我想要类别菜单

<ul>  
    <li>test</li>  
    <li>test2</li>  
    <li>test3
        <ul>
            <li>subtest3-1</li>
            <li>subtest3-2</li>
        </ul> 
    </li> 
</ul>

不要直接回显，而是使用包含 li 的字符串

function display_children_category($parent, $level) { 
    $db = new My_sqli();    
    $result ="SELECT parent.product_category_id, parent.product_category_name, parent.product_category_level, count(product.product_name) AS sum_products FROM product_category AS node JOIN product_category AS parent ON node.product_category_lft BETWEEN parent.product_category_lft AND parent.product_category_rgt LEFT JOIN product ON node.product_category_id = product.product_category_id WHERE parent.product_category_parent='$parent' GROUP BY parent.product_category_name, parent.product_category_level ORDER BY node.product_category_lft";
    // display each child 
    $num = $db->get_results($result);
    $str = '';
    foreach($num as $row){
             $str .= "<li>".str_repeat('',$level).$row['product_category_name']."( ".$row['sum_products']." ชิ้น)"; 
             $str .= display_children_category($row['product_category_id'], $level+1); 
             $str .= "</li>";
    }
    return ($str) ? "<ul>".$str."</ul>" : "";

}

然后，当您在外部脚本中调用该函数时：

echo display_children_category($param1,$param2);