|
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 ] |
|---|
<?php
$session=$_POST['session'];
$board=$_POST['board'];
error_reporting(0);
include('../link/databaseconnection.php');
session_start();
$lg=$_SESSION['admin'];
$sel="select * from six_eightresult where session='$session' and mediam='$board' and class='FIRST'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$exam=$row['name'];
$sel1="select * from six_eightresult where session='$session' and mediam='$board' and class='SIXTH' and exam='FIRST TERM EXAM'OR session='$session' and mediam='$board' and class='SEVENTH' and exam='FIRST TERM EXAM' OR session='$session' and mediam='$board' and class='EIGHTH' and exam='FIRST TERM EXAM' ";
$res1=mysqli_query($conn,$sel1);
$sel2="select * from six_eightresult where session='$session' and mediam='$board' and class='SIXTH' and exam='SECOND TERM EXAM' OR session='$session' and mediam='$board' and class='SEVENTH' and exam='SECOND TERM EXAM' session='$session' and mediam='$board' and class='EIGHTH' and exam='SECOND TERM EXAM' ";
$res2=mysqli_query($conn,$sel2);
$sel21="select * from six_eightresult where session='$session' and mediam='$board' and class='SIXTH' and exam='THIRD TERM EXAM' OR session='$session' and mediam='$board' and class='SEVENTH' and exam='THIRD TERM EXAM'session='$session' and mediam='$board' and class='EIGHTH' and exam='FIRST TERM EXAM' ";
$res21=mysqli_query($conn,$sel21);
$sel3="select *from registration where mediam='$board' and subject='FIRST' ";
$res3=mysqli_query($conn,$sel3);
$row3=mysqli_fetch_array($res3,MYSQLI_BOTH);
$rol=$row3['application'];
?>
<html>
<head>
<link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
<script src="//code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<style>
#header
{
height:70px;
background-color:red;
width:495px;
}
#logo
{
height:70px;
background-color:green;
width:70px;
float-left;
}
#name
{
height:70px;
background-color:yellow;
width:420px;
float-left;
}
</style>
<style type="text/css" media="print">
@page
{
size: A4; /* auto is the initial value */
margin: 6mm; /* this affects the margin in the printer settings */
}
@media print {
jk {position:relative;}
}
</style>
</head>
<body>
<?php
////FOR THIRD///
/////
///// FOR SECOND
while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
{
if($row2['mark1']=='A'){'0';}else{$row2['mark1'] ;}
if($row2['mark2']=='A'){'0';}else{$row2['mark2'] ;}
if($row2['mark3']=='A'){'0';}else{$row2['mark3'] ;}
if($row2['mark4']=='A'){'0';}else{$row2['mark4'] ;}
if($row2['mark5']=='A'){'0';}else{$row2['mark5'] ;}
if($row2['mark10']=='A'){'0';}else{$row2['mark10'] ;}
if($row2['mark6']=='A'){'0';}else{$row2['mark6'] ;}
if($row2['mark8']=='A'){'0';}else{$row2['mark8'] ;}
if($row2['mark9']=='A'){'0';}else{$row2['mark9'] ;}
if($row2['mark11']=='A'){'0';}else{$row2['mark11'] ;}
$marktotal2=$row2['mark1']+$row2['mark2']+$row2['mark3']+$row2['mark4']+$row2['mark5']+$row2['mark10']+$row2['mark6']+$row2['mark8']+$row2['mark9']+$row2['mark11'];
$per2=$marktotal2/0.9;
$per2=$per2*100;
}
$s=2017;
$r=1;
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
if($row1['mark1']=='A'){'0';}else{$row1['mark1'] ;}
if($row1['mark2']=='A'){'0';}else{$row1['mark2'] ;}
if($row1['mark3']=='A'){'0';}else{$row1['mark3'] ;}
if($row1['mark4']=='A'){'0';}else{$row1['mark4'] ;}
if($row1['mark5']=='A'){'0';}else{$row1['mark5'] ;}
if($row1['mark10']=='A'){'0';}else{$row1['mark10'] ;}
if($row1['mark6']=='A'){'0';}else{$row1['mark6'] ;}
if($row1['mark8']=='A'){'0';}else{$row1['mark8'] ;}
if($row1['mark9']=='A'){'0';}else{$row1['mark9'] ;}
if($row1['mark11']=='A'){'0';}else{$row1['mark11'] ;}
$marktotal=$row1['mark1']+$row1['mark2']+$row1['mark3']+$row1['mark4']+$row1['mark5']+$row1['mark10']+$row1['mark6']+$row1['mark8']+$row1['mark9']+$row1['mark11'];
$per1=$marktotal/1;
$per=$per1*100;
$rol1=$row1['rol'];
//echo $marktotal;
///// FOR SECOND
$sel21="select * from six_eightresult where session='$session' and rol='$rol1' and exam='SECOND TERM EXAM' ";
$res2=mysqli_query($conn,$sel2);
//$row21=mysqli_fetch_array($res21,MYSQLI_BOTH);
$sel31="select * from six_eightresult where session='$session' and rol='$rol1' and exam='SECOND TERM EXAM' ";
$res31=mysqli_query($conn,$sel31);
$row31=mysqli_fetch_array($res31,MYSQLI_BOTH);
$sel311="select * from six_eightresult where session='$session' and rol='$rol1' and exam='SECOND TERM EXAM' ";
$res311=mysqli_query($conn,$sel311);
$sel211="select * from six_eightresult where session='$session' and rol='$rol1' and exam='THIRD TERM EXAM' ";
$res211=mysqli_query($conn,$sel211);
$sel2111="select * from six_eightresult where session='$session' and rol='$rol1' and exam='THIRD TERM EXAM' ";
$res2111=mysqli_query($conn,$sel2111);
$row2111=mysqli_fetch_array($res2111,MYSQLI_BOTH);
while($row311=mysqli_fetch_array($res311,MYSQLI_BOTH))
{
if($row311['mark1']=='Ab'){'0';}else{$row311['mark1'] ;}
if($row311['mark2']=='Ab'){'0';}else{$row311['mark2'] ;}
if($row311['mark3']=='Ab'){'0';}else{$row311['mark3'] ;}
if($row311['mark4']=='Ab'){'0';}else{$row311['mark4'] ;}
if($row311['mark5']=='Ab'){'0';}else{$row311['mark5'] ;}
if($row311){'0';}else{$row311['mark10'] ;}
if($row311){'0';}else{$row311['mark6'] ;}
if($row311){'0';}else{$row311['mark8'] ;}
if($row311){'0';}else{$row311['mark9'] ;}
if($row211['mark11']=='A'){'0';}else{$row211['mark11'] ;}
$marktotals=$row311['mark1']+$row311['mark2']+$row311['mark3']+$row311['mark4']+$row311['mark5']+$row311['mark10']+$row311['mark6']+$row311['mark8']+$row311['mark9']+$row311['mark11'];
$pers=$marktotals/3;
$pers=$pers*100;
//ECHO $marktotals;
}
///// for fourth term
$sel411="select * from six_eightresult where session='$session' and rol='$rol1' and exam='FOURTH TERM EXAM' ";
$res411=mysqli_query($conn,$sel411);
$sel4111="select * from six_eightresult where session='$session' and rol='$rol1' and exam='FOURTH TERM EXAM' ";
$res4111=mysqli_query($conn,$sel4111);
$row4111=mysqli_fetch_array($res4111,MYSQLI_BOTH);
while($row411=mysqli_fetch_array($res411,MYSQLI_BOTH))
{
if($row411['mark1']=='A'){'0';}else{$row411['mark1'] ;}
if($row411['mark2']=='A'){'0';}else{$row411['mark2'] ;}
if($row411['mark3']=='A'){'0';}else{$row411['mark3'] ;}
if($row411['mark4']=='A'){'0';}else{$row411['mark4'] ;}
if($row411['mark5']=='A'){'0';}else{$row411['mark5'] ;}
if($row411['mark10']=='A'){'0';}else{$row411['mark10'] ;}
if($row411['mark6']=='A'){'0';}else{$row411['mark6'] ;}
if($row411['mark8']=='A'){'0';}else{$row411['mark8'] ;}
if($row411['mark9']=='A'){'0';}else{$row411['mark9'] ;}
if($row211['mark11']=='A'){'0';}else{$row211['mark11'] ;}
$marktotal411=$row411['mark1']+$row411['mark2']+$row411['mark3']+$row411['mark4']+$row411['mark5']+$row411['mark10']+$row411['mark6']+$row411['mark8']+$row411['mark9']+$row411['mark11'];
$per411=$marktotal411/5;
$per411=$per411*100;
//ECHO $marktotals;
}
///// for fourth term
while($row211=mysqli_fetch_array($res211,MYSQLI_BOTH))
{
if($row211['mark1']=='A'){'0';}else{$row211['mark1'] ;}
if($row211['mark2']=='A'){'0';}else{$row211['mark2'] ;}
if($row211['mark3']=='A'){'0';}else{$row211['mark3'] ;}
if($row211['mark4']=='A'){'0';}else{$row211['mark4'] ;}
if($row211['mark5']=='A'){'0';}else{$row211['mark5'] ;}
if($row211['mark10']=='A'){'0';}else{$row211['mark10'] ;}
if($row211['mark7']=='A'){'0';}else{$row211['mark7'] ;}
if($row211['mark8']=='A'){'0';}else{$row211['mark8'] ;}
if($row211['mark9']=='A'){'0';}else{$row211['mark9'] ;}
if($row211['mark11']=='A'){'0';}else{$row211['mark11'] ;}
$marktotal211=$row211['mark1']+$row211['mark2']+$row211['mark3']+$row211['mark4']+$row211['mark5']+$row211['mark10']+$row211['mark6']+$row211['mark8']+$row211['mark9']+$row211['mark11'];
$per211=$marktotal211/1;
$per211=$per211*100;
//echo $marktotal211;
}
$all=$marktotal+$marktotals+$marktotal211+$marktotal411;
$allp1=$marktotal+$marktotals+$marktotal211+$marktotal411;
$allp=$allp1/10;
//$allp=$allp1/16;
?>
<center>
<?php
$rol1=$row1['rol'];
$sel5="select *from registration where id='$rol1' order by id desc";
$res5=mysqli_query($conn,$sel5);
$row5=mysqli_fetch_array($res5,MYSQLI_BOTH);
?>
<table frame="border" height="10%" width="100%" id="example">
<tr>
<td align="center" COLSPAN="5"><img src="../images/mhi mark123.png" style="width:100%" height="140px" width="100%"/></td>
</tr>
</table>
<table border="1px" width="100%" cellspacing="0">
<tr align="center">
<td><h4>Class: <?php echo $row1['class'];?></h4></td><td colspan="2"><h4>ANNUAL EXAM-<?php echo $row1['session'];?>(<?php echo $board;?>)</h4></td><td ><h4>Roll Number: <?php echo $row1['rol'];?></h4></td>
</tr>
<tr align="">
<td>Name</td><td colspan="2"><p><?php echo $row5['name'];?></p></td><td rowspan="4">
<center><img src="../code/img/<?php echo $row5['picture'];?>" height="80px" width="100px"/></center></td>
</tr>
<tr align="">
<td>Father Name</td><td colspan="2"><p><?php echo $row5['fname'];?></p></td>
</tr>
<tr align="">
<td>Mother Name</td><td colspan="2"><p><?php echo $row5['mname'];?></p></td>
</tr>
<tr align="">
<td>Date Of Birth</td><td colspan="2"><p><?php echo $row5['dob'];?></p></td>
</tr>
<tr align="center">
<td colspan="5"><h3>MARKS</h3></td>
</tr>
<table cellspacing="0" border="1px" width="100%">
<tr align="center" style="font-weight:bold">
<td rowspan="2">SUBJECT</td><td colspan="2">FIRST TERM EXAM.</td><td colspan="2">SECOND TERM EXAM.</td><td colspan="2">THIRD TERM EXAM.</td><td colspan="2">ANNUAL EXAM.</td>
</tr>
<tr align="center">
<td style="font-weight:bold">Max. Marks</td><td style="font-weight:bold">Obtained Marks</td><td style="font-weight:bold">Max. Marks</td><td style="font-weight:bold">Obtained Marks</td><td style="font-weight:bold">Max. Marks</td><td style="font-weight:bold">Obtained Marks</td><td style="font-weight:bold">Max. Marks</td><td style="font-weight:bold">Obtained Marks</td>
</tr>
<tr align="center">
<td style="text-align:left">HINDI</td><td>10</td><td><?php echo $row1['mark1'];?></td><td>30</td><td><?php echo $row31['mark1'];?></td><td>10</td><td STYLE=''><?php echo $row2111['mark1'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark1'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">ENGLISH</td><td>10</td><td><?php echo $row1['mark2'];?></td><td>30</td><td><?php echo $row31['mark2'];?></td><td>10</td><td><?php echo $row2111['mark2'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark2'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">MATHS</td><td>10</td><td><?php echo $row1['mark3'];?></td><td>30</td><td><?php echo $row31['mark3'];?></td><td>10</td><td><?php echo $row2111['mark3'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark3'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">SCIENCE</td><td>10</td><td><?php echo $row1['mark4'];?></td><td>30</td><td><?php echo $row31['mark4'];?></td><td>10</td><td><?php echo $row2111['mark4'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark4'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">ART</td><td>10</td><td><?php echo $row1['mark5'];?></td><td>30</td><td><?php echo $row31['mark5'];?></td><td>10</td><td><?php echo $row2111['mark5'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark5'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">SANSKRIT</td><td>10</td><td><?php echo $row1['mark6'];?></td><td>30</td><td><?php echo $row31['mark6'];?></td><td>10</td><td><?php echo $row2111['mark6'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark6'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">CONVERSATION</td><td>10</td><td><?php echo $row1['mark8'];?></td><td>30</td><td><?php echo $row31['mark8'];?></td><td>10</td><td><?php echo $row2111['mark8'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark8'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">COMPUTER</td><td>10</td><td><?php echo $row1['mark9'];?></td><td>30</td><td><?php echo $row31['mark9'];?></td><td>10</td><td><?php echo $row2111['mark9'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark9'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">HOME SCI/AGRI</td><td>10</td><td><?php echo $row1['mark10'];?></td><td>30</td><td><?php echo $row31['mark10'];?></td><td>10</td><td><?php echo $row2111['mark10'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark10'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">SOCI STU</td><td>10</td><td><?php echo $row1['mark11'];?></td><td>30</td><td><?php echo $row31['mark11'];?></td><td>10</td><td><?php echo $row2111['mark11'];?></td><td>50</td><td STYLE=''><?php echo $row4111['mark11'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">URDU</td><td>GRADE</td><td><?php echo $row1['mark7'];?></td><td>GRADE</td><td><?php echo $row31['mark7'];?></td><td>GRADE</td><td><?php echo $row2111['mark7'];?></td><td>GRADE</td><td STYLE=''><?php echo $row4111['mark7'];?></td>
</tr>
<tr align="center">
<td style="text-align:left"></td><td style="font-weight:bold">TOTAL</td><td style="font-weight:bold"><?php echo $marktotal;?></td><td style="font-weight:bold">TOTAL</td><td style="font-weight:bold"><?php echo $marktotals;?></td><td style="font-weight:bold">TOTAL</td><td style="font-weight:bold"><?php echo $marktotal211;?></td><td style="font-weight:bold">TOTAL</td><td style="font-weight:bold"><?php echo $marktotal411;?></td>
</tr>
<tr align="center">
<td style="text-align:left"></td><td style="font-weight:bold">PER</td><td style="font-weight:bold;color:red"><?php echo substr("$per",0,2).'%';?></td><td style="font-weight:bold">PER</td><td style="font-weight:bold;color:red"><?php echo substr("$pers",0,2).'%';?></td><td style="font-weight:bold">PER</td><td style="font-weight:bold;color:red"><?php echo substr("$per211",0,2).'%';?></td><td style="font-weight:bold">PER</td><td style="font-weight:bold;color:red"><?php echo substr("$per411",0,2).'%';?></td>
</tr>
<tr>
<td colspan="4" align="center"><h4><br/>ALL TOTAL RESULT<br/><br/>ALL TOTAL PER<br/><br/>DIVISION</h4><br/></td><td colspan="6" align="center"><h4 style="color:red"><?php echo $all.'/1000';?><BR/><br/><?php echo substr("$allp",0,2).'%';?>
<BR/><BR/><?PHP if($allp>=33 )
{
if($allp>=33 and $allp<=45)
{
echo "THIRD";
}
else if($allp>45 and $allp<60)
{
echo "SECOND";
}
else if($allp=60 and $allp<=100)
{
echo "FIRST";
}
}
ELSE
{
echo "NO OBTAIN";
}
?>
</h4></td>
</tr>
<tr>
<td colspan="4" align="center"><h4>Guardian's Signature</h4><br/><br/><br/></td><td colspan="5" align="center"><h4>Principal's Signature</h4><br/><br/><br/></td>
</tr>
<tr align="center">
<td>Note:</td><td colspan="8"><i>Please make Signature Principal and Guardian in Space.</i></td>
</tr>
</table>
<center><img src="../images/mhi mark1.png" id="jk" style="position:relative;height:500px;width:100%;margin-top:-1800px;z-index:-1;"/></center>
<?php
?><br/><br/><br/><br/><BR/><BR/><?php
}
?>
</body>
</html>