-
Notifications
You must be signed in to change notification settings - Fork 0
/
view_stud_teach.php
94 lines (79 loc) · 1.88 KB
/
view_stud_teach.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
<?php
include"database.php";
session_start();
if(!isset($_SESSION["TID"]))
{
echo"<script>window.open('index.php?mes=Access not granted','_self');</script>";
}
?>
<!DOCTYPE html>
<html>
<head>
<title>ASP - Admin </title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<?php include"navbar.php";?><br>
<div id="section">
<h3 class="text">Welcome <?php echo $_SESSION["TNAME"]; ?></h3><br><hr><br>
<div class="content">
<h3 >View Student Details</h3><br>
<?php
if(isset($_GET["mes"]))
{
echo"<div class='error'>{$_GET["mes"]}</div>";
}
?>
<table border="1px" >
<tr>
<th>S.No</th>
<th>Roll No</th>
<th>Name</th>
<th>Father Name</th>
<th>DOB</th>
<th>Gender</th>
<th>Phone</th>
<th>Mail</th>
<th>Address</th>
<th>Class</th>
<th>Sec</th>
<th>Delete</th>
</tr>
<?php
$s="select * from student where TID={$_SESSION["TID"]}";
$res=$db->query($s);
if($res->num_rows>0)
{
$i=0;
while($r=$res->fetch_assoc())
{
$i++;
echo"
<tr>
<td>{$i}</td>
<td>{$r["RNO"]}</td>
<td>{$r["NAME"]}</td>
<td>{$r["FNAME"]}</td>
<td>{$r["DOB"]}</td>
<td>{$r["GEN"]}</td>
<td>{$r["PHO"]}</td>
<td>{$r["MAIL"]}</td>
<td>{$r["ADDR"]}</td>
<td>{$r["SCLASS"]}</td>
<td>{$r["SSEC"]}</td>
<td><a href='stud_delete.php?id={$r["ID"]}' class='btnr'>Delete</a><td>
</tr>
";
}
}
else
{
echo "No Record Found";
}
?>
</table>
</div>
</div>
<?php include"footer.php";?>
</body>
</html>