
      <?php 
            include "headers.php"; 
            include "config.php"; 
            $id=$_GET['id'];
    if(isset($_POST['course_id'])){
        if(empty($_FILES['upload_image']['name'])){
       $file_name =$_POST['old_img'];
        
        }else{
          $errors = array();
          $file_name = $_FILES['upload_image']['name'];
          $file_size = $_FILES['upload_image']['size'];
          $file_tmp = $_FILES['upload_image']['tmp_name'];
          $file_type = $_FILES['upload_image']['type'];
          $file_ext = end(explode(".",$file_name));
          $extensions = array("jpeg","jpg","png");
            if(in_array($file_ext,$extensions) === false)
             {
            $errors[] = "This extension file not allowed, Please choose a JPG or PNG file.";
             }
            if($file_size > 2097152){
            $rerrors[] = "File size must be 2mb or lower.";
            $_SESSION['status'] = "File size must be 2mb or lower!";
            $_SESSION['status_code'] = "error";
            header("location:{$hostname}/admin/add_course.php");
            }
            if(empty($errors) == true){
              move_uploaded_file($file_tmp,"../images/courses/".$file_name);
            }else{
            print_r($errors);
            header("location:{$hostname}/admin/add_course.php");
            
            }
          }
  
        $course_name = mysqli_real_escape_string($conn,$_POST['c_name']);
        $desc = mysqli_real_escape_string($conn,$_POST['desc']);
        $cat= mysqli_real_escape_string($conn,$_POST['cat']);
        $co_id=mysqli_real_escape_string($conn,$_POST['course_id']);
        function clean($string) {
                $string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.
                  
                  return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
                }
         $slug=clean($course_name);
            $sql1 = "update  courses set  course_name='$course_name',description='$desc',image='$file_name',slug='$slug',cat_id='$cat' where id='$co_id'";
      $update = mysqli_query($conn,$sql1);
      if($conn->affected_rows == 1){
        $_SESSION['status'] = "Data Update Successfully";
        $_SESSION['status_code'] = "success";
        echo "Data Updated Successfully";
        header("location:{$hostname}/admin/add_course.php");
      }else{
        // $_SESSION['status'] = "Data not updated";
        // $_SESSION['status_code'] = "error";
        header("location:{$hostname}/admin/add_course.php");
      }
    }
        ?>
            <?php
              $sql1 = "SELECT * FROM courses where id='$id'";
                $result1 = mysqli_query($conn, $sql1) or die("Query Failed.");
                if(mysqli_num_rows($result1) > 0){
                    while($sh = mysqli_fetch_assoc($result1)){
            ?>
 
                 <!-- Add Edit & Update Category Details -->


                 <div class="container">
                
                    <!-- The Modal -->
                      <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                        
                          <!-- Modal Header -->
                          <div class="modal-header">
                            <!-- <h4 class="modal-title"></h4> -->
                            <button type="button" class="close" data-dismiss="modal">&times;</button>
                          </div>
                          
                          <!-- Modal body -->
                                <div class="modal-body">
                            <div class="container" id="addDetails">
                                <h4>Add Course</h4>
                              <form action="" method="POST" enctype="multipart/form-data">

                              <div class="form-group row">
                                    <label class="col-sm-4 col-form-label">Status</label>
                                <div class="col-sm-8">
                                    <select class="select_category_name" name="cat">
                                        <option selected value="" disabled>Select a Category</option>
                                         <?php
                                                $sql2 = "SELECT * FROM course_category ORDER BY id";
                                                $result2 = mysqli_query($conn, $sql2) or die("Query Failed.");
                                                while($row2 = mysqli_fetch_assoc($result2)){
                                            ?>
                                            <option <?php if( $sh['cat_id']== $row2['id'] ){ echo'selected';} ?> value="<?php echo $row2['id']; ?>"><?php echo $row2['cat_name']; ?></option>
                                     <?php } ?>
                                     </select>
                                <span class="banner_tag_line1Error AllError" style="color: red;"></span>
                                  </div>
                               </div>
                              <div class="form-group row">
                                    <label class="col-sm-4 col-form-label">Course Name</label>
                                <div class="col-sm-8">
                                     <input type="text" id="" class="InputField" name="c_name" value="<?php echo $sh['course_name']; ?>" placeholder="Course Name..">
                                     <span class="banner_tag_lineError AllError" style="color: red;"></span>
                                  </div>
                               </div>   
                               <div class="form-group row">
                                    <label class="col-sm-4 col-form-label">Course Image</label>
                                <div class="col-sm-8">
                                     <label for="upload_image" class="btn btn-primary btn-block btn-outlined" value="" style="background: #fff; color: #2a2828; text-align:left; font-weight: 500;">Please Upload Course Image<i class="fas fa-upload" style="float: right;"></i></label>
                                     <input type="file" id="upload_image" class="InputField" name="upload_image" accept="image/*" placeholder="Image File Upload.."style="display: none">
                                     <input type="hidden" class="InputField" name="old_img" accept="image/*" value="<?php echo $sh['image']; ?>" placeholder="Image File Upload.."style="display: none">
                                     <span class="upload_imageError AllError" style="color: red;"></span>
                                   </div>
                                </div> 
                                <input type="hidden" name="course_id" value="<?php echo $sh['id'] ?>" >
                                    <div class="form-group row">
                                     <label class="col-sm-12 col-form-label">Course Description</label>
                                <div class="col-sm-12">
                                    <textarea id="ShortDes" class="" name="desc" rows="6" placeholder="Please Short Description Text.."><?php echo $sh['description']; ?></textarea>
                                     <span class="ShortDesError AllError" style="color: red;"></span>
                                 </div>
                                </div>
                                <input type="submit" class="submit" value="Submit" name="add">
                              </form>
                            </div>
                            
                
                        
                        </div>
                          
                          <!-- Modal footer -->
                          <div class="modal-footer">
                            
                          </div>
                          
                        </div>
                      </div>
                  </div>
                  
      
            <!-- End Edit Category Details -->


        </div>
    </div>
    <?php } } ?>

    <!-- jQuery CDN - Slim version (=without AJAX) -->
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
    <!-- Popper.JS -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.0/umd/popper.min.js"></script>
    <!-- Bootstrap JS -->
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>

    <!-----For Toggle Menu------->
    <script type="text/javascript">
        $(document).ready(function() {
            $('#sidebarCollapse').on('click', function() {
                $('#sidebar').toggleClass('active');
            });
        });
    </script>

    <!-----Data Table for------->
    <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="//cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
    <script src="//cdn.datatables.net/1.10.22/js/dataTables.bootstrap4.min.js"></script>
    <script src="//cdn.datatables.net/fixedheader/3.1.7/js/dataTables.fixedHeader.min.js"></script>

    <script>
        $(document).ready(function() {
            var table = $('#viewProducts').DataTable({
                fixedHeader: true,
                language: {
                searchPlaceholder: "Search Here..."
            }
            });
            $("#viewProducts").wrap("<div style='width:100%; overflow:scroll; overflow-y: hidden; overflow-x: scroll;'></div>");
        });
    </script>
    <!-----Data Table for------->



    <!-----Model Popup box------->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

    <!----Tooltrip ---->
    <script>
        $(function() {
            $('[data-toggle="tooltip"]').tooltip()
        })
    </script>
    
    <!-----For Toggle SideBar Menu------->
    <script type="text/javascript">
        $(document).ready(function() {
            $("#master").click(function(){
                $("#master_details").toggle();
            }); 
            $("#company_profile").click(function(){
                $("#company_profile_details").toggle();
            });
            $("#product_profile").click(function(){
                $("#product_profile_details").toggle();
            });
            $("#services_profile").click(function(){
                $("#services_profile_details").toggle();
            });
            $("#quality_profile").click(function(){
                $("#quality_profile_details").toggle();
            });
            $("#gallery_page").click(function(){
                $("#gallery_page_details").toggle();
            });
            $("#career_page").click(function(){
                $("#career_page_details").toggle();
            });
            $("#news_update").click(function(){
                $("#news_update_details").toggle();
            });
            $("#contact_profile").click(function(){
                $("#contact_profile_details").toggle();
            });
            $("#MenuIcon").click(function(){
               $(".ShowMenu").toggle();
            });
        });
        </script>
 

</body>

</html>