admin-manage-student.php

<?php require "admin-header.php"; ?>

<div class="container mt-5 pt-5">


<div class="row justify-content-center">

<div class="col-lg-4">

  <nav>
    <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="admin-dashboard.php"><i class="bi bi-house-door"></i></a></li>
        <li class="breadcrumb-item"><a href="#">Approve New Students <i class="bi bi-people" style="font-size: 1.2rem; color: green;"></i></a></li>
                </ol>
  </nav>
       
<div class="card text-center">
            <div class="card-body pt-3">
              <div class="text-center">
              <i class="bi bi-exclamation-circle text-success" style="font-size: 2.5rem;"></i>
              </div>
              <p>Some set of students just registered as students, As the Admin you can Select a Class to verify these students.</p>
      
              <form action="<?= htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post">
              <select name="class" class="form-control form_data">
                            <option value="">Select Student Class</option>
                      <?php
                      $sql = "SELECT class FROM class";
                      $stmt = $conn->prepare($sql);
                      $stmt->execute();
                      $result = $stmt->get_result();
                      if($result->num_rows > 0){
                        while($row = $result->fetch_assoc()){
                          echo '
                          <option value='.$row['class'].'>'.$row['class'].'</option>
                          ';
                        }
                      }
                      ?>
                        </select>
                      </div>

                     <div class="container">

                     <button type="submit" class="btn btn-success form-control mb-4" style="border-radius: 15px;" name="admin-manage-student">Approve New Students</button>
                     </div>
              </form>
         </div>
    </div>

              <?php 
                $error = [];
            if (isset($_POST['admin-manage-student'])) {

              $class = $_POST['class'];

              if(empty($class)){
                $error['class'] = "<div class='text-center py-1 text-danger fs-5 fw-bold'>
                <i class='bi bi-x-circle text-danger' style='font-size: 2.5rem;'></i><br />field cannot be empty</div>";
              }

              if(count($error) === 0){
                $sql = "SELECT * FROM users WHERE admin_verify='0' AND class='$class'";
                $stmt = $conn->prepare($sql);
                $stmt->execute();
                $result = $stmt->get_result();
               if($result->num_rows > 0){
                echo '
                <div class="row justify-content-center">

                <div class="col-lg-4">
                <table class="table table-bordered">
                <thead>
                  <tr>
                    <th scope="col">image</th>
                    <th scope="col">Lastname</th>
                    <th scope="col">Firstname</th>
                    <th scope="col">Action</th>
                  </tr>
                </thead>
                <tbody>
                ';
              while($fetch = $result->fetch_assoc()){
                echo '
                <tr>
                    <td><img style="height: 70px; width: 70px;" src="uploads/'.$fetch['image'].'" class="img-fluid" /></td>
                    <td>'.$fetch['lastname'].'</td>
                    <td>'.$fetch['firstname'].'</td>
                    <td><a href="admin-manage-student-profile.php?student_id='.$fetch['student_id'].'"><i class="bi bi-eye fs-5" style="color: green;"></i></a></td>
                  </tr>
                ';
              }
              echo '
              </tbody>
              </table>
              </div>
              </div>
              ';
              
            }
  
               else{
                $error['class'] = "<div class='text-center py-1 text-danger fs-5 fw-bold'>
                <i class='bi bi-person-x-fill text-danger' style='font-size: 2.5rem;'></i><br />No New Student</div>";
              }
            }
          }
        

?>
<div class="text-danger text-center mb-3">
  <?php
                        if(isset($error['class'])){
                          echo $error['class'];
                        }
                        ?>
  </div>

</div>
</div>
</div>

                           

<?php require "main-footer.php"; ?>