PHP HEADER_NAVBAR::get_category_child Examples

Example #1

File: navbar-hillpak.php Project: nickyudha/hillpak-v2

    }
    function get_category_child($level, $parent)
    {
        $sql = "SELECT category_alias, category_name, category_id FROM tbl_category AS cat INNER JOIN tbl_category_relation AS cat_rel ON cat.category_id = cat_rel.category_child\n\t             WHERE cat.category_level = '{$level}' AND cat_rel.category_parent = '{$parent}' AND `category_visibility_status` = '1' ORDER BY category_order LIMIT 1\n\t\t\t\t";
        $query = $this->conn->query($sql);
        if ($results = $query->fetch_object()) {
            return $results;
        }
    }
}
$_navbar = new HEADER_NAVBAR();
$navbar_categories = $_navbar->get_categories('0', 'top');
$a = 0;
$navbar_category_childs = array();
foreach ($navbar_categories as $navbar_category) {
    $navbar_category_childs[$a] = $_navbar->get_category_child('1', $navbar_category->category_id);
    $a++;
}
if (isset($_SESSION['account']['login_id'])) {
    $session_user_id = $_SESSION['account']['login_id'];
} else {
    $session_user_id = 0;
}
$count_wishlist = $_navbar->count_wishlists($session_user_id);
/* --- MINI NAVBAR CART --- */
if (isset($_SESSION['cart_type_id']) && count($_SESSION['cart_type_id']) > 0) {
    $nav_mini_type = $_SESSION['cart_type_id'];
    $nav_mini_stock = $_SESSION['cart_stock_id'];
    $nav_mini_qty = $_SESSION['cart_qty'];
    $class_mini_arrow_up = '';
    $class_mini_arrow_down = '';