navbar.php

<!-- Navbar -->
<nav class="main-header navbar navbar-expand bg-white navbar-light border-bottom">

  <ul class="navbar-nav">
    <li class="nav-item">
      <a class="nav-link" data-widget="pushmenu" href="#"><i class="fa fa-bars"></i></a>
    </li>
  </ul>

  <!-- Right navbar links -->
  <ul class="navbar-nav ml-auto">
    <!-- Notifications Dropdown Menu -->
    <li class="nav-item dropdown">
      <a class="nav-link" data-toggle="dropdown" href="#">
        <i class="fa fa-users"></i>
        <!-- <span class="badge badge-warning navbar-badge">New</span> -->
      </a>
      <div class="dropdown-menu dropdown-menu-lg dropdown-menu-right">
        <span class="dropdown-item dropdown-header">Welcome, <?php echo("{$_SESSION['name']}") ;?></span>
        <div class="dropdown-divider"></div>
        <a href="library.php" class="dropdown-item">
          <i class="fa fa-book mr-2"></i>My Library
          <span class="float-right text-muted text-sm"><?php
          $db = new mysqli("localhost", "root", "", "libraryku");
          $sql = mysqli_query($db, "SELECT count(*) as `count` FROM `library` WHERE `user_id` = '$_SESSION[id]'");
          $row = mysqli_fetch_assoc($sql);
          echo $row['count'];
          ?>
          books</span>
        </a>
        <div class="dropdown-divider"></div>
        <a href="logout.php" class="dropdown-item dropdown-footer" onclick="event.preventDefault();
                      document.getElementById('logout-form').submit();">LOGOUT</a>
        <form method="POST" action="logout.php" style="display: none;" id="logout-form"></form>
      </div>
    </li>
  </ul>
</nav>
<!-- /.navbar -->