douzi1350 2015-04-26 11:08
浏览 25

删除supersub类别PHP Mysql中的链接

I have a problem with active link that i've created. I want to make the Sub Category doesn't have any link, only the supersub have link for each supersub category.

The example like: 1. painting (category), 1.1 HOBE (sub category), 1.1.1 Sealer, 1.1.2 Wall Paint (supersub category)

The table contain: id_kategori, kategori, id_parent

This is my code:

<?php
include "config.php";

function punya_child($id_kategori = NULL)
{
$result = mysql_query('SELECT COUNT(id_kategori) AS jumlah_child FROM category WHERE id_parent = \''.$id_kategori.'\'');
$data = mysql_fetch_assoc($result);
if($data['jumlah_child'] > 0) return TRUE;    
return FALSE;
}

function hirarki($id_kategori = NULL)
{
   if($id_kategori === NULL)
   {
    $result_top_level = mysql_query('SELECT * FROM category WHERE id_parent IS NULL');        
    if(mysql_num_rows($result_top_level) > 0)
    {
        echo '<ul class="category">';            
        while($row_top_level = mysql_fetch_assoc($result_top_level))
        {
            echo "<li class='category'>", $row_top_level['kategori'];                
            if(punya_child($row_top_level['id_kategori']))
            {
                hirarki($row_top_level['id_kategori']);
            }                
            echo '</li>';
        }            
        echo '</ul>';
    }
}
else
{
    $result_child = mysql_query('SELECT * FROM category WHERE id_parent = \''.$id_kategori.'\'');    
    if(mysql_num_rows($result_child) > 0)
    {
        echo '<ul class="subcategory">';        
        while($row_child = mysql_fetch_assoc($result_child))
        {
            echo "<li><a href='cat.php?kategori=$row_child[kategori]'>", $row_child['kategori'];
            if(punya_child($row_child['id_kategori']))
            {
                hirarki($row_child['id_kategori']);
            }            
            echo '</li>';
        }    
        echo '</ul></a>';
    }
}
}
hirarki();
?>

I really thankful if someone can help me how solve this problem. Thank you

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错
    • ¥15 单片机学习顺序问题!!
    • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
    • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)