students.php

<?php 

   if (!isset($_SESSION)) {
      session_start();
   }

   // checks if loggedin

   if (!isset($_SESSION['email'])) {
      header('location: login.php');
   }

    require_once 'partials/header.php';

    $limit = 10;
    $page = isset($_GET['page']) ? $_GET['page'] : 1;
    $start = ($page - 1) * $limit;
    $sql = "SELECT * FROM students LIMIT " . $start . " , " . $limit;
    $results = $conn->query($sql) or die($conn->error);
    $students = $results->fetch_all(MYSQLI_ASSOC);

    $total = $results->num_rows;

   //  count students

   $sqlCount = "SELECT count(student_id) AS id FROM students";
   $results1 = $conn->query($sqlCount) or die($conn->error);
   $studentCount = $results1->fetch_all(MYSQLI_ASSOC);
   $totalStudents = $studentCount[0]['id'];

   $pages = ceil($totalStudents / $limit);

   $previous = $page - 1;
   $next = $page + 1;

?>

<?php require 'partials/innerNav.php'; ?>

<main class="sub-pages">
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="inner-hero">
                <img src="dist/images/reading.jpg" alt="bonding">
            </div>
        </div>
    </div>
</div>

<!-- table -->

<div class="container student-record">
   <div class="row">
      <div class="col-12 record-data">
         <!-- Checks if user is admin -->
      <?php if (isset($_SESSION['user_type']) && $_SESSION['user_type'] == 1) : ?>
         <div class="record-container">
            <form action="search.php" method="get" class="searchForm">
               <input type="text" class="form-control" name="search" id="searchInput" />
               <button class="btn btn-primary custom-button">Search</button>
            </form>
         </div>
         <?php endif; ?>
           
      <!-- Checks if there is content -->
      <?php if ($total > 0) : ?>

      <table>
         <thead>
            <tr>
               <th scope="col">Full Name</th>
               <th scope="col">Last Name</th>
               <th scope="col">Email</th>
               <th scope="col">Gender</th>
               <?php if (isset($_SESSION['user_type']) && $_SESSION['user_type'] == 1) : ?>
                  <th scope="col"></th>
               <?php endif; ?>
            </tr>
         </thead>
         <tbody>
            <?php foreach ($students as $student) :?>
            <tr>
               <td data-label="Full Name"><?= $student['full_name']; ?></td>
               <td data-label="Last Name"><?= $student['last_name']; ?></td>
               <td data-label="Email"><?= $student['email']; ?></td>
               <td data-label="Gender"><?= $student['gender']; ?></td>
               <?php if (isset($_SESSION['user_type']) && $_SESSION['user_type'] == 1) : ?>
                  <td><a href="view_details.php?stud_id=<?= $student['student_id']; ?>" class="btn btn-link view-record">View</a></td>
               <?php endif; ?>
            </tr>
            <?php endforeach; ?>
         </tbody>
      </table>
      
      <?php else : ?>
         <div class="no-record">
            <h2>No Record Found.</h2>
            <p>Let's try add one!</p>
         </div>
      <?php endif; ?>
      </div>
   </div>

   <!-- Pagination -->

<nav aria-label="Page navigation">
  <ul class="pagination">
    <li class="page-item">
      <?php if ($page > 1) : ?>
      <a class="page-link" href="<?= "students.php?page=$previous"; ?>" aria-label="Previous">
        <span aria-hidden="true">&laquo;</span>
      </a>
      <?php else : ?>
      <a class="page-link disabled-button" href="#" aria-label="Previous">
        <span aria-hidden="true">&laquo;</span>
      </a>
      <?php endif; ?>
    </li>
    <?php for($i = 1; $i <= $pages; $i++) : ?>
      <li class="page-item"><a class="page-link" href="<?= "students.php?page=$i"; ?>"><?= $i; ?></a></li>
    <?php endfor; ?>
    <li class="page-item">
    <?php if ($page < $pages) : ?>
      <a class="page-link" href="<?= "students.php?page=$next"; ?>" aria-label="Next">
        <span aria-hidden="true">&raquo;</span>
      </a>
   <?php else : ?>
      <a class="page-link disabled-button" href="#" aria-label="Next">
        <span aria-hidden="true">&raquo;</span>
      </a>
   <?php endif; ?>
    </li>
  </ul>
</nav>

</div>
</div>

</main>

<?php
    require_once 'partials/footer.php';
?>