-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathstu_details.php
57 lines (56 loc) · 1.57 KB
/
stu_details.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
<?php
include('Connect.php');
include('index_back.php');
include('navbar_student.html');
@$student = $_SESSION['s_id'] or die("Session Expired !! Login Again");
?>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="css/stu_details.css">
</head>
<body>
<div class="container" >
<table>
<thead>
<tr>
<th scope="col">Student Name</th>
<th scope="col">Student ID</th>
<th scope="col">Group Status</th>
</tr>
</thead>
<tbody>
<?php
$i=1;
$division =$_SESSION['division'];
$dept = $_SESSION['dept'];
$res = mysqli_query($Connect," SELECT * FROM `student` WHERE `division`='$division' and `dept` = '$dept' ");
while ($row=mysqli_fetch_array($res)) {
$F_name = $row['F_name'];
$M_name = $row['M_name'];
$L_name = $row['L_name'];
$Full_name=" {$F_name} {$M_name} {$L_name} ";
$s_id = $row['s_id'];
$active = $row['active'];
if($active == 1){
$grp_status = 'Joined';
}
else{
$grp_status = 'Available';
}
?>
<tr>
<td data-label="Student Name"><?php echo $Full_name ?></td>
<td data-label="Student ID"><?php echo $s_id ?></td>
<td data-label="Group Status"><?php echo $grp_status ?></td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
</div>
</body>
</html>