while ($results = $query->fetch_object()) { array_push($row, $results); } return $row; } 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'];