<?php
$link_sql=db_query("select * from tbl_site_pages where 1 and site_pages_status='Active' and site_pages_show_in_header='Yes' order by site_pages_order_by asc limit 0,7");
if(mysqli_num_rows($link_sql)>0){
?>

<div class="header-nav navbar-collapse collapse">
  <ul class=" nav navbar-nav">
    <?php 
while($link_data=mysqli_fetch_array($link_sql)){
$pgName=$link_data['site_pages_link'];
?>
    <?php if($pgName=='index'){ ?>
    <li <?php if($page_name==$link_data['site_pages_link']){?> class="active"<?php }?>><a href="<?=$site_url?>/<?=$link_data['site_pages_link']?>.html">
      <?=$link_data['site_pages_name']?>
      </a></li>
    <?php }elseif($pgName=='products'){ ?>
    <li class="hidden-md hidden-sm hidden-lg <?php if($page_name==$link_data['site_pages_link']){?>active<?php }?>"> <a href="<?=$site_url?>/products.html">
      <?=$link_data['site_pages_name']?>
      </a>
    <li class="hidden-xs <?php if($page_name==$link_data['site_pages_link']){?>active<?php }?>"> <a href="<?=$site_url?>/products.html">
      <?=$link_data['site_pages_name']?>
      <i class="fa fa-chevron-down"></i></a>
      <ul class="sub-menu">
        <?php
            function fetch_header_menu($query) {
            $site_url=db_scalar("select admin_website_url from tbl_admin where 1");
            	while ( $result = mysqli_fetch_array ( $query ) ) {
            		$menu_id = $result ['category_id'];
            		$menu_name = ucwords(strtolower($result ['category_name']));
            		$menu_cat_link = $result ['category_url'];
            		if (has_child ( query ( $menu_id ) )) {
            			$menuClass = "sub-menu";
            		}else{
            		   $menuClass = "";
            		}
             	  echo "<li ><a href='$site_url/{$menu_cat_link}.html'>{$menu_name}</a>";
            		if (has_child ( query ( $menu_id ) )) {
            			echo "<ul class='{$menuClass}'>";
            			fetch_header_menu ( query ( $menu_id ) );
            			echo "</ul>";
            		}
            		echo "</li>";
            	}
            }
            fetch_header_menu (query(0));
        ?>
      </ul>
    </li>
    <?php }else{ ?>
    <li <?php if($page_name==$link_data['site_pages_link']){?> class="active"<?php }?>><a href="<?=$site_url?>/<?=$link_data['site_pages_link']?>.html">
      <?=$link_data['site_pages_name']?>
      </a></li>
    <? }} ?>
  </ul>
</div>
<? } ?>