<?php  
$page_title = 'Dashboard';
include 'header.php';
?>
<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 students");
              $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-students.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_alumini = mysqli_query($con,"select * from alumini");
              $tot_alumini = mysqli_num_rows($sel_alumini);
              ?>
              <h3><?php echo $tot_alumini; ?></h3>
              <p>Alumini</p>
            </div>
            <div class="icon">
              <i class="fas fa-copy"></i>
            </div>
            <a href="alumini-list.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_alumni_feedback = mysqli_query($con,"select * from alumni_feedback");
              $tot_alumni_feedback = mysqli_num_rows($sel_alumni_feedback);
              ?>
              <h3><?php echo $tot_alumni_feedback; ?></h3>
              <p>Alumini Feedback</p>
            </div>
            <div class="icon">
              <i class="fas fa-copy"></i>
            </div>
            <a href="alumini-list.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_enquiry = mysqli_query($con,"select * from enquiry");
             $tot_enquiry = mysqli_num_rows($sel_enquiry);
             ?>
             <h3><?php echo $tot_enquiry; ?></h3>
             <p>Enquiry</p>
           </div>
           <div class="icon">
            <i class="fas fa-tachometer-alt"></i>
          </div>
          <a href="enquiry.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_events = mysqli_query($con,"select * from events");
            $tot_events = mysqli_num_rows($sel_events);
            ?>
            <h3><?php echo $tot_events; ?></h3>
            <p>Events</p>
          </div>
          <div class="icon">
            <i class="fas fa-tree"></i>
          </div>
          <a href="event-list.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_staff_management = mysqli_query($con,"select * from staff_management");
           $tot_staff_management = mysqli_num_rows($sel_staff_management);
           ?>
           <h3><?php echo $tot_staff_management; ?></h3>
           <p>Staff</p>
         </div>
         <div class="icon">
          <i class="ion ion-person-add"></i>
        </div>
        <a href="staff-management-list.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_committee = mysqli_query($con,"select * from committee");
          $tot_committee = mysqli_num_rows($sel_committee);
          ?>
          <h3><?php echo $tot_committee; ?></h3>
          <p>Committee</p>
        </div>
        <div class="icon">
          <i class="ion ion-pie-graph"></i>
        </div>
        <a href="committee-list.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_students_admission = mysqli_query($con,"select * from students_admission");
          $tot_students_admission = mysqli_num_rows($sel_students_admission);
          ?>
          <h3><?php echo $tot_students_admission; ?></h3>
          <p>Admission Form</p>
        </div>
        <div class="icon">
          <i class="fas fa-university"></i>
        </div>
        <a href="students-admission-list.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_student_feedback = mysqli_query($con,"select * from student_feedback");
          $tot_student_feedback = mysqli_num_rows($sel_student_feedback);
          ?>
          <h3><?php echo $tot_student_feedback; ?></h3>
          <p>Student Feedback</p>
        </div>
        <div class="icon">
          <i class="fas fa-star"></i>
        </div>
        <a href="students-feedback-list.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_Facilities = mysqli_query($con,"select * from facilities");
         $tot_Facilities = mysqli_num_rows($sel_Facilities);
         ?>
         <h3><?php echo $tot_Facilities; ?></h3>
         <p>Facilities</p>
       </div>
       <div class="icon">
        <i class="fas fa-tree"></i>
      </div>
      <a href="facilities-list.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_announcements_news = mysqli_query($con,"select * from announcements_news");
        $tot_announcements_news = mysqli_num_rows($sel_announcements_news);
        ?>
        <h3><?php echo $tot_announcements_news; ?></h3>
        <p>Announcements / News</p>
      </div>
      <div class="icon">
        <i class="fas fa-newspaper"></i>
      </div>
      <a href="announce-news-list.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_Testimonial = mysqli_query($con,"select * from testimonial");
        $tot_Testimonial = mysqli_num_rows($sel_Testimonial);
        ?>
        <h3><?php echo $tot_Testimonial; ?></h3>
        <p>Testimonial</p>
      </div>
      <div class="icon">
        <i class="fas fa-quote-left"></i>
      </div>
      <a href="students-admission-list.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_achievers = mysqli_query($con,"select * from achievers");
        $tot_achievers = mysqli_num_rows($sel_achievers);
        ?>
        <h3><?php echo $tot_achievers; ?></h3>
        <p>Achievers</p>
      </div>
      <div class="icon">
        <i class="fas fa-archive"></i>
      </div>
      <a href="achievers-list.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'; ?>