<?php include('header.php') ?>
        <div class="breadcrumb-top">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                <li class="breadcrumb-item active"><a href="#">Edit Category</a></li>
                <!---<li class="breadcrumb-item active">Accessories</li> -->
            </ol>
        </div>
        <!--------------------------------Start main body section----------------------------------->
        <div class="col-lg-12">
            <div class="primary-panel">
                <div class="heading">
                    <h2>Edit Category</h2>
                </div>
                    <?php                  
                         $id= $_REQUEST['sid'];
                         $sql="SELECT * FROM `category`  WHERE `category_id`='$id' ";
                         $run=mysqli_query($db,$sql); 
                             $data=mysqli_fetch_assoc($run);
                             $category_id=$data['category_id']; 
                              $category_name=$data['category_name'];
                                
                        ?>

                <form method="post" class="editForm" action="" enctype="multipart/form-data">
                    <div class="row">
                    <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Category Name</label>
                                <input type="text"  name="category_name" class="form-control" value="<?php echo $category_name ;?>" required="">
                            </div>
                        </div> 
                        
                        <div class="col-lg-12">
                            <button type="submit" name="submit" class="btn btn-primary">Update</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!----------------------------------End Main body Section----------------------------------->      
    </div>
</div>
<?php include('footer.php') ?>
<!----- search script code start here--------->
<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script>
    $(document).ready(function(){
      /* Search table */
      
      $("#myInput").on("keyup", function() {
        var value = $(this).val().toLowerCase();
        $("#myTable tr").filter(function() {
          $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
        });
      });
      /* Export table */
      $('#export-table').click(function(){
        $("#myTable").table2excel({
            filename: "Users.xls"
        });
      })
    });
</script>

<!-- <script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/additional-methods.min.js"></script>
<script>
jQuery.validator.addMethod("emailfull", function(value, element) {
  return this.optional(element) || /^([a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)*|"((([ \t]*\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))*(([ \t]*\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i.test(value);
 }, "Please enter valid email address!");
 jQuery.validator.addMethod("lettersonly", function(value, element) {
   return this.optional(element) || /^[a-z\s]+$/i.test(value);
 }, "Only alphabetical characters"); 

$(".editForm").validate({
    
  rules: {
    name: {
      required: true,
      lettersonly: true
    },
    role: {
      required: true,
      lettersonly: true
    },
    email: {
      required: true,
      emailfull: true
    },
    mobile: {
      required: true,
      number: true,
        minlength: 11,
        maxlength: 11
    },
    password: {
      required: true,
      
    },
    
    status: {
      required: true,
      
    }
  },
});
</script> -->


<!----------- search script code end here----->
<?php 
     if(isset($_POST['submit'])){    
        $category_name= $_POST['category_name'];
         

         $admin_query="UPDATE `category` SET `category_name`='$category_name'   WHERE `category_id`='$id' ";
        
         $run= mysqli_query($db,$admin_query);
     
    echo "<script> alert('Category Updated Successfuly.')</script>";
    echo "<script> window.open('category.php','_self')</script>";
         
    
     }
?>