MMCT TEAM
1Server IP : 2a02:4780:11:1776:0:2637:29db:10  /  Your IP : 216.73.217.24
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-captain.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">
  <title>Eklavya Model Residential School - House Captain</title>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
<?php include('include/header.php'); ?>

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

    <!--    <h1 class="pull-left">
    Class Teacher</h1> -->

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

</div></div><section class="cls_teachers" id="pr">
    <div class="container-fluid row"><div class="col-xs-12" ><div class="ap-section ">
      <div class="headline" id="headlines"><h2 >STUDENT PORTFOLIO (<?php echo date('Y') ?>-<?php echo date('y')+1; ?>)</h2>
      </div>

      <div class="ap-plain" >    
        <div class="table-responsive">
            <table class="table table-hover table-bordered table-striped text-center">
                        <thead>

                    <tr>
                        <th>S.No.</th>
                        <th>Name of the House</th>
                        <th colspan="2">House captain</th>
                        <th colspan="2">House Perfacts</th>
                        <th colspan="3">Strength Of House</th>
                    </tr>
                    <tr>
                        <th></th>
                        <th></th>
                        <th>Boys</th>
                        <th>Girls</th>
                        <th>Boys</th>
                        <th>Girls</th>
                        <th>Boys</th>
                        <th>Girls</th>
                        <th>Total</th>
                    </tr>
                </thead>
                    <?php
                    $grand_total=0;
                    $total_boys=0;
                    $total_girls=0;
                    $q = "select house_captain.*,house.house_name from house_captain left join house on house.id=house_captain.house_id";
                    $query = mysqli_query($conn,$q);
                    $i=1;
                    while($res = mysqli_fetch_array($query)) {
                        $total=$res['total_boys']+$res['total_girls'];
                        $grand_total+=$res['total_boys']+$res['total_girls'];
                        $total_boys+=$res['total_boys'];
                        $total_girls+=$res['total_girls'];
                        $boys_perfacts=explode(',', $res['boys_perfacts']);
                        $girls_perfacts=explode(',', $res['girls_perfacts']);
                     ?>
                        <tr>
                            <td><?php echo $i++; ?></td>
                            <td><?php echo $res['house_name'] ?></td>
                            <td><?php echo $res['boys_captain'] ?></td>
                            <td ><?php echo $res['girls_captain'] ?></td>
                            <td style="padding-left: 0!important;padding-right: 0!important;"><?php
                                foreach($boys_perfacts as $boys){ ?>
                                    <p class="perfacts"><?php echo $boys; ?></p>

                                 <?php } ?></td>
                            <td style="padding-left: 0!important;padding-right: 0!important;"><?php
                                foreach($girls_perfacts as $girls){ ?>
                                    <p class="perfacts"><?php echo $girls; ?></p>

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


                    </tr>
                <?php } ?>

                <tfoot>
                    <tr>
                        <th colspan="6" style="text-align:right;">GRAND TOTAL</th>
                        <th><?php echo $total_boys; ?></th>
                        <th><?php echo $total_girls; ?></th>
                        <th><?php echo $grand_total; ?></th>
                    </tr>
                </tfoot>

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

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

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

MMCT - 2023