timetable/view_classes.php at main · Flexsidee/timetable · GitHub

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
<?php include'header.php'; ?>
<div class="pcoded-content">
    <div class="pcoded-inner-content">

        <div class="main-body">
            <div class="page-wrapper">

                <div class="page-header">
                    <div class="row align-items-end">
                        <div class="col-lg-8">
                            <div class="page-header-title">
                                <div class="d-inline">
                                    <h4>Classes</h4>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-4">
                            <div class="page-header-breadcrumb">
                                <ul class="breadcrumb-title">
                                    <li class="breadcrumb-item">
                                        <a href="index.html"> <i class="feather icon-home"></i> </a>
                                    </li>
                                    <li class="breadcrumb-item"><a href="#!">Classes</a>
                                    </li>
                                    <li class="breadcrumb-item"><a href="#!">View Classes</a>
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="page-body">
                    <div class="row">
                        <div class="col-sm-12">


                            <div class="card">
                                <div class="card-header">
                                    <h5>View all the Classess you have</h5>
                                </div>
                                <div class="card-block">
                                    <div class="dt-responsive table-responsive">
                                    <table id="basic-btn" class="table table-striped table-hover table-bordered nowrap">
                                            <thead>
                                                <tr class="table-danger">
                                                    <th>#</th>
                                                    <th>Deparment Name</th>
                                                    <th>Deparment Code</th>
                                                    <th>Level</th>
                                                    <th>Population</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                    $sql =mysqli_query($db, "select * from class");
                                                    while($classes = $sql -> fetch_assoc()){
                                                        $dept=mysqli_fetch_assoc(mysqli_query($db, "select * from department where department_id=".$classes['department_id']));
                                                        $level=mysqli_fetch_assoc(mysqli_query($db, "select * from level where level_id=".$classes['level_id']));
                                                ?>
                                                <tr>
                                                    <td><?php echo $classes['class_id']; ?></td>
                                                    <td><?php echo $dept['department_name']; ?></td>
                                                    <td><?php echo $dept['dept_code']; ?></td>
                                                    <td><?php echo $level['level_name']; ?></td>
                                                    <td><?php echo $classes['population']; ?></td>
                                                </tr>
                                                <?php } ?>
                                            </tbody>
                                            <tfoot>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Deparment Name</th>
                                                    <th>Deparment Code</th>
                                                    <th>Level</th>
                                                    <th>Population</th>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                </div>
                            </div>


                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php include'footer_view.php'; ?>