<?php  
$page_title = 'Dashboard';
include 'header.php';
$agent_id = $userData['id'];
$role = $userData['user_type'];
?>
<div class="content-wrapper">
  <?php include 'breadcrumb.php'; ?>
  <section class="content">
    <div class="container-fluid">
      <div class="row">
          <div class="col-lg-3 col-6">
            <div class="small-box bg-info">
              <div class="inner">
                <?php
                $sel_students = mysqli_query($con,"select * from DimStudent_Table");
                $tot_students = mysqli_num_rows($sel_students);
                ?>
                <h3><?php echo $tot_students; ?></h3>
                <p>Students</p>
              </div>
              <div class="icon">
                <i class="fas fa-user"></i>
              </div>
              <a href="import-data.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
            <div class="small-box bg-info">
              <div class="inner">
                <?php
                $sel_teachers = mysqli_query($con,"select * from DimTeacher_Table");
                $tot_teachers = mysqli_num_rows($sel_teachers);
                ?>
                <h3><?php echo $tot_teachers; ?></h3>
                <p>Teachers</p>
              </div>
              <div class="icon">
                <i class="fas fa-user"></i>
              </div>
              <a href="import-data.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
          <div class="col-lg-3 col-6">
            <div class="small-box bg-info">
              <div class="inner">
                <?php
                $sel_sub = mysqli_query($con,"select * from DimSubject_Table");
                $tot_sub = mysqli_num_rows($sel_sub);
                ?>
                <h3><?php echo $tot_sub; ?></h3>
                <p>Subjects</p>
              </div>
              <div class="icon">
                <i class="fas fa-user"></i>
              </div>
              <a href="import-data.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
            </div>
          </div>
      </div>
    </div>
  </section>
</div>
<?php include 'footer.php'; ?>