-
Notifications
You must be signed in to change notification settings - Fork 0
/
relief.php
142 lines (126 loc) · 6.02 KB
/
relief.php
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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
<!DOCTYPE html>
<html>
<head>
<!-- BASICS -->
<meta charset="utf-8">
<title>Relief System - Anula Vidyalaya</title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="js/rs-plugin/css/settings.css" media="screen">
<link rel="stylesheet" type="text/css" href="css/isotope.css" media="screen">
<link rel="stylesheet" href="css/flexslider.css" type="text/css">
<link rel="stylesheet" href="js/fancybox/jquery.fancybox.css" type="text/css" media="screen">
<link rel="stylesheet" href="css/bootstrap.css" type="text/css">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Noto+Serif:400,400italic,700|Open+Sans:300,400,600,700">
<link rel="stylesheet" type="text/css" href="css/style.css">
<!-- skin -->
<link rel="stylesheet" type="text/css" href="skin/default.css">
<!-- =======================================================
Theme Name: Vlava
Theme URL: https://bootstrapmade.com/vlava-free-bootstrap-one-page-template/
Author: BootstrapMade.com
Author URL: https://bootstrapmade.com
======================================================= -->
</head>
<body>
<script src="main.js"></script>
<section id="header" class="appear"></section>
<div class="navbar navbar-fixed-top" role="navigation" data-0="line-height:100px; height:100px; background-color:rgba(0,0,0,0.3);" data-300="line-height:60px; height:60px; background-color:rgba(5, 42, 62, 1);">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="fa fa-bars color-white"></span>
</button>
<div class="navbar-logo">
<a href="index.html"><img data-0="width:90px;" data-300=" width:50px" src="img/logo.png" alt=""></a>
</div>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav" data-0="margin-top:20px;" data-300="margin-top:5px;">
<li class="active"><a href="#">Absentees</a></li>
<li><a href="#view-timetable">View Timetable</a></li>
<li><a href="#relief">Relief</a></li>
</ul>
</div>
<!--/.navbar-collapse -->
</div>
</div>
<section class="section pad-bot30 bg-white" style="height:inherit">
<div class="container" style="margin-top: 50px;">
<?php
$num = $_GET['num_list'];
$date = date("Y/m/d");
$day = date("l");
$con = mysqli_connect('localhost','root',null,'anula');
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}else{
mysqli_select_db($con,'anula');
echo "<h4>List of absent teachers.</h4>"
echo "<table class='teacher_table'><tr><th>ID</th><th>Name of the teacher</th></tr>";
foreach ($num as $id){
$sql="SELECT * FROM teachers WHERE TeacherID=".$id;
$result = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($result)) {
$sql1 = "SELECT * FROM timetable WHERE TeacherID=".$row['TeacherID']." AND day=".$day;
$result1 = mysqli_query($con,$sql1);
echo "<tr><td>".$row['TeacherID']."</td><td>".$row['Initials']." ".$row['OtherNames']." ".$row['LastName']."</td></tr>";
while($row1 = mysql_fetch_array($result1)){
}
}
}
echo "</table>";
}
?>
</div>
</section>
<section id="footer" class="footer_new" style="position:absolute !important; padding-top: 15px;">
<div class="container">
<div class="row animated opacity mar-bot20" data-andown="fadeIn" data-animation="animation">
<div class="col-sm-12 align-center">
<ul class="social-network social-circle">
<li><a href="#" class="icoFacebook" title="Facebook"><i class="fa fa-facebook"></i></a></li>
<li><a href="#" class="icoTwitter" title="Twitter"><i class="fa fa-twitter"></i></a></li>
<li><a href="#" class="icoGoogle" title="Google +"><i class="fa fa-google-plus"></i></a></li>
<li><a href="#" class="icoLinkedin" title="Linkedin"><i class="fa fa-linkedin"></i></a></li>
</ul>
</div>
</div>
<div class="row align-center copyright">
<div class="col-sm-12">
<p>Copyright © All rights reserved</p>
</div>
</div>
<div class="credits">
<!--
All the links in the footer should remain intact.
You can delete the links only if you purchased the pro version.
Licensing information: https://bootstrapmade.com/license/
Purchase the pro version with working PHP/AJAX contact form: https://bootstrapmade.com/buy/?theme=Vlava
-->
Designed by <a href="https://bootstrapmade.com/">Ashirwada Dayarathne</a>
</div>
</div>
</section>
<a href="#header" class="scrollup"><i class="fa fa-chevron-up"></i></a>
<!-- Javascript Library Files -->
<script src="js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
<script src="js/jquery.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.isotope.min.js"></script>
<script src="js/jquery.nicescroll.min.js"></script>
<script src="js/fancybox/jquery.fancybox.pack.js"></script>
<script src="js/skrollr.min.js"></script>
<script src="js/jquery.scrollTo.min.js"></script>
<script src="js/jquery.localScroll.min.js"></script>
<script src="js/stellar.js"></script>
<script src="js/jquery.appear.js"></script>
<script src="js/jquery.flexslider-min.js"></script>
<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyD8HeI8o-c1NppZA-92oYlXakhDPYR7XMY"></script>
<!-- Contact Form JavaScript File -->
<script src="contactform/contactform.js"></script>
<!-- Template Main Javascript File -->
<script src="js/main.js"></script>
</body>
</html>