-
Notifications
You must be signed in to change notification settings - Fork 0
/
dashboard_student.php
88 lines (73 loc) · 3.31 KB
/
dashboard_student.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
<?php include('header_dashboard.php'); ?>
<?php include('session.php'); ?>
<body>
<?php include('navbar_student.php'); ?>
<div class="container-fluid">
<div class="row-fluid">
<?php include('student_sidebar.php'); ?>
<div class="span9" id="content">
<div class="row-fluid">
<!-- breadcrumb -->
<ul class="breadcrumb">
<?php
$school_year_query = mysqli_query($conn,"select * from school_year order by school_year DESC")or die(mysqli_error());
$school_year_query_row = mysqli_fetch_array($school_year_query);
$school_year = $school_year_query_row['school_year'];
?>
<li><a href="#"><b>My Class</b></a><span class="divider">/</span></li>
<li><a href="#">School Year: <?php echo $school_year_query_row['school_year']; ?></a></li>
</ul>
<!-- end breadcrumb -->
<!-- block -->
<div class="block">
<div class="navbar navbar-inner block-header">
<div id="" class="muted pull-right">
<?php $query = mysqli_query($conn,"select * from teacher_class_student
LEFT JOIN teacher_class ON teacher_class.teacher_class_id = teacher_class_student.teacher_class_id
LEFT JOIN class ON class.class_id = teacher_class.class_id
LEFT JOIN subject ON subject.subject_id = teacher_class.subject_id
LEFT JOIN teacher ON teacher.teacher_id = teacher_class.teacher_id
where student_id = '$session_id' and school_year = '$school_year'
")or die(mysqli_error());
$count = mysqli_num_rows($query);
?>
<span class="badge badge-info"><?php echo $count; ?></span>
</div>
</div>
<div class="block-content collapse in">
<div class="span12">
<ul id="da-thumbs" class="da-thumbs">
<?php
if ($count != '0'){
while($row = mysqli_fetch_array($query)){
$id = $row['teacher_class_id'];
?>
<li>
<a href="my_classmates.php<?php echo '?id='.$id; ?>">
<img src ="<?php echo $row['thumbnails'] ?>" width="124" height="140" class="img-polaroid">
<div>
<span>
<p><?php echo $row['class_name']; ?></p>
</span>
</div>
</a>
<p class="class"><?php echo $row['class_name']; ?></p>
<p class="subject"><?php echo $row['subject_code']; ?></p>
<p class="subject"><?php echo $row['firstname']." ".$row['lastname']?></p>
</li>
<?php }}else{ ?>
<div class="alert alert-info"><i class="icon-info-sign"></i> You are currently not enroll to your class</div>
<?php } ?>
</ul>
</div>
</div>
</div>
<!-- /block -->
</div>
</div>
</div>
<?php include('footer.php'); ?>
</div>
<?php include('script.php'); ?>
</body>
</html>