Assignment-App/attendance.php at master · mitesh24100/Assignment-App · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "attendance_system";

$con = new mysqli ($servername, $username, $password, $dbname);

$first = $_GET['email'];
$second = $_GET['class'];
$third = $_GET['fname'];
$fourth = $_GET['rollno'];

$sql = $con->query("SELECT Subject FROM `$second`");

$array = array();

foreach($sql as $out)
{
$res = $out['Subject'];
array_push($array, $res);
}

$try0 = $con->query("SELECT tablename FROM `$second` WHERE Subject = '$array[0]'");
$end0 = $try0->fetch_assoc();
$end = $end0['tablename'];

$try1 = $con->query("SELECT tablename FROM `$second` WHERE Subject = '$array[1]'");
$end1 = $try1->fetch_assoc();
$ends = $end1['tablename'];

$sql1 = $con->query("SELECT COUNT(DISTINCT(Date)) AS TOTAL1 FROM $end WHERE Name = '$third' AND RollNo = '$fourth' AND attendance_status = 'Present'");
$sql2 = $con->query("SELECT COUNT(DISTINCT(Date)) AS TOTAL2 FROM $end");

$sql3 = $con->query("SELECT COUNT(DISTINCT(Date)) AS TOTAL1 FROM $ends WHERE Name = '$third' AND RollNo = '$fourth' AND attendance_status = 'Present'");
$sql4 = $con->query("SELECT COUNT(DISTINCT(Date)) AS TOTAL2 FROM $ends");

$res1 = $sql1->fetch_assoc();
$res2 = $sql2->fetch_assoc();
$res3 = $sql3->fetch_assoc();
$res4 = $sql4->fetch_assoc();
?>
<html>
	<head>
	  <meta charset="utf-8">
    	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
    	<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
		<link rel="stylesheet" href="/resources/demos/style.css">
		<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
		<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
		<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
    	<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
	</head>
		<body>
			<table class="table table-stripped">
				<tr>
					<th>Serial No.</th>
					<th>Subject</th>
					<th>Total Lectures Attended</th>
					<th>Total Lectures</th>
					<th>Percentage</th>
				</tr>
				<tr>
					<td>1.</td>
					<td><?php echo $array[0]; ?></td>
					<td><?php echo $res1['TOTAL1'];?></td>
					<td><?php echo $res2['TOTAL2'];?></td>
					<td><?php $a=$res1['TOTAL1']/$res2['TOTAL2']*100; echo round($a, 2) . "%"?></td>
				</tr>
				<tr>
					<td>2.</td>
					<td><?php echo $array[1]; ?></td>
					<td><?php echo $res3['TOTAL1'];?></td>
					<td><?php echo $res4['TOTAL2'];?></td>
					<td><?php $a=$res3['TOTAL1']/$res4['TOTAL2']*100; echo round($a, 2) . "%"?></td>
				</tr>
			</table>
			<form action="attendance1.php?email=<?php echo $first?>&class=<?php echo $second;?>&fname=<?php echo $third;?>&rollno=<?php echo $fourth;?>" method="POST">
				Start Date: <input type="text" name="startdate" id="datepicker1" placeholder="Select date here" required><br><br>
				End Date: <input type="text" name="enddate" id="datepicker2" placeholder="Select date here" required><br><br>
				<input type="Submit" value="Submit" class = "btn btn-primary">
			</form>
			<br><h2><a href = "index.php?email=<?php echo $first;?>" style = "font-family: monospace; font-size: 25px; text-decoration: none; color: #007BFF;"><-- DashBoard!</a><h2>

			<script>

			var date = new Date();

    		var month = date.getMonth();
    		var day = date.getDate();
    		var year = date.getFullYear();

    		$(document).ready(function (){
    		$("#datepicker1").datepicker({
    		dateFormat: 'yy-mm-dd',
     		maxDate : new Date(year, month, day)
			});
			});

			var date = new Date();

    		var month = date.getMonth();
    		var day = date.getDate();
    		var year = date.getFullYear();

    		$(document).ready(function (){
    		$("#datepicker2").datepicker({
    		dateFormat: 'yy-mm-dd',
     		maxDate : new Date(year, month, day)
			});
			});

			</script>

		</body>
</html>