<?php
    include 'connection.php';
    $query = mysqli_query($con,'SELECT * FROM category_type');
    $menu = '';
    $x;
    $display = "";
    $x = 1;
    $submenu ="";
    while ($row = mysqli_fetch_array($query)) {
        $sql = mysqli_query($con,'SELECT * FROM product_category WHERE ct_id = "'.$row["id"].'"');
        if(mysqli_num_rows($sql) > 0){
            while($data = mysqli_fetch_array($sql)){
                $submenu .= '<a href="products.php?product='.$row["slug"].'&sub-cat='.$data["slug"].'" class="list-group-item list-group-item-action">'.$data['c_name'].'</a>';
            }
        }
        if(mysqli_num_rows($sql) > 0){
            $menu .= '<div class="list-group-collapse sub-men">
                        <a class="list-group-item list-group-item-action" href="products.php?product='.$row["slug"].'" aria-expanded="true" aria-controls="sub-men'.$x.'">'.$row["category_type"].'</small>
                        </a>
                        <div class="collapse show" id="sub-men'.$x.'" data-parent="#list-group-men">
                            <div class="list-group">
                                '.$submenu.'
                            </div>
                        </div>
                    </div>';
        }
        else{
            $menu .= '<a href="products.php?product='.$row["slug"].'" class="list-group-item list-group-item-action">'.$row["category_type"].'</small></a>';
        }
        $x++;
        $submenu ='';
    }

?>
<div class="product-categori">
    <div class="filter-sidebar-left">
        <div class="title-left">
            <h3>Categories</h3>
        </div>
        <div class="list-group list-group-collapse list-group-sm list-group-tree" id="list-group-men" data-children=".sub-men">
            <?php echo $menu; ?>
        </div>
    </div>
</div>