|
Server IP : 86.38.243.181 / Your IP : 216.73.216.51 Web Server : LiteSpeed System : Linux in-mum-web1336.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u986601745 ( 986601745) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u986601745/domains/emrskalsi.com/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!DOCTYPE html>
<html lang="en" style="overflow-x: hidden;">
<head>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Eklavya Model Residential School - Student Strength</title>
<?php include('include/header.php'); ?>
<div class="breadcrumbs">
<div class="container">
<!-- <h1 class="pull-left">
Student Strength</h1> -->
<ul class="pull-left breadcrumb">
<li><a href="javascript:void(0)">Academics</a></li>
<li><a href="javascript:void(0)">Student Strength</a></li>
</ul>
</div>
</div>
</div>
<style>.menshow{display:block !important}
.table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td {
vertical-align: middle!important;
}
tfoot {
background: #ff0000;
color: #fff;
}
thead th ,tfoot th{
text-align: center;
}
</style>
</div></div><div class="container-fluid" id="pr">
<div class="row tbres">
<div class="col-xs-12 col-md-12 col-lg-12 col-sm-12 table-responsive" ><div class="ap-section ">
<div class="ap-plain" >
<div >
<section id="backstre1">
<div class="table-responsive container">
<div class="headline" id="headlines">
<h2>CLASS-WISE STRENGTH FOR SESSION (<?php echo date('Y') ?>-<?php echo date('y')+1 ?>)</h2>
</div>
<table class="table table-bordered" border="1" cellspacing="0">
<thead>
<tr>
<th rowspan="2">S.NO.</th>
<th rowspan="2">Class</th>
<th rowspan="2">Name Of Class Teacher</th>
<th rowspan="2">Name Of Class Monitor</th>
<th colspan="2">Total Strength Of Students</th>
<th rowspan="2">Grand Total</th>
</tr>
<tr>
<th>Boys</th>
<th>Girts</th>
</tr>
</thead>
<tbody>
<?php
$q = "select student_strength.*,staff.name,class.class_name from student_strength left join staff on staff.id=student_strength.staff_id left join class on class.id=student_strength.class_id";
$query = mysqli_query($conn,$q);
$i=1;
$total_boys=0;
$total_girls=0;
$grand_total=0;
while($res = mysqli_fetch_array($query)) {
$total=$res['boys']+$res['girls'];
$grand_total+=intval($res['boys'])+intval($res['girls']);
$total_boys+=intval($res['boys']);
$total_girls+=intval($res['girls']);
?>
<tr>
<td rowspan="2"><?php echo $i++; ?></td>
<td rowspan="2"><?php echo $res['class_name'] ?></td>
<td rowspan="2"><?php echo $res['name'] ?></td>
<td ><?php echo $res['girls_monitor'] ?></td>
<td rowspan="2"><?php echo $res['boys'] ?></td>
<td rowspan="2"><?php echo $res['girls'] ?></td>
<td rowspan="2"><?php echo $total; ?></td>
</tr>
<tr>
<td><?php echo $res['boys_monitor'] ?></td>
</tr>
<?php } ?>
</tbody>
<tfoot>
<tr>
<th colspan="4">Total</th>
<th><?php echo $total_boys; ?></th>
<th><?php echo $total_girls; ?></th>
<th><?php echo $grand_total; ?></th>
</tr>
</tfoot>
</table>
<p> </p>
</div>
</section></div>
</div>
</div></div></div>
</div>
<?php include('include/footer.php'); ?>