|
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/ppschool.org.in/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../link/databaseconnection.php");
error_reporting(0);
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:../admin/index.php");
}
$id=$_REQUEST['flag'];
$sel101="select * from studentfees where id='$id' and status='' order by id desc ";
$res101=mysqli_query($conn,$sel101);
$row101=mysqli_fetch_array($res101,MYSQLI_BOTH);
$no=$_POST['no'];
$search=$row101['search'];
//echo $search;
$date=$row101['date'];
//echo $month;
$date20=date("d-m-Y",strtotime($date));
//echo $date;
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<?php
$sel4="select * from registration where application ='$search' order by id desc";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$sel12="select * from studentfees WHERE id='$id' and status='' ";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
$search=$row12['search'];
$idd=$row12['id'];
$id12=$idd-1;
//echo $id12;
$date12=date("d-m-Y");
$sel1="select * from studentfees where id='$id' and status='' ";
$res1=mysqli_query($conn,$sel1);
$sel10="select * from studentfees WHERE id='$id' and status='' order by id desc ";
$res10=mysqli_query($conn,$sel10);
$row10=mysqli_fetch_array($res10,MYSQLI_BOTH);
$selde="select * from studentfees where id='$id' and status='' order by id desc limit 2 ";
$resde=mysqli_query($conn,$selde);
$rowde=mysqli_fetch_array($resde,MYSQLI_BOTH);
$idd=$rowde['id'];
//echo $idd;
$selmo="select * from studentfees where id='$id' and status='' order by id desc ";
$resmo=mysqli_query($conn,$selmo);
$month12='';
$rowmo=mysqli_fetch_array($resmo,MYSQLI_BOTH);
$month12=$rowmo['month'];
// $month12=$month13.",".$month12;
//echo $date;
//echo"$app1";
?>
<html>
<head>
<style>
#name2
{
}
</style>
<script src="../js/jquery-3.2.1.min.js"></script> <!--jquery-->
<script>
$(document).ready(function(){
$("#print").click(function(){
$("#pay").css("visibility","hidden");
$("#back").css("visibility","hidden");
$("#print").css("visibility","hidden");
window.print();
});
$("#back").click(function(){
window.location.href='student_details1.php';
});
});
</script>
<style>
.a{
width:47%;
float:left;
}
body{
-webkit-print-color-adjust:exact !important;
print-color-adjust:exact !important;
}
@media print
{
print-color-adjust: exact;
table{width:100%;}
#mo{width:230px;}
}
</style>
<link href="css/student_print.css" rel="stylesheet" type="text/css">
</head>
<body>
<script>
$(document).ready(function(){
var p=$("#pay").val();
});
</script>
<?php
/**
* Created by PhpStorm.
* User: sakthikarthi
* Date: 9/22/14
* Time: 11:26 AM
* Converting Currency Numbers to words currency format
*/
$number = $row10['paid'];
$no = round($number);
$point = round($number - $no, 2) * 100;
$hundred = null;
$digits_1 = strlen($no);
$i = 0;
$str = array();
$words = array('0' => '', '1' => 'One', '2' => 'Two',
'3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
'7' => 'Seven', '8' => 'Eight', '9' => 'Nine',
'10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve',
'13' => 'Thirteen', '14' => 'Fourteen',
'15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen',
'18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty',
'30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty',
'60' => 'Sixty', '70' => 'Seventy',
'80' => 'Eighty', '90' => 'Ninety');
$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
while ($i < $digits_1) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += ($divider == 10) ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number] .
" " . $digits[$counter] . $plural . " " . $hundred
:
$words[floor($number / 10) * 10]
. " " . $words[$number % 10] . " "
. $digits[$counter] . $plural . " " . $hundred;
} else $str[] = null;
}
$str = array_reverse($str);
$result = implode('', $str);
$points = ($point) ?
"." . $words[$point / 10] . " " .
$words[$point = $point % 10] : '';
?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script>
function getIndianCurrency(float $number)
{
$decimal = round($number - ($no = floor($number)), 2) * 100;
$hundred = null;
$digits_length = strlen($no);
$i = 0;
$str = array();
$words = array(0 => '', 1 => 'one', 2 => 'two',
3 => 'three', 4 => 'four', 5 => 'five', 6 => 'six',
7 => 'seven', 8 => 'eight', 9 => 'nine',
10 => 'ten', 11 => 'eleven', 12 => 'twelve',
13 => 'thirteen', 14 => 'fourteen', 15 => 'fifteen',
16 => 'sixteen', 17 => 'seventeen', 18 => 'eighteen',
19 => 'nineteen', 20 => 'twenty', 30 => 'thirty',
40 => 'forty', 50 => 'fifty', 60 => 'sixty',
70 => 'seventy', 80 => 'eighty', 90 => 'ninety');
$digits = array('', 'hundred','thousand','lakh', 'crore');
while( $i < $digits_length ) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += $divider == 10 ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number].' '. $digits[$counter]. $plural.' '.$hundred:$words[floor($number / 10) * 10].' '.$words[$number % 10]. ' '.$digits[$counter].$plural.' '.$hundred;
} else $str[] = null;
}
$Rupees = implode('', array_reverse($str));
$paise = ($decimal) ? "." . ($words[$decimal / 10] . " " . $words[$decimal % 10]) . ' Paise' : '';
return ($Rupees ? $Rupees . 'Rupees ' : '') . $paise .;
}
</script>
<div style="border:1px solid" class="a">
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo.png" height="50px" width="50px"/></span></td><td align="left"><span id="name" style="font-size:13px;text-align:left;font-weight:bold">PACIFIC PUBLIC SCHOOL</span><br/><span style='font-size:12px'>THE LAND OF WISDOM</span><br/><span style='font-size:10px'>Semra No. 1 Chargawan Gorakhpur, [Uttar Prades]-273013 </span></td><td style=' border-left: double;'><div style='margin-left:5px'><span style='font-size:10px;'>Registration/Affilatio No.</span><br/><span style='font-size:11px;'>AFFL NO-C/80/2014</span><br/><span style='font-size:10px'><i class="fa fa-phone-square"></i> 9451960467<br/>7054255900<br/>9450480563</span></div></td>
</tr>
</table>
<table border="1px;" width="100%"cellspacing="0" >
<tr style='background-color:gray'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:white'>Fee Receipt</span></td><td colspan="2"><span style="font-size:11px;color:white">Session : <?php echo $row12['year'];?></span></td>
</tr>
<tr style='background-color:#D7D1D1'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:black'> Receipt No: <?php echo $row10['id'];?></span></td><td colspan="2"><span style="font-size:11px;color:black">Date : <?php echo $date20;?></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Scho. Number</span></td><td colspan="2"><span style="font-size:11px"><?php echo $row12['search'];?></span></td><td align="center" rowspan="2"><span><img src="../code/img/<?php echo $row4['picture'];?>" style="width:50px;height:50px" class="img-responsive" ></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Student Name</span></td><td colspan='2'><span style="font-size:11px"><?php echo $row4['name'];?></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold"> Father Name</span></td><td><span style="font-size:11px"><?php echo $row4['fname'];?></span></td><td style="font-size:11px"><b>Class</b></td><td style="font-size:11px"><?php echo $row4['subject'];?>/<?php echo $row4['section'];?></td>
</tr>
</table>
<table frame="border" width="100%" cellspacing="0" height="25%">
<tr >
<td colspan="15" style="border: 1px solid black"><textarea id="mo" class="mo" style="font-weight:bold;font-size:10px;resize:none" rows="3" cols="90"><?php echo $month12;?></textarea></td>
</tr>
<tr style='background-color:#D7D1D1'>
<td colspan='10' style='padding: 3px'><span style='font-size:13px;color:black;font-weight:bold;padding: 6px'>Fee Type</span></td><td colspan="2" align="right" style='padding: 3px'><span style="font-size:13px;color:black;font-weight:bold;padding:6px">Fee Amount </span></td>
</tr>
<tr >
<td width="25%" colspan='10' align="left" style='padding: 2px;'><span id="name2" >Tution Fee</span></td>
<td width="25%" colspan='2' align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['fee']=='0'){echo '';}else{echo $row10['fee'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Conv Fee</span></td>
<td width="25%" align="right" colspan='2' style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['van']=='0'){echo '';}else{echo $row10['van'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Miscellaneous Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['addm']=='0'){echo '';}else{echo $row10['addm'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Annual Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['ann']=='0'){echo '';}else{echo $row10['ann'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Exam Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['exam']=='0'){echo '';}else{echo $row10['exam'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Computer Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['comp']=='0'){echo '';}else{echo $row10['comp'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Other Fee ( <?php echo $row10['other_remark']?>)</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['other']=='0'){echo '';}else{echo $row10['other'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Old Dues </span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['pre']=='0'){echo '';}else{echo $row10['pre'];}?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:100px' >
<td colspan='10' style='border: 1px solid black;padding: 7px'><span style='font-size:13px;color:black;font-weight:bold'>Paymode Mode : <?php echo $row10['mode']?> </span></td><td colspan="2" align="right" style='border: 1px solid black;padding: 7px'><span style="font-size:13px;color:black;font-weight:bold"><?php echo $row10['total']?> Rs. </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Discount (<?php echo $row10['remark']?>) : <?php if($row10['con']=='0'){echo '';}else{echo $row10['con'];}?> Rs.</span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='5'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Paid : <?php echo $row10['paid']?> Rs.</span></td><td colspan='6'style='border: 1px solid black;padding: 7px;text-align:center' ><span style='font-size:13px;color:black;'>Dues Fee : <?php echo $row10['remain']?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;' ><span style='font-size:13px;color:black;'> Amount in Word : <?php echo $result . "Rupees " . $points . " Only.";?> </span></td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='7'style='border: 1px solid black;padding: 7px;' ><br/><span style='font-size:11px;color:black;'> PRINCIPAL </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;text-align:right' ><br/><span style='font-size:11px;color:black;'> ACCOUNTANT </td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='7'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Print : <?php echo date('d-M-Y')?> : <?php echo $time;?> </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Student Copy </span></td>
</tr>
<?php
$tot='0';
$paid16='0';
$due16='0';
$con12='0';
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$tot1=$row1['mtotal'];
$paid15=$row1['paid'];
$con=$row1['con'];
$remain15=$row1['remain'];
$tot16=$remain15+$paid15+$con;
$due16=$remain15+$due16;
$con12=$con+$con12;
$tot=$tot16+$tot;
$paid16=$paid16+$paid15;
?>
<?php
}
?>
</table>
</div>
<div class="ab" style="float:left;width:3%">--</div>
 <div style="border:1px solid" class="a">
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo.png" height="50px" width="50px"/></span></td><td align="left"><span id="name" style="font-size:13px;text-align:left;font-weight:bold">PACIFIC PUBLIC SCHOOL</span><br/><span style='font-size:12px'>THE LAND OF WISDOM</span><br/><span style='font-size:10px'>Semra No. 1 Chargawan Gorakhpur, [Uttar Prades]-273013 </span></td><td style=' border-left: double;'><div style='margin-left:5px'><span style='font-size:10px;'>Registration/Affilatio No.</span><br/><span style='font-size:11px;'>AFFL NO-C/80/2014</span><br/><span style='font-size:10px'><i class="fa fa-phone-square"></i> 9451960467<br/>7054255900<br/>9450480563</span></div></td>
</tr>
</table>
<table border="1px;" width="100%"cellspacing="0" >
<tr style='background-color:gray'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:white'>Fee Receipt</span></td><td colspan="2"><span style="font-size:11px;color:white">Session : <?php echo $row12['year'];?></span></td>
</tr>
<tr style='background-color:#D7D1D1'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:black'> Receipt No: <?php echo $row10['id'];?></span></td><td colspan="2"><span style="font-size:11px;color:black">Date : <?php echo $date20;?></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Scho. Number</span></td><td colspan="2"><span style="font-size:11px"><?php echo $row12['search'];?></span></td><td align="center" rowspan="2"><span><img src="../code/img/<?php echo $row4['picture'];?>" style="width:50px;height:50px" class="img-responsive" ></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Student Name</span></td><td colspan='2'><span style="font-size:11px"><?php echo $row4['name'];?></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold"> Father Name</span></td><td><span style="font-size:11px"><?php echo $row4['fname'];?></span></td><td style="font-size:11px"><b>Class</b></td><td style="font-size:11px"><?php echo $row4['subject'];?>/<?php echo $row4['section'];?></td>
</tr>
</table>
<table frame="border" width="100%" cellspacing="0" height="25%">
<tr >
<td colspan="12" style="border: 1px solid black"><textarea id="mo" class="mo" style="font-weight:bold;font-size:10px;resize:none" rows="3" cols="80"><?php echo $month12;?></textarea></td>
</tr>
<tr style='background-color:#D7D1D1'>
<td colspan='10' style='padding: 3px'><span style='font-size:13px;color:black;font-weight:bold;padding: 6px'>Fee Type</span></td><td colspan="2" align="right" style='padding: 3px'><span style="font-size:13px;color:black;font-weight:bold;padding:6px">Fee Amount </span></td>
</tr>
<tr >
<td width="25%" colspan='10' align="left" style='padding: 2px;'><span id="name2" >Tution Fee</span></td>
<td width="25%" colspan='2' align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['fee']=='0'){echo '';}else{echo $row10['fee'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Conv Fee</span></td>
<td width="25%" align="right" colspan='2' style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['van']=='0'){echo '';}else{echo $row10['van'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Miscellaneous Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['addm']=='0'){echo '';}else{echo $row10['addm'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Annual Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['ann']=='0'){echo '';}else{echo $row10['ann'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Exam Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['exam']=='0'){echo '';}else{echo $row10['exam'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Computer Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['comp']=='0'){echo '';}else{echo $row10['comp'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Other Fee ( <?php echo $row10['other_remark']?>)</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['other']=='0'){echo '';}else{echo $row10['other'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Old Dues </span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['pre']=='0'){echo '';}else{echo $row10['pre'];}?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:100px' >
<td colspan='10' style='border: 1px solid black;padding: 7px'><span style='font-size:13px;color:black;font-weight:bold'>Paymode Mode : <?php echo $row10['mode']?> </span></td><td colspan="2" align="right" style='border: 1px solid black;padding: 7px'><span style="font-size:13px;color:black;font-weight:bold"><?php echo $row10['total']?> Rs. </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Discount (<?php echo $row10['remark']?>) : <?php if($row10['con']=='0'){echo '';}else{echo $row10['con'];}?> Rs.</span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='5'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Paid : <?php echo $row10['paid']?> Rs.</span></td><td colspan='6'style='border: 1px solid black;padding: 7px;text-align:center' ><span style='font-size:13px;color:black;'>Dues Fee : <?php echo $row10['remain']?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;' ><span style='font-size:13px;color:black;'> Amount in Word : <?php echo $result . "Rupees " . $points . " Only.";?> </span></td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='8'style='border: 1px solid black;padding: 7px;' ><br/><span style='font-size:11px;color:black;'> PRINCIPAL </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;text-align:right' ><br/><span style='font-size:11px;color:black;'> ACCOUNTANT </td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='8'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Print : <?php echo date('d-M-Y')?> : <?php echo $time;?> </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Office Copy </span></td>
</tr>
<?php
$tot='0';
$paid16='0';
$due16='0';
$con12='0';
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$tot1=$row1['mtotal'];
$paid15=$row1['paid'];
$con=$row1['con'];
$remain15=$row1['remain'];
$tot16=$remain15+$paid15+$con;
$due16=$remain15+$due16;
$con12=$con+$con12;
$tot=$tot16+$tot;
$paid16=$paid16+$paid15;
?>
<?php
}
?>
</table>
</div>
<br/>
<button id="print" style="margin-left:500px;" >Print</button>     
<span><button id="back" >Back</button></span>
</body>
</html>