-
Notifications
You must be signed in to change notification settings - Fork 0
/
search_class.php
78 lines (65 loc) · 2.93 KB
/
search_class.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
<?php include('header_dashboard.php'); ?>
<?php include('session.php'); ?>
<body>
<?php include('navbar_teacher.php'); ?>
<div class="container-fluid">
<div class="row-fluid">
<?php include('teacher_sidebar.php'); ?>
<div class="span6" id="content">
<div class="row-fluid">
<!-- breadcrumb -->
<ul class="breadcrumb">
<?php
$sy = $_POST['school_year'];
$school_year_query = mysqli_query($conn,"select * from school_year where school_year = '$sy'")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="#"><?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-left"></div>
</div>
<div class="block-content collapse in">
<div class="span12">
<ul id="da-thumbs" class="da-thumbs">
<?php $query = mysqli_query($conn,"select * from teacher_class
LEFT JOIN class ON class.class_id = teacher_class.class_id
LEFT JOIN subject ON subject.subject_id = teacher_class.subject_id
where teacher_id = '$session_id' and school_year = '$school_year' ")or die(mysqli_error());
while($row = mysqli_fetch_array($query)){
$id = $row['teacher_class_id'];
?>
<li>
<a href="my_students.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>
<a href="#<?php echo $id; ?>" data-toggle="modal"><i class="icon-trash"></i> Remove</a>
</li>
<?php include("delete_class_modal.php"); ?>
<?php } ?>
</ul>
</div>
</div>
</div>
<!-- /block -->
</div>
</div>
<?php include('teacher_right_sidebar.php') ?>
</div>
<?php include('footer.php'); ?>
</div>
<?php include('script.php'); ?>
</body>
</html>