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 $id=$_REQUEST['flag']; session_start(); $lg=$_SESSION['admin']; if(!$lg) { header("location:../admin/index.php"); } ?> <?php include("../link/databaseconnection.php"); $selg="select * from registration where id='$id'"; $resg=mysqli_query($conn,$selg); $rowg=mysqli_fetch_array($resg,MYSQLI_BOTH); $app=$rowg['application']; $sessiong=$rowg['session']; //echo $app; $sel1="select * from studentfees where search ='$app' and year='$sessiong'"; $res1=mysqli_query($conn,$sel1); $row1=mysqli_fetch_array($res1,MYSQLI_BOTH); $search=$row1['search']; $sel="select * from registration where id ='$id'"; $res=mysqli_query($conn,$sel); $row=mysqli_fetch_array($res,MYSQLI_BOTH); $date=date("d/m/Y"); date_default_timezone_set("asia/kolkata"); $time=date("h:i:sa"); $datetime=$date." ".$time; //echo"$app1"; ?> <html> <head> <style> #name2 { font-weight:bold; } </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_showfees.php'; }); }); </script> <link href="css/student_print.css" rel="stylesheet" type="text/css"> </head> <body> <table frame="border" width="100%" cellspacing="0"> <tr> <td><span><img src="../images/MHI.png" height="100px" width="100px"/></span></td><td align="center"><span id="name" colspan="2" style="font-size:33px;font-weight:bold">M.H.I. SCHOOL </span><br/><br/><br/><span id="name1" style="font-size:25px;font-weight:bold">MaitiNagar Chandpar - Azamgarh</span></td> </tr> </table> <table border="1px;" width="100%" cellspacing="0"> <caption style="font-size:18px;font-weight:bold">Fees Statement</caption> <tr> <td width="30%"><span id="name2">Sch. Number</span></td><td width="60%"><span id="name3"><?php echo $row['application'];?></span></td><td align="right" rowspan="3"width="10%"><span><img src="../code/img/<?php echo $row['picture'];?>" height="100" style="width:100%" ></span></td> </tr> <tr> <td width="30%"><span id="name2">Student Name</span></td><td width=""><span id="name3"><?php echo $row['name'];?></span></td> </tr> <tr> <td width="30%"><span id="name2"> Father Name</span></td><td><span id="name3"><?php echo $row['fname'];?></span></td> </tr> </table> <table width="100%" border="1px" cellspacing="0"> <tr> <td width="30%"><span id="name2">Mother Name</span></td><td width="30%"><span id="name3"><?php echo $row['mname'];?></span></td><td width="20%"><span id="name2">Adhar Card</span></td><td width="20%"><span id="name3"><?php echo $row['adhar'];?></span></td> </tr> <tr> <td width="30%"><span id="name2">Gender</span></td><td width="30%"><span id="name3"><?php echo $row['gender'];?></span></td><td width="20%"><span id="name2">Class Group</span></td><td width="20%"><span id="name3"><?php echo $row['class'];?></span></td> </tr> <tr> <td width="30%"><span id="name2">Date Of Birth</span></td><td width="30%"><span id="name3"><?php echo $row['dob'];?></span></td><td width="20%"><span id="name2">Class</span></td><td width="20%"><span id="name3"><?php echo $row['subject'];?></span></td> </tr> </table> <br/> <table border="1px" width="100%" cellspacing="0"> <tr> <td colspan='18' align="center"><span id="name4" style="font-size:18px;font-weight:bold">Fees History</span></td> </tr> <tr align="center"> <td><span id="name2">Session</span></td> <td><span id="name2">Month</span></td> <td><span id="name2" >Month Fee</span></td> <td><span id="name2" >Exam</span></td> <td><span id="name2">Conveyance</span></td> <td><span id="name2">Exam Fee</span></td> <td><span id="name2">Regi Fee</span></td> <td><span id="name2">Add Fee</span></td> <td><span id="name2">Fine</span></td> <td><span id="name2">Annual Charge</span></td> <td><span id="name2">Other</span></td> <td ><span id="name2">Total</span></td> <td ><span id="name2">Cons</span></td> <td ><span id="name2">Paid</span></td> <td><span id="name2">Due Charge</span></td> <td><span id="name2">Date</span></td> </tr> <?php $sel23="select * from studentfees where search ='$app' and year='$sessiong' order by id desc"; $res23=mysqli_query($conn,$sel23); $row23=mysqli_fetch_array($res23,MYSQLI_BOTH); $remain23=$row23['remain']; $sum=0; $sum1=0; $con1=0; $remain1=0; $sel2="select * from studentfees where search ='$app' and year='$sessiong'"; $res2=mysqli_query($conn,$sel2); while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH)) { $tot=$row2['total']; $paid13=$row2['paid']; $con3=$row2['con']; $remain12=$row2['remain']; $sum=$tot+$sum; $sum1=$paid13+$sum1; $con1=$con3+$con1; $remain1=$remain12+$remain1; ?> <tr align="center"> <td><span id="name3"><?php echo $row2['year'];?></span></td> <td><span id="name3"><?php echo $row2['month'];?></span></td> <td><span id="name3"><?php echo $row2['fee'];?></span></td> <td><span id="name3"><?php echo $row2['exam'];?></span></td> <td><span id="name3"><?php echo $row2['van'];?></span></td> <td><span id="name3"><?php echo $row2['exam'];?></span></td> <td><span id="name3"><?php echo $row2['reg'];?></span></td> <td><span id="name3"><?php echo $row2['addm'];?></span></td> <td><span id="name3"><?php echo $row2['fine'];?></span></td> <td><span id="name3"><?php echo $row2['ann'];?></span></td> <td><span id="name3"><?php echo $row2['other'];?></span></td> <td style="font-weight:bold"><span id="name3"><?php echo $row2['total'];?></span></td> <td style="font-weight:bold"><span id="name3"><?php echo $row2['con'];?></span></td> <td style="font-weight:bold"><span id="name3"><?php echo $row2['paid'];?></span></td> <td style="font-weight:bold"><span id="name3"><?php echo $row2['remain'];?></span></td> <td style="font-weight:bold"><span id="name3"><?php echo $row2['date'];?> <?php echo $row2['date1'];?></span></td> </tr> <?php } ?> <tr align="center"> <td colspan="11" style="font-weight:bold;font-size:18px">Total</td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2"></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2"><?php echo $con1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2"><?php echo $sum1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2"><?php echo $remain23;?></span></td> </tr> </table> <table width="100%" frame="border"> <tr align="center"> <td width="50%" ><span id="name3" style="font-size:15px;font-weight:bold">Datetime</span></td><td width="50%"><span id="name3" style="font-size:15px;font-weight:bold">Signature</span></td> </tr> <tr> <td align="center"><span ><?php echo $datetime;?></span></td><td><br/><br/></td> </tr> </table> <br/> <button id="print" style="margin-left:500px;" >Print</button>      <span><button id="back" >Back</button></span> </body> </html>