bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
require_once 'header.php';
require_once 'navbar.php';

$query = "SELECT * FROM round_km_limit LIMIT 1";
$result = $conn->query($query);
$km_limit = $result->fetch_assoc();

if (isset($_POST['km_limit'])) {
  $km_limit = $_POST['km_limit'];
  $sql = "UPDATE round_km_limit SET km_limit = '$km_limit'";

if ($conn->query($sql)) {
    echo '<script>alert("Save Changes Successfully");location.href="round_km_limit";</script>';
  } else {
    echo '<script>alert("Something Wrong");</script>';
  }

}
?>

<div class="container-fluid pt-8">
  <div class="page-header mt-0 p-3">
    <h3 class="mb-sm-0">ROUND WAY KM LIMIT</h3>

</div>
            
            <div class="row">
              <div class="col-12">
                <div class="card shadow">
                
                  <div class="p-4">
                    <div class="grid-margin">
                      <div class="">
                        <div class="table-responsive">
                          <table id="example" class="text-center table card-table table-vcenter text-nowrap  align-items-center">
                            <thead>
                              <tr>
                                <th style="width: 80px">S.No</th>
                                <th>Km Limit</th>
                                <th style="width: 150px"> &nbsp;&nbsp;&nbsp;&nbsp;Action</th>
                              </tr>
                            </thead>
                            <tbody>
                              <?php 
                              $show = "SELECT * FROM round_km_limit";
                              $result = $conn->query($show);
                                while ($row = $result->fetch_assoc()) { ?>
                                  <tr>
                                    <td>1</td>
                                    <td><?=$row['km_limit'];?></td>
                                    <td><button type="button" id="edit-btn" name="edit" class="btn btn-success" data-toggle="modal" data-target="#edit-keys"><i class="fa fa-edit btn-success"></i></button>
                                    </td>
                                  </tr>
                                <?php } ?>
                              </tbody>
                            </table>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>

<div class="modal fade" id="edit-keys">
              <div class="modal-dialog">
                <div class="modal-content">
                  <div class="card-header">
                    <h4 style="text-align: left;">Edit Km Limit <span id="alert1"></span></h4>
                  </div>
                  <form method="post">
                    <div class="modal-body">
                      <div class="row">
                        <div class="col-md-12">
                          <label>Km Limit</label>
                          <input type="number" class="form-control" name="km_limit" id="km_limit" value="<?=$km_limit['km_limit'];?>" required="required"
                          autofocus>
                        </div>
                      </div>
                      <br/>
                      <div class="modal-footer">
                        <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
                        <button type="submit" name="save_key_btn" id="save_key_btn" class="btn btn-primary">save Changes</button>
                      </div>
                    </div>
                  </form>
                </div>
              </div>
              
            </div>
            <?php
            require_once 'footer.php';
            // require_once 'jslinks.php';
            ?>
            <script src="assets/plugins/jquery/dist/jquery.min.js"></script>
<script src="assets/js/popper.js"></script>
<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js"></script>

<script src="assets/plugins/chart.js/dist/Chart.min.js"></script>
<script src="assets/plugins/chart.js/dist/Chart.extension.js"></script>

<script src="assets/plugins/datatable/jquery.dataTables.min.js"></script>
<script src="assets/plugins/datatable/dataTables.bootstrap4.min.js"></script>
<script src="assets/plugins/datatable/dataTables.responsive.min.js"></script>
<script src="assets/plugins/datatable/responsive.bootstrap4.min.js"></script>

<script src="assets/plugins/toggle-sidebar/js/sidemenu.js"></script>

<script src="assets/plugins/customscroll/jquery.mCustomScrollbar.concat.min.js"></script>

<script src="assets/js/custom.js"></script>
<script src="assets/js/datatable.js"></script>