<h3> <p>In this section you're allowed to view,</p> <p>The Attendance status of students,</p> <p>From the Navigation Bar in the left side, Select the required subject.</p> <p>Based on the subject choosen,you can see the attendance status table.</p> </h3> <!--PHP--> <?php } ?> <hr> <?php if (isset($cur_dep) && isset($cur_sem) && isset($cur_sub)) { $subje = select_all_sub($cur_dep, $cur_sem); $hap = retrive_happned($cur_dep, $cur_sem, $cur_sub); while ($totalclasses = mysqli_fetch_assoc($hap)) { ?> <button type="button" class="btn btn-warning"> <?php echo "HELD " . $totalclasses["count(DISTINCT t)"]; ?> </button> <!--PHP--> <?php } $st = select_all_student($cur_dep, $cur_sem); ?> <h2 class="page-header">Attendance status are as follows...</h2> <table class="table table-bordered"> <tr> <th> USN </th>
<tbody> <?php $sublist = select_all_sub($cur_dep, $cur_sem); while ($subj = mysqli_fetch_assoc($sublist)) { ?> <tr> <td> <?php echo $subj["Suid"]; ?> </td> <td><?php echo $subj["Su_name"]; ?> </td> <td> <?php $i = retrive_happned($cur_dep, $cur_sem, $subj["Suid"]); $j = mysqli_fetch_assoc($i); echo $j["count(DISTINCT t)"]; ?> </td> <td><?php $i = retrive_attend($cur_usn, $cur_sem, $subj["Suid"]); $j = mysqli_fetch_assoc($i); echo $j["count(t)"]; ?> </td> </tr> <?php } ?> </tbody>