|
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/shivbalika.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$id=$_REQUEST['flag'];
error_reporting(0);
include('../link/databaseconnection.php');
session_start();
$lg=$_SESSION['admin'];
$sel="select * from six_eightresult where rol='$id' ";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$exam=$row['name'];
$sel1="select * from six_eightresult where rol='$id' and exam='FIRST TERM EXAM'";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
$sel2="select * from six_eightresult where rol='$id' and exam='SECOND TERM EXAM' ";
$res2=mysqli_query($conn,$sel2);
$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
$sel23="select * from six_eightresult where rol='$id' and exam='ANNUAL EXAM' ";
$res23=mysqli_query($conn,$sel23);
$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
$sel3="select *from registration where id='$id' ";
$res3=mysqli_query($conn,$sel3);
$row3=mysqli_fetch_array($res3,MYSQLI_BOTH);
$mediam=$row3['mediam'];
$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>
.graph-7{background: url("../images/shivback.png") no-repeat ;}
.graph-7{background-size:100% 100% ;}
@media print{
.graph-img img{display:inline;}
width:100%;
}
@media print {
* {
-webkit-print-color-adjust: exact;
}
}
#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
$s=2017;
$r=1;
if($row1['mark1']=='Ab'){'0';}else{$row1['mark1'] ;}
if($row1['mark2']=='Ab'){'0';}else{$row1['mark2'] ;}
if($row1['mark3']=='Ab'){'0';}else{$row1['mark3'] ;}
if($row1['mark4']=='Ab'){'0';}else{$row1['mark4'] ;}
if($row1['mark5']=='Ab'){'0';}else{$row1['mark5'] ;}
if($row1['mark6']=='Ab'){'0';}else{$row1['mark6'] ;}
if($row1['mark7']=='Ab'){'0';}else{$row1['mark7'] ;}
if($row1['mark8']=='Ab'){'0';}else{$row1['mark8'] ;}
if($row1['mark9']=='Ab'){'0';}else{$row1['mark9'] ;}
$marktotal=$row1['mark1']+$row1['mark2']+$row1['mark3']+$row1['mark4']+$row1['mark6']+$row1['mark7']+$row1['mark8'];
$per=$marktotal/3.5;;
//$per=$per1*100;
$rol1=$row1['rol'];
///// FOR SECOND
$sel21="select * from six_eightresult where session='$session' and rol='$rol1' and exam='SECOND TERM EXAM' ";
$res21=mysqli_query($conn,$sel21);
$row21=mysqli_fetch_array($res21,MYSQLI_BOTH);
$sel2="select * from six_eightresult where session='$session' and rol='$rol1' and exam='SECOND TERM EXAM' ";
$res2=mysqli_query($conn,$sel2);
//$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
if($row2['mark1']=='Ab'){'0';}else{$row2['mark1'] ;}
if($row2['mark2']=='Ab'){'0';}else{$row2['mark2'] ;}
if($row2['mark3']=='Ab'){'0';}else{$row2['mark3'] ;}
if($row2['mark4']=='Ab'){'0';}else{$row2['mark4'] ;}
if($row2['mark5']=='Ab'){'0';}else{$row2['mark5'] ;}
if($row2['mark6']=='Ab'){'0';}else{$row2['mark6'] ;}
if($row2['mark7']=='Ab'){'0';}else{$row2['mark7'] ;}
if($row2['mark8']=='Ab'){'0';}else{$row2['mark8'] ;}
if($row2['mark9']=='Ab'){'0';}else{$row2['mark9'] ;}
$marktotals=$row2['mark1']+$row2['mark2']+$row2['mark3']+$row2['mark4']+$row2['mark6']+$row2['mark7']+$row2['mark8'];
//$per2=$marktotal2/2.5;
$pers=$marktotals/3.5;
///// FOR SECOND
//$sel23="select * from six_eightresult where session='$session' and rol='$rol1' and exam='THIRD TERM EXAM' ";
//$res23=mysqli_query($conn,$sel23);
//$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
if($row23['mark1']=='Ab'){'0';}else{$row23['mark1'] ;}
if($row23['mark2']=='Ab'){'0';}else{$row23['mark2'] ;}
if($row23['mark3']=='Ab'){'0';}else{$row23['mark3'] ;}
if($row23['mark4']=='Ab'){'0';}else{$row23['mark4'] ;}
if($row23['mark5']=='Ab'){'0';}else{$row23['mark5'] ;}
if($row23['mark6']=='Ab'){'0';}else{$row23['mark6'] ;}
if($row23['mark7']=='Ab'){'0';}else{$row23['mark7'] ;}
if($row23['mark8']=='Ab'){'0';}else{$row23['mark8'] ;}
if($row23['mark9']=='Ab'){'0';}else{$row23['mark9'] ;}
$marktotal211=$row23['mark1']+$row23['mark2']+$row23['mark3']+$row23['mark4']+$row23['mark6']+$row23['mark7']+$row23['mark8'];
$per23=$marktotal23;
$per211=$marktotal211/7;
//$per2=$per2*100;
$all=$marktotal+$marktotals+$marktotal211;
$allp1=$marktotal+$marktotals+$marktotal211;
$allp=$allp1/14;
?>
<center>
<table frame="border" height="10%" width="100%" id="example">
<tr>
<td align="center" COLSPAN="5"><img src="../images/shivpnew.png" style="width:100%" height="140px" width="100%"/></td>
</tr>
</table>
<?php
$rol1=$row1['rol'];
$sel5="select *from registration where id='$id' order by id desc";
$res5=mysqli_query($conn,$sel5);
$row5=mysqli_fetch_array($res5,MYSQLI_BOTH);
?>
<div class="row graph-image graph-7" style="width:100%">
<table border="1px" width="100%" cellspacing="0">
<tr align="center">
<td><h4>Class: <?php echo $row5['subject'];?></h4></td><td colspan="2"><h4>ANNUAL EXAM-<?php echo $row5['session'];?></h4></td><td ><h4>Reg Number: <?php echo $id;?></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>DOB</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">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>
</tr>
<tr align="center">
<td style="text-align:left">HINDI</td><td>50</td><td><?php echo $row1['mark1'];?></td><td>50</td><td><?php echo $row2['mark1'];?></td><td>100</td><td STYLE=''><?php echo $row23['mark1'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">ENGLISH</td><td>50</td><td><?php echo $row1['mark2'];?></td><td>50</td><td><?php echo $row2['mark2'];?></td><td>100</td><td><?php echo $row23['mark2'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">MATHS</td><td>50</td><td><?php echo $row1['mark3'];?></td><td>50</td><td><?php echo $row2['mark3'];?></td><td>100</td><td><?php echo $row23['mark3'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">SCIENCE</td><td>50</td><td><?php echo $row1['mark4'];?></td><td>50</td><td><?php echo $row2['mark4'];?></td><td>100</td><td><?php echo $row23['mark4'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">COMPUTER</td><td>50</td><td><?php echo $row1['mark6'];?></td><td>50</td><td><?php echo $row2['mark6'];?></td><td>100</td><td><?php echo $row23['mark6'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">G.K</td><td>50</td><td><?php echo $row1['mark7'];?></td><td>50</td><td><?php echo $row2['mark7'];?></td><td>100</td><td><?php echo $row23['mark7'];?></td>
</tr>
<tr align="center">
<td style="text-align:left">ARTS</td><td>50</td><td><?php echo $row1['mark8'];?></td><td>50</td><td><?php echo $row2['mark8'];?></td><td>100</td><td><?php echo $row23['mark8'];?></td>
</tr>
<tr align="center">
<td style="text-align:left"></td><td style="font-weight:bold">350</td><td style="font-weight:bold"><?php echo $marktotal;?></td><td style="font-weight:bold">350</td><td style="font-weight:bold"><?php echo $marktotals;?></td><td style="font-weight:bold">700</td><td style="font-weight:bold"><?php echo $marktotal211;?></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>
</tr>
<tr>
<td colspan="4" align="center"><h4><br/>ALL TOTAL RESULT<br/><br/>ALL TOTAL PER<br/><br/>DIVISION<br/><br/>CLASS IN POSITION</h4><br/><br/><br/></td><td colspan="4" align="center"><h4 style="color:red">     <?php echo $all.'/1400';?><BR/><br/>     <?php echo substr("$allp",0,5).'%';?>
<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";
}
?>
<BR/><BR/>     <span style="color:green"><?php echo $row23['mark10'];?></span>
</h4><br/><br/><br/></td>
</tr>
<tr>
<td colspan="4" align="center"><h4>Class Teacher's Signature</h4><br/><br/><br/></td><td colspan="4" align="center"><h4>Principal's Signature</h4><br/><br/><br/></td>
</tr>
<tr align="center">
<td>Note:</td><td colspan="7"><i><span style="weight:bold">"Certificate is not Vailid Without Principal Signature and Stamp!"</span></i></td>
</tr>
</table>
</div>
</body>
</html>