
      <?php 
            include "headers.php"; 
            include "config.php"; 
            $id=$_GET['id'];
    if(isset($_POST['update'])){
       
      $checkBox =$_POST['course'];
      $coll =$_POST['coll_name'];
      $sql1 = mysqli_query($conn,"DELETE from college_course where  college='$coll'");
    foreach($checkBox as $sub_cat_id=>$sub_cat_det)
    {
        $co = trim($sub_cat_det['co']);
      $sql1 = "INSERT INTO college_course set  college='$coll',course='$co'";
            if(mysqli_query($conn,$sql1)){
                $_SESSION['status'] = "Add Course Successfully";
                $_SESSION['status_code'] = "success";
                header("location:{$hostname}/admin/College_course.php");
            }
    }
      }
        ?>
            <?php
            $col=$_GET['coll'];
              $sql1 = "SELECT * FROM college_course where id='$id' OR college='$col' limit 1";
                $result1 = mysqli_query($conn, $sql1) or die("Query Failed.");
                if(mysqli_num_rows($result1) > 0){
                    while($sh = mysqli_fetch_assoc($result1)){
                        $college_id=$sh['college'];
            ?>
 
                 <!-- 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 Courses </h4>
                              <form action="" method="POST" enctype="multipart/form-data">
                                <div class="form-group row">
                                    <label class="col-sm-4 col-form-label">Select Colleges</label>
                                <div class="col-sm-8">
                                    <?php
                                                $sql2 = "SELECT * FROM colleges where id='$college_id' ORDER BY id";
                                                $result2 = mysqli_query($conn, $sql2) or die("Query Failed.");
                                                $row2 = mysqli_fetch_assoc($result2);
                                         ?>
                                     <input type="text" class="select_category_name" name="" value="<?php echo $row2['college_name'] ?>" readonly="">
                                     <input type="hidden" class="select_category_name" name="coll_name" value="<?php echo $row2['id'] ?>">
                                     <span class="banner_tag_lineError AllError" style="color: red;"></span>
                                  </div>
                               </div>
                                    <div class="form-group row">
                                     <label class="col-sm-12 col-form-label">Select Course</label>
                                                                            <?php
                                                                            
                                                  $sql4 = "SELECT * FROM college_course where college='$col'";
                                                $result4 = mysqli_query($conn, $sql4) or die("Query Failed.");
                                                
                                                $sql3 = "SELECT * FROM courses ORDER BY id";
                                                $result3 = mysqli_query($conn, $sql3) or die("Query Failed.");
                                                $i=1;
                                                while($row3 = mysqli_fetch_assoc($result3)  ){
                                                    $i++;
                                                    $sho = mysqli_fetch_assoc($result4);
                                            ?>
                                <div class="col-sm-12">
                                    <input type="checkbox" name="course[<?php echo $row['id']; ?>][co]" value="<?php echo $row3['id'];?>" <?php if($sho['course']==$row3['id']){echo "checked='checked'";} ?>>
                                    <label class="col-sm-4 col-form-label"><?php echo $row3['course_name']; ?></label>
                                 </div>
                                 <?php } ?>
                                </div>
                                <input type="submit" class="submit" value="Submit" name="update">
                              </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>