<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php' ?>

<?php include 'includes/topbar.php'; ?>

        <!-- page content -->
        <div class="right_col" role="main">
          <div class="">

            <div class="clearfix"></div>

            <div class="row">
              <div class="col-md-12 col-sm-12 ">
                <div class="x_panel">
                  <div class="x_title">
                    <h2>Nursery Students which  Haven't pay July fee</h2>
                    <ul class="nav navbar-right panel_toolbox">
                      <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                      </li>
                    </ul>
                    <div class="clearfix"></div>
                  </div>
                  <div class="x_content">
                      <div class="row">
                          <div class="col-sm-12">
                            <div class="card-box table-responsive">
                    <table  id="datatable-buttons" class="table table-striped table-bordered" style="width:100%">
                      <thead>
                        <tr>
                          <th>Full Name</th>
                          <th>Class</th>
                          <th>Live Place</th>
                          <th>Bording/Day</th>
                          <th>Registered Date</th>
                          <th>Status</th>
                        </tr>
                      </thead>
                      <tbody>
                      	<?php  
							include 'connection.php';
							$select = "SELECT * FROM students WHERE jul = '' AND cl = 'NURSERY' ";
							$sql = mysqli_query($conn,$select);
							$k=1;
							while ($fetch = mysqli_fetch_object($sql)) {
						?>
                        <tr>
                          <td><?php echo $fetch->fn ?></td>
                          <td><?php echo $fetch->cl ?></td>
                          <td><?php echo $fetch->lp ?></td>
                          <td><?php echo $fetch->st ?></td>
                          <td><?php echo $fetch->dt ?></td>
                          <td style="color: red;">Not Paid</td>
                        </tr>
                        <?php 
                        	$k++;
                        	}
                         ?>

                       
                      </tbody>
                    </table>
                  </div>
                </div>
              </div>
            </div>
                </div>
              </div>


        <!-- /page content -->

<?php include 'includes/footer.php'; ?>