sidebar2.php

<?php 
@session_start();
$uid=$_SESSION['login_admin'];
include 'db2.php';
$rol=mysqli_query($con,"SELECT * FROM role_db WHERE role_id='$uid'");
?>
<aside class="main-sidebar sidebar-dark-primary elevation-4">
    <!-- Brand Logo -->
    <a href="dealer_dashboard.php" class="brand-link">
      <img src="dist/img/AdminLTELogo.png" alt="BRS Logo" class="brand-image img-circle elevation-3" style="opacity: .8">
      <span class="brand-text font-weight-light">BRS Dealer</span>
    </a>

    <!-- Sidebar -->
    <div class="sidebar">
      <!-- Sidebar user panel (optional) -->
      <div class="user-panel mt-3 pb-3 mb-3 d-flex">
        <div class="image">
          <img src="dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
        </div>
        <?php while($p=mysqli_fetch_assoc($rol)){ ?>
        <div class="info">
          <a href="#" class="d-block"><?php echo $p['uname'];?></a>
        </div>
        <?php } ?>
      </div>

      <!-- Sidebar Menu -->
      <nav class="mt-2">
        <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
          <!-- Add icons to the links using the .nav-icon class
               with font-awesome or any other icon font library -->
              <li class="nav-item">
                <a href="dealer_dashboard.php" class="nav-link active">
                  <i class="far fa-circle nav-icon"></i>
                  <p>Dashboard</p>
                </a>
              </li>
          <li class="nav-item">
            <a href="add_books.php" class="nav-link">
              <i class="nav-icon fas fa-edit"></i>
              <p>
                Add Books
              </p>
            </a>
          </li>
          <li class="nav-item">
            <a href="manage_orders.php" class="nav-link">
              <i class="nav-icon fas fa-table"></i>
              <p>
                Manage Orders
              </p>
            </a>
          </li>
          <li class="nav-item">
            <a href="Logout.php" class="nav-link">
              <i class="nav-icon fas fa-reply"></i>
              <p>
                Logout
              </p>
            </a>
          </li>
        </ul>
      </nav>
      <!-- /.sidebar-menu -->
    </div>
    <!-- /.sidebar -->
  </aside>