-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathrequest.php
112 lines (88 loc) · 3.31 KB
/
request.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
<html>
<head>
<style type="text/css">
a li
{ margin-top: 1px;
color: #E0E0E0;
text-align: center;
}
a li:hover
{
font-weight: bold;
color: #ffffff;
;
}
hr.style-two {
border: 0;
height: 1px;
background-image: linear-gradient(to right, rgba(0, 0, 0, 0), rgb(245,255,250)
, rgba(0, 0, 0, 0));
}
.material-icons
{
vertical-align: -5px; /*Change this to adjust the icon*/
}
.button1{
display:inline-block;
width:8em;
height:2em;
background: #cfd8dc;
border-style: solid;
border-width: 1px;
border-color: #424242;
color:#333;
line-height:2;
text-align:center;
text-decoration:none;
font-weight:500;
border-radius: 10px;
margin-left: 20px;
}
.button1:hover{
background:#424242;
color: white;
border-color: #cfd8dc;
}
</style>
<!--Import Google Icon Font-->
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<!--Import materialize.css-->
<link type="text/css" rel="stylesheet" href="css/materialize.min.css" media="screen,projection"/>
<!--Let browser know website is optimized for mobile-->
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
</head>
<body background="images/background.jpg" height="100" >
<!--Import jQuery before materialize.js-->
<script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script type="text/javascript" src="js/materialize.min.js"></script>
</body></html>
<?php
session_start();
include("teacher_nav.php");
include("database.php");
//echo "Welcome to teacher<br>";
$email = $_SESSION['email'];
$teacherquery = mysqli_query($con,"select * from teacherdetails where email='$email' ");
$teacherrow = mysqli_fetch_row($teacherquery);
$requestquery = mysqli_query($con, "select * from userdetails where approval=4 and subject=$teacherrow[5]");
if(mysqli_num_rows($requestquery)>0)
{
echo "<center><h1>New Registrations</h1>";
echo "<table border='2' style='width:50%; border: 3px solid black; background-color:#eee' >";
echo "<th style='width:50%; border: 3px solid black; background-color:#000; color:#fff' >Student name</th>";
echo "<th width='50%' style='width:50%; border: 3px solid black; background-color:#000; color:#fff'>Verify</th>";
while($row= mysqli_fetch_row($requestquery))
{
echo "<tr>";
echo "<td style='align-content: center; width:50%; border: 3px solid black; color:#000'>$row[1]</td>";
echo "<td style='border: 3px solid black; color:#000'><a class='button1' href='yesverify.php?email_std=$row[4]'>Yes</a>\t<a class='button1' href='noverify.php?email_std=$row[4]'>No</a></td>";
echo "</tr>";
}
echo "</table>";
echo "</center>";
}
else
{
echo "<center>No new Requests</center>";
}
?>