<?php
$sql = "SELECT * FROM categories WHERE parent = 0";
$pquery = $db->query($sql);
?>



<header>
  <div class="head1">
    <div class="headtext1">
      <span class="border trans1">
        H.Luxury
      </span>
    </div>

  </div>
</header>

<nav class="navbar navbar-default navbar-expand-xl navbar-light">
  <div class="navbar-header d-flex col">
    <a class="navbar-brand" href="index.php"><i class="fa fa-cube"></i>H<b>Luxury</b></a>
    <button type="button" data-target="#navbarCollapse" data-toggle="collapse" class="navbar-toggle navbar-toggler ml-auto">
      <span class="navbar-toggler-icon"></span>
      <span class="icon-bar"></span>
      <span class="icon-bar"></span>
      <span class="icon-bar"></span>
    </button>
  </div>
  <!-- Collection of nav links, forms, and other content for toggling -->
  <div id="navbarCollapse" class="collapse navbar-collapse justify-content-start">
    <ul class="nav navbar-nav">
      <li class="nav-item active"><a href="luxury.php" class="nav-link"></a></li>

      <?php while($parent = mysqli_fetch_assoc($pquery)) : ?>
        <?php
        $parent_id = $parent['id'];
        $sql2 = "SELECT * FROM categories WHERE parent = $parent_id";
        $cquery = $db->query($sql2);
        ?>

        <!--Menu products--->
        <li class="nav-item dropdown">
          <a data-toggle="dropdown" class="nav-link dropdown-toggle" href="#"> <b class="caret"><?php echo $parent['category']; ?></b></a>
          <ul class="dropdown-menu">
            <?php while($child = mysqli_fetch_assoc($cquery)) : ?>
              <li><a href="#" class="dropdown-item"><?php echo $child['category']; ?></a></li>
            <?php endwhile; ?>

          </ul>
        </li>
      <?php endwhile; ?>

    </ul>
    <form class="navbar-form form-inline">
      <div class="input-group search-box">
        <input type="text" id="search" class="form-control" placeholder="Search by Name">
        <span class="input-group-addon"><i class="material-icons">&#xE8B6;</i></span>
      </div>
    </form>
    <ul class="nav navbar-nav navbar-right ml-auto">
      <li class="nav-item dropdown">
        <a href="#" data-toggle="dropdown" class="nav-link dropdown-toggle user-action"><img src="https://kxiwq67737.i.lithium.com/t5/image/serverpage/avatar-name/default_icon/avatar-theme/candy/avatar-collection/Cisco_Default/avatar-display-size/message/version/2?xdesc=1.0" class="avatar" alt="Avatar"> <b class="caret"></b></a>
        <ul class="dropdown-menu">
          <li><a href="#" class="dropdown-item"><i class="fa fa-sliders"></i> Settings</a></li>
          <li class="divider dropdown-divider"></li>
          <li><a href="logout.php" class="dropdown-item"><i class="material-icons">&#xE8AC;</i> Logout</a></li>
        </ul>
      </li>
    </ul>
  </div>
</nav>