team-40/teacher-dash.php at master · CFGIndia20/team-40 · 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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta http-equiv="X-UA-Compatible" content="ie=edge">
        <title>Teacher dashboard</title>
        <!-- Custom fonts for this template-->
        <link href="assets/vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
        <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">

        <!-- Custom styles for this template-->
        <link href="css/sb-admin-2.css" rel="stylesheet">

    </head>
      <body>
        <nav class="navbar navbar-expand-lg navbar-light  sticky border-0 shadow-lg my-5" style="margin: 0 !important";>
            <div class="col-md-9">
                <a class="navbar-brand" href="#">THE/<span class="text-my-color">NUDGE FOUNDATION</span></a>
            </div>
            <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>

            <div class="col-md-3">
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">

                        <li class="nav-item">
                            <a class="nav-link" href=#> Logged in as an teacher</a>
                        </li>


                        <li class="nav-item">
                            <a class="nav-link " href="index.php">DASHBOARD</a><!--Change link-->
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <div class="container-fluid">

    <!-- Page Heading -->
    <div class="d-sm-flex align-items-center justify-content-between mb-4">
        <h1 class="h3 mb-0 text-gray-800">Dashboard</h1>
        <a href="stud-asess.html" class="d-none d-sm-inline-block btn btn-sm btn-warning shadow-sm" style="margin-top:10px;"><i class="fas fa-download fa-sm text-white-50"></i> Student Assessment</a>
    </div>
    <h1 class="h3 mb-0 text-gray-800">Batches assigned</h1>


      <!-- Content Row -->


    <div class="row">
        <?php
        require_once "app/init.php";
            $con = mysqli_connect("localhost","root","","nudge");
            $get_batch_query = "select Batch_id from timetable where Teacher_id='1'";
            $batch_queries = mysqli_query($con,$get_batch_query);
            $tot_row = mysqli_num_rows($batch_queries);
            if($tot_row>0){
                while($row= mysqli_fetch_row($batch_queries)){
                    $batchid=$row[0];
                    //echo $batchid;
                    $get_curr_batch_query = "select * from batch where Batch_id='$batchid'";
                    $curr_batch = mysqli_query($con,$get_curr_batch_query);
                    $curr_batch=mysqli_fetch_row($curr_batch);
                    $get_student_query = "select * from studentbatch where Batch_id=$batchid";
                    $student_queries = mysqli_query($con,$get_student_query);
                    $tot_row_stud = mysqli_num_rows($student_queries);
                    echo '<div class="col-xl-3 col-md-6 mb-4">
        <div class="card border-left-warning shadow h-100 py-2">
          <div class="card-body">
            <div class="row no-gutters align-items-center">
              <div class="col mr-2">
                <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Batch id:' .$curr_batch[0].'</div>
                <div class="h5 mb-0 font-weight-bold text-gray-800">Start Date:' .$curr_batch[1].'</div><br>
                <div class="h5 mb-0 font-weight-bold text-gray-800">Start time:' .$curr_batch[2].'</div><br>
                <div class="h5 mb-0 font-weight-bold text-gray-800">End time:' .$curr_batch[3].'</div><br>
                <div class="h5 mb-0 font-weight-bold text-gray-800">No of students:' .$tot_row_stud.'</div><br>

              </div>
              <div class="col-auto">
                <i class="fas fa-calendar fa-2x text-gray-300"></i>
              </div>
            </div>
          </div>
        </div>
      </div>';
                }
            }
        ?>


              <h1 class="h3 mb-0 text-gray-800">Batches Taught</h1><br>
              <br>

              <div class="col-xl-3 col-md-6 mb-4">
                <div class="card border-left-warning shadow h-100 py-2">
                  <div class="card-body">
                    <div class="row no-gutters align-items-center">
                      <div class="col mr-2">
                        <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Batch id</div>
                        <div class="h5 mb-0 font-weight-bold text-gray-800">Start Date</div><br>
                        <div class="h5 mb-0 font-weight-bold text-gray-800">Start time</div><br>
                        <div class="h5 mb-0 font-weight-bold text-gray-800">End time</div><br>

                        <div class="h5 mb-0 font-weight-bold text-gray-800">No of students</div><br>
                      </div>
                      <div class="col-auto">
                        <i class="fas fa-calendar fa-2x text-gray-300"></i>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
              </div>
              </div>
            </div>
              </body>
              </html>